Explore topic-wise MCQs in ORACLE.

This section includes 55 Mcqs, each offering curated multiple-choice questions to sharpen your ORACLE knowledge and support exam preparation. Choose a topic below to get started.

51.

Quiesced state, in the sense that no ongoing non-DBA transactions, queries, fetches, or PL/SQL statements are running in the system.

A. True
B. False
Answer» B. False
Discussion
52.

In Run Scripts to build data dictionary views which script Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views, Grants PUBLIC access to the synonyms?

A. CATALOG.SQL
B. CATPROC.SQL
C. Both A & B
D. None of the above
Answer» B. CATPROC.SQL
Discussion
53.

Which view would you query at this stage to investigate this missing control file?

A. V$INSTANCE
B. V$CONTROLFILE
C. DBA_CONTROL_FILES
D. V$DATABASE_PROPERTIES
Answer» C. DBA_CONTROL_FILES
Discussion
54.

Abbreviate the term CSS?

A. Command Synchronization Services
B. Cluster Synchronization Services
C. Command Synchronization Statement
D. Cluster Synchronization Statement
Answer» C. Command Synchronization Statement
Discussion
55.

Configuration parameters such as MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES affect control file size.

A. True
B. False
Answer» B. False
Discussion