RelationalDBDesign RelationalDBDesign



Index Organized  «Prev  Next»

Advantages Disadvantages of Indexed Tables - Quiz

Select the best answer or answers for each question.
 

1. Which of the following are advantages of index-organized tables?
Please select all the correct answers.
  A. Fewer I/Os to retrieve data
  B. Can access data directly on disk
  C. Less space for storage of table, as compared to a normal table and index combination
  D. No backup required for index-organized tables

2. Which of the following is not a disadvantage of index-organized tables?
Please select the best answer.
  A. Cannot have table in a cluster
  B. Cannot use partitions with the table
  C. Cannot have a primary key
  D. Cannot have any additional indexes on the table

3. Which of the following types of applications are appropriate for using index-organized tables?
Please select all the correct answers.
  A. Order entry applications
  B. OLAP applications
  C. Information retrieval applications
  D. Human resource applications