MCQOPTIONS

Explore topic-wise MCQs in Oracle (MCQ) questions and answers.

This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.

1.	Which view describes all clusters in the database?
A.	DBA_CLUSTER_HASH_EXPRESSIONS
B.	DBA_CLUSTERS
C.	DBA_CLUSTERS_ALL
D.	DBA_CLUSTERS_INFO
Answer» C. DBA_CLUSTERS_ALL

2.	You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?
A.	Use the external table population
B.	Use the Oracle Data Pump export and import utility
C.	Use the conventional path data load of SQL*Loader utility
D.	Use the direct path data load of Oracle export and import utility
Answer» D. Use the direct path data load of Oracle export and import utility

3.	Which command is used to drop HASH cluster?
A.	DROP CLUSTER
B.	DROP HASH CLUSTER
C.	DROP_CLUSTER_HASH
D.	DROP ANY CLUSTER
Answer» B. DROP HASH CLUSTER

4.	What is the reason that SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions?
A.	The User Global Area (UGA) is not configured
B.	The sessions were started using the login name SYS
C.	The sessions are running in the Automatic Shared Memory Management mode
D.	The sessions are running in the automatic Program Global Area (PGA) memory management mode
Answer» D. The sessions are running in the automatic Program Global Area (PGA) memory management mode

5.	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.	SIZE
C.	HASHKEYS
D.	All mentioned above
Answer» E.

6.	In which of these situations hashing is not advantageous?
A.	Applications frequently perform full-table scans on the table and the table is sparsely populated
B.	You cannot afford to preallocate the space that the hash cluster will eventually need
C.	You cannot afford to preallocate the space that the hash cluster will eventually need
D.	All mentioned above
Answer» E.

7.	Which SYSTEM privilege must be used to create a cluster in another user's schema?
A.	CREATE ANY CLUSTER
B.	CREATE ANY SCHEMA CLUSTER
C.	CREATE SCHEMA CLUSTER
D.	CREATE CLUSTER
Answer» B. CREATE ANY SCHEMA CLUSTER

8.	For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .
A.	Prime Number
B.	ODD Number
C.	Null
D.	None of the above
Answer» B. ODD Number

9.	You can create any cluster and associated cluster index in any tablespace that is _____ .
A.	OFFLINE
B.	CLOSED
C.	CURRENTLY ONLINE
D.	OPEN
Answer» D. OPEN

10.	In a sorted hash cluster, the rows corresponding to each value of the hash function are sorted on a specified set of columns in which order and that can improve response time during subsequent operations on the clustered data?
A.	Descending order
B.	Ascending Order
C.	Equal
D.	None of the above
Answer» C. Equal

11.	What alternative does a hash cluster provide to a non-clustered table?
A.	Index
B.	Index Cluster
C.	Both A & B
D.	None of the above
Answer» D. None of the above

12.	When you drop a single table from a cluster, the database deletes which row of the table?
A.	Column data
B.	Row data
C.	Each row
D.	Only deletes few data
Answer» D. Only deletes few data

13.	Which of these must be performed to find or store a row in an indexed table or cluster?
A.	One or more I/Os to find or store the key value in the index
B.	Another I/O to read or write the row in the table or cluster
C.	Both A & B
D.	None of the above
Answer» D. None of the above