Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”

Quiz

The following quiz questions refer to the Oracle examples shown in this chapter.

1:From which two sources can you generate SQL scripts?
2:Will the following SQL statement work? Will the generated output work? 
SQL> SET ECHO OFF
SQL> SET FEEDBACK OFF
SQL> SPOOL CNT.SQL
SQL> SELECT 'COUNT(*) FROM  ' || TABLE_NAME || ';'
  2  FROM CAT
  3  /
3:Will the following SQL statement work? Will the generated output work? 
SQL> SET ECHO OFF
SQL> SET FEEDBACK OFF
SQL> SPOOL ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial