> > Oracle MCQs > Managing Clusters MCQs

Managing Clusters MCQ

1. In a(n) ____ cluster, every server in the cluster performs useful work.

Symmetric server

Performance

Mobility

Accessibility

Answer

Correct Answer: Symmetric server

Note: This Question is unanswered, help us to find answer for this one

2. 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?

HASH IS

HASHKEYS

Size

All

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

3. Disk I/O is reduced and access time improves for joins of clustered tables?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

4. To create a cluster in another user's schema you must have which SYSTEM privilege?

CREATE ANY SCHEMA CLUSTER

CREATE CLUSTER

CREATE ANY CLUSTER

CREATE SCHEMA CLUSTER

Answer

Correct Answer: CREATE ANY CLUSTER

Note: This Question is unanswered, help us to find answer for this one

5. 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?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

6. Which view describes all clusters in the database?

DBA_CLUSTERS_INFO

DBA_CLUSTERS

DBA_CLUSTER_HASH_EXPRESSIONS

DBA_CLUSTERS_ALL

Answer

Correct Answer: DBA_CLUSTERS

Note: This Question is unanswered, help us to find answer for this one

7. You can alter an existing cluster to change which of the following settings?

Physical attributes (INITRANS and storage characteristics)

There is no default degree of parallelism

None

The average amount of space is not required to store all the rows for a cluster key value (SIZE)

Answer

Correct Answer: Physical attributes (INITRANS and storage characteristics)

Note: This Question is unanswered, help us to find answer for this one

8. You can create any cluster and associated cluster index in any tablespace that is?

ONLINE

Can be OFFLINE and ONLINE

OFFLINE

OPEN

Answer

Correct Answer: ONLINE

Note: This Question is unanswered, help us to find answer for this one

9. You can drop HASH cluster using which command from the following?

DROP CLUSTER

DROP ANY CLUSTER

DROP HASH

DROP_CLUSTER_HASH

Answer

Correct Answer: DROP CLUSTER

Note: This Question is unanswered, help us to find answer for this one

10. You Choose Appropriate Tables for the Cluster for which the following conditions are true?

Records from the tables are frequently queried together or joined

Records from the tables are not frequently queried together or joined

The tables are primarily queried--that is, tables that are not predominantly inserted into or updated

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

Answer

Correct Answer: 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

Note: This Question is unanswered, help us to find answer for this one

11. To create a cluster index, one of the following conditions must be true?

Your schema contains the cluster

You have the CREATE ANY INDEX system privilege

Your schema does not contain cluster

Your schema contains the cluster And You have the CREATE ANY INDEX system privilege

Answer

Correct Answer: Your schema contains the cluster And You have the CREATE ANY INDEX system privilege

Note: This Question is unanswered, help us to find answer for this one

Oracle MCQs | Topic-wise

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs