Oracle Database 11g: Administration I - 1Z0-052 Exam Questions [2026]

QUESTION NO: 1
What function is performed by the System Monitor (SMON) background process in a database instance?

A. It performs recovery when a user process fails. B. It monitors memory space allocation only within the System Global Area (SGA). C. It performs instance recovery when failed database instance is restarted. D. It monitors memory space allocation within the SGA and the Program Global Area (PGA).

Correct Answer: C

QUESTION NO: 2
Which statement is true about the Manageability Monitor (MMON) background process?

A. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance. B. It coordinates the rebalance activity for disk groups when ASM is used. C. It transfers statistics from memory to disk at regular intervals. D. It performs dynamic memory management when Automatic Shared Memory
Management is enabled for the database instance.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are read.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data files are checked for consistency.
7 . Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

A. 7, 1, 5, 2, 3, 6 step 4 is not required B. 7, 1, 5, 2, 3, 6, 4 C. 1, 5, 7, 2, 3, 6; step 4 is not required D. 1, 2, 3, 5, 6, 4; step 7 is not required

Correct Answer: A

QUESTION NO: 4
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file?

A. Take the USERS tablespace offline and re-create the lost data file B. Shutdown the instance, restores all the database files from the last consistent backup and restart the database instance C. Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online D. Shutdown the instance, restore the data file from the last consistent backup and restart the database instance

Correct Answer: B

QUESTION NO: 5
View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace NDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces.
What happens to the new DML operations in this scenario?
Exhibit:

A. The DML commands will fail B. The undo data generated by the DML is stored in one of the two other undo tablespace C. The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace D. The undo data generated by the DML will overwrite the extents that contain committed undo data

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
Which statement is true regarding undo tablespace?

A. Undo tablespace can consist of only one data file that is reused in a cyclic fashion. B. Only one undo tablespace can exist in a database. C. Undo tablespace is a temporary tablespace. D. Multiple undo tablespace can exist in a database but only one can be active at a time.

Correct Answer: D

QUESTION NO: 7
Which is the correct description of a pinned buffer in the database buffer cache?

A. The buffer is empty and has not been used B. The buffer is currently being accessed C. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk D. The contents of the buffer have changed and must be flushed to the disk by the DBWn process

Correct Answer: B

QUESTION NO: 8
Which two are true about the Data Recovery Advisor? (Choose two.)

A. It can be used when a database IS OPEN B. It can be used to validate RMAN backups C. It can be used only with databases that are running in ARCHIVELOG mode D. It can be used when a database IS MOUNTED E. It can be used to take RMAN backups F. It can repair only databases for which RMAN backups exist

Correct Answer: B,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 9
Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance?

A. The sessions are not affected and continue to function normally B. The sessions are not allowed to perform any operations till the listener is started C. The sessions are terminated and the active transactions are rolled back D. The sessions are able to perform only queries

Correct Answer: A

QUESTION NO: 10
Which two are true about AWR snapshots? (Choose two.)

A. They are not generated if STATISTICS_LEVEL is set to TYPICAL. B. They are always created automatically. C. They can be modified by using DMLs. D. They are stored in the SYSAUX tablespace. E. They can be retained forever.

Correct Answer: B,C

QUESTION NO: 11
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it.
Which constraints will remain enabled by default during this operation? (Choose all that apply.)

A. CHECK B. PRIMARY KEY C. NOT NULL D. FOREIGN KEY E. UNIQUE

Correct Answer: B,C,E

QUESTION NO: 12
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully B. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT C. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT D. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session E. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

Correct Answer: D

QUESTION NO: 13
Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench?

A. invoking the Data Recovery Advisor and SQL Repair Advisor B. invoking the SQL Test Case Builder C. Creating a service request with My Oracle Support D. gathering metadata from the Automatic Diagnostic Repository (ADR)

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 14
Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to
'/u01/oracle/db01'.
The parameters, DB_CREATE_ONLINE_LOG_DEST_n and
DB_RECOVERY_FILE_DEST, are not specified.
Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)

A. archived redo logs B. RMAN backups C. control files D. temp files E. redo logs F. audit logs G. data files H. audit files

Correct Answer: C,E,F,G

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).