Reduce Disk I/O | Process   «Prev  Next»
 

Oracle Table Reorganization - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following are common causes of chained rows? Please select all the correct answers.
  A. Row length exceeds db_block_size
  B. Rows are expanded after an UPDATE
  C. PCUSED is set too high
  D. PCTFREE is set too high and rows are expanded with UPDATEs

2. Under which conditions is it beneficial to physically re-sequence table rows? Please select all the correct answers.
  A. In tables that access rows via ROW ID
  B. In tables that access rows via full-table scans with ORDER BY
  C. In tables that access rows via index range scans
  D. In tables where a single index is used by the majority of queries

3. Which of the following are valid methods for reorganizing tables? Please select all the correct answers.
  A. Export-import
  B. Spooled row data and SQL*Loader
  C. Parallel query
  D. CTAS