Database Components   «Prev  Next»

Oracle SQL Extensions - Quiz

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. Oracle Net Services

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. Restart the Oracle Net Listener.
  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

5. Which of the following statements about the SYSTEM tablespace is true?
Please select the best answer.
  A. Any user can create objects in the SYSTEM tablespace by default.
  B. Objects in the SYSTEM tablespace are owned exclusively by SYS and SYSTEM.
  C. The SYSTEM tablespace stores only user-created application tables.
  D. The SYSTEM tablespace can be safely dropped once the database is in production.

6. A colleague queries the view ALL_INDEXES. What will the results show?
Please select the best answer.
  A. Only the indexes your colleague personally created
  B. Every index in the database, regardless of ownership or access
  C. Every index your colleague either created or has access to
  D. Only indexes owned by the DBA role