> > Oracle MCQs > Managing Clusters MCQs

Managing Clusters MCQ

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

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

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

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

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

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

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

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

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

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

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