Managing Clusters MCQs
Managing Clusters MCQs
Answer these Managing Clusters MCQs and see how sharp is your knowledge of Managing Clusters.
Scroll down and let's start!
1: To create a cluster index, one of the following conditions must be true?
A. Your schema contains the cluster
B. You have the CREATE ANY INDEX system privilege
C. Your schema does not contain cluster
D. Your schema contains the cluster And You have the CREATE ANY INDEX system privilege
2: You Choose Appropriate Tables for the Cluster for which the following conditions are true?
A. Records from the tables are frequently queried together or joined
B. Records from the tables are not frequently queried together or joined
C. The tables are primarily queried--that is, tables that are not predominantly inserted into or updated
D. The tables are primarily queried--that is, tables that are not predominantly inserted into or updated And Records from the tables are frequently queried together or joined
3: You can drop HASH cluster using which command from the following?
A. DROP CLUSTER
B. DROP ANY CLUSTER
C. DROP HASH
D. DROP_CLUSTER_HASH
4: You can create any cluster and associated cluster index in any tablespace that is?
A. ONLINE
B. Can be OFFLINE and ONLINE
C. OFFLINE
D. OPEN
5: You can alter an existing cluster to change which of the following settings?
A. Physical attributes (INITRANS and storage characteristics)
B. There is no default degree of parallelism
C. None
D. The average amount of space is not required to store all the rows for a cluster key value (SIZE)
6: Which view describes all clusters in the database?
A. DBA_CLUSTERS_INFO
B. DBA_CLUSTERS
C. DBA_CLUSTER_HASH_EXPRESSIONS
D. DBA_CLUSTERS_ALL
7: When estimating the size of cluster indexes remember that the index is on each cluster key, not the actual rows. Therefore, each key appears only once in the index?
A. True
B. False
8: To create a cluster in another user's schema you must have which SYSTEM privilege?
A. CREATE ANY SCHEMA CLUSTER
B. CREATE CLUSTER
C. CREATE ANY CLUSTER
D. CREATE SCHEMA CLUSTER
9: Disk I/O is reduced and access time improves for joins of clustered tables?
A. False
B. True
10: When creating a hash cluster, it is important to choose the cluster key correctly and set which of these parameters so that performance and space use are optimal?
A. HASH IS
B. HASHKEYS
C. Size
D. All
11: In a(n) ____ cluster, every server in the cluster performs useful work.
A. Symmetric server
B. Performance
C. Mobility
D. Accessibility
List of Managing Clusters MCQs...
Available in:
Managing Clusters MCQs
