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

This section includes 6 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.

What are the Memory Structures subdivided as?

A. SGA
B. PGA
C. Sort Area
D. All mentioned above
Answer» E.
Discussion
2.

You want to protect your database from single point of failure by multiplexing the control file. Your database is started using SPFILE. You have to perform the following tasks, Give the correct order in which these tasks to be performed.1. Shut down the database instance.2. Copy the control file to new location.3. Configure the CONTROL_FILES parameter.4. Restart the instance.

A. 3, 2, 1, 4
B. 3, 1, 2, 4
C. 3, 2, 1, 4
D. 2, 3, 1, 4
Answer» C. 3, 2, 1, 4
Discussion
3.

You specified extent management as local for a tablespace. How will it affect space management in the tablespace?

A. All the extents will be of the same size
B. Bitmap will be used to record free and allocated extents
C. Free extents will be managed by the data dictionary tables
D. The tablespace will be system managed and the users cannot specify the extent size
Answer» C. Free extents will be managed by the data dictionary tables
Discussion
4.

Which initialization parameter Defines the location of the default file system directory for redo log files and control file creation when no file specification is given in the creation operation?

A. DB_CREATE_FILE_DEST
B. DB_CREATE_ONLINE_LOG_DEST_n
C. DB_RECOVERY_FILE_DEST
D. None of the above
Answer» C. DB_RECOVERY_FILE_DEST
Discussion
5.

In the Oracle Database which file contain the information needed to maintain and verify database integrity, and include the names of all the Data Files and the online and archived log files?

A. Data Files
B. Control Files
C. Redo Log Files
D. Temp Files
Answer» C. Redo Log Files
Discussion
6.

What is the default size of an Oracle-managed redo log file?

A. 50MB
B. 100MB
C. 60MB
D. 120MB
Answer» C. 60MB
Discussion