Database Components   «Prev  Next»

Oracle SQL Extensions - Quiz

SQL*Plus and Oracle's extensions to SQL

Select the best answer or ansewrs for each question.
 
1. Oracle's data dictionary views can be used to:
Please select the best answer.
  A. Store your data within relational tables
  B. Analyze the size of your table
  C. Look at contents of a row in your table
  D. Set privileges on your table

2. Which of the following components are included in the server side of Oracle's software?
Please select all the correct answers.
  A. SQL*Plus
  B. Enterprise Manager
  C. Pre-compiler
  D. Net8

3. Which kind of Database Administrator task CANNOT be performed in SQL*Plus?
Please select the best answer.
  A. Create a new user.
  B. Delete ten rows from a table.
  C. Shut down the database.
  D. Add an index to a table.

4. Why would you set the FLAGGER on when creating a query in SQL*Plus?
Please select the best answer.
  A. To debug Oracle extensions found in the query
  B. To see all errors found in the syntax of the query
  C. To insure that the query meets ANSI/ISO standards
  D. To create the query without Oracle extensions