Clustering Tables   «Prev  Next»

Creating Cluster Key - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following steps is not necessary to create a working cluster?
Please select the best answer.
  A. Create the cluster
  B. Create the tables that will be in the cluster
  C. Create the cluster index
  D. Create a foreign key constraint between the tables in the cluster

2. If you drop the cluster index of an indexed cluster, what is the effect on the cluster's tables?
Please select the best answer.
  A. INSERT, UPDATE, and DELETE statements are blocked until the cluster index is recreated, but existing rows can still be read
  B. All data already stored in the cluster is immediately and permanently lost
  C. SELECT statements against the cluster are blocked until the cluster index is recreated
  D. Nothing changes; a cluster index has no effect on how the cluster's tables can be used

3. Which types of data might be appropriate for use in a cluster?
Please select all the correct answers.
  A. All data is appropriate for a cluster
  B. Tables with a master-detail relationship
  C. Tables where the cluster key is frequently updated
  D. Data usually retrieved by selecting a value from a cluster key

4. Which Oracle error indicates that a DML statement was attempted against a clustered table before its cluster index was created?
Please select the best answer.
  A. ORA-11544
  B. OCI-02032
  C. ORA-02455
  D. ORA-00942

5. In the USER_INDEXES data dictionary view, which INDEX_TYPE value identifies a cluster index?
Please select the best answer.
  A. NORMAL
  B. BITMAP
  C. CLUSTER
  D. DOMAIN