SQL*Loader   «Prev  Next»

Oracle Database Elements - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. For an ordinary internal heap-organized table, how does SET UNUSED differ from DROP COLUMN?
Please select the best answer.
  A. An unused column remains queryable.
  B. SET UNUSED makes the column inaccessible without immediately removing its stored data; DROP COLUMN physically removes it.
  C. SET UNUSED can always be reversed with SET USED.
  D. Neither operation supports multiple columns.

2. For which items does Oracle 26ai document no separately defined maximum at the stated scope, although broader database and resource limits still apply?
Please select all the correct answers.
  A. Constraints per column
  B. Columns per table
  C. Tables per database
  D. Tablespaces per database

3. Which initialization parameter controls the maximum number of database datafiles that can be opened for a database, subject to platform and other limits?
Please select the best answer.
  A. MAX_COLUMNS
  B. DB_BLOCK_SIZE
  C. DB_FILES
  D. OPEN_CURSORS

4. With MAX_COLUMNS=EXTENDED enabled in a supported Oracle 26ai configuration, what is the maximum number of columns allowed in a table or view?
Please select the best answer.
  A. 1000
  B. 2048
  C. 4096
  D. There is no column limit

5. Which statement removes all columns previously marked UNUSED in app_data, assuming the operation is supported for that table?
Please select the best answer.
  A. ALTER TABLE app_data DROP UNUSED COLUMNS;
  B. ALTER TABLE app_data SET USED;
  C. ALTER TABLE app_data DELETE UNUSED COLUMNS;
  D. TRUNCATE TABLE app_data;