SQL*Loader   «Prev  Next»

Oracle Database Elements - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 

1. What is the main difference between the SET UNUSED COLUMN and the DROP COLUMN clauses of the ALTER TABLE command?
Please select the best answer.
  A. You can view the data in the unused column and you cannot view the data in a dropped column.
  B. You free up space with DROP COLUMN (but not with SET UNUSED COLUMN).
  C. You can use SET UNUSED COLUMN (but not DROP COLUMN) on a primary key column.
  D. You can specify a list of columns with SET UNUSED COLUMN (but not with DROP COLUMN).

2. Which of the following database elements have no maximum limit?
Please select all the correct answers.
  A. Constraints per column
  B. Columns per table
  C. Tables per database
  D. Tablespaces per database

3. Which of the following database elements can be limited by setting an initialization parameter on the database?
Please select the best answer.
  A. Constraints per column
  B. Rows per table
  C. Database files per database
  D. Users per database