Performance Tuning  «Prev  Next»

Index-organized Tables in Oracle - Quiz

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

1. Which of the following types of applications are typically appropriate for index-organized tables?
Please select all the correct answers.
  A. OLTP applications
  B. E-commerce applications
  C. Information retrieval applications
  D. OLAP applications

2. Which of the following keywords are associated with an index-organized table?
Please select all the correct answers.
  A. ORGANIZATION
  B. ORGANIZATION INDEX
  C. MOVE
  D. CREATE INDEX_ORGANIZED TABLE

3. Which of the following features are allowed in standard tables but not in index-organized tables?
Please select all the correct answers.
  A. Partitioning
  B. Storage in clusters
  C. Secondary indexes
  D. Bitmapped indexes