Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1Z0-052
Exam Name/Title: Oracle Database 11g: Administration I
Certification Provider: Oracle
Corresponding Certification: 11g

Exam Questions: 285
Updated On: Jul 13, 2026

Question #78

Identify the two situations in which you use the alert log file in your database to check the details. (Choose two.)

A. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

B. Running a query on a table returns "ORA-600: Internal Error."

C. Creating a table returns "ORA-00955: name is already used by an existing object."

D. Inserting a value in a table returns "ORA-01722: invalid number."

E. Inserting a row in a table returns "ORA-00060: deadlock detected while waiting for resource."

Discussion 0

Correct Answer: B,E Vote an answer

Question #79

Your database instance is running. db01 is a net service name. You issue a connection request using the following command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?

A. user process

B. server process

C. service name

D. listener

Discussion 0

Correct Answer: D Vote an answer

Question #80

Which are three of the various resources that must be accessible to keep a database open?

A. spfile

B. SYSTEM tablespace

C. control file

D. all members of a redo log group

E. SYSAUX tablespace

Discussion 0

Correct Answer: B,C,E Vote an answer

Question #81

Which two statements are true regarding transactions in an Oracle database? (Choose two.)

A. A transaction is assigned an undo segment when it is started.

B. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

C. Multiple transactions can use the same undo segment.

D. More than one transaction cannot share the same extent in the undo tablespace.

Discussion 0

Correct Answer: A,C Vote an answer

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

Question #82

Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

A. Its findings are accessible only by using Oracle Enterprise Manager

B. it can be used by executing the PL/SQL procedures in the DBMS_ADDM package

C. It provides recommendations to improve database performance

D. It improves database performance by automatically implementing Oracle's best practices

E. It runs automatically after each Automatic Workload Repository snapshot is created

F. It can assist the DBA in diagnosing database instance startup failures

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #83

Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

A. By default, AWR snapshots are taken every 60 minutes

B. AWR data is stored in the SYSTEM tablespace

C. It is the foundation for the self-managing infrastructure

D. The taking of AWR snapshots cannot be disabled

E. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #84

You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?

A. REMAP_SCHEMA

B. SCHEMAS

C. FULL

D. TRANSFORM

E. REMAP_TABLESPACE

Discussion 0

Correct Answer: A Vote an answer

Question #85

Which two statements are true about checkpointing? (Choose two.)

A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.

B. It ensures that all committed data is written to the data files during normal shutdown.

C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.

D. The checkpoint frequency decreases with the smaller redo log file size.

Discussion 0

Correct Answer: B,C Vote an answer

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

Question #86

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

A. An extent cannot spread across data files.

B. A data file can belong to only one tablespace.

C. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

D. A segment cannot spread across data files.

E. A data file can have only one segment created in it.

Discussion 0

Correct Answer: A,B Vote an answer

Question #87

View the Exhibit and examine the initialization parameter settings.

Which three initialization parameters are to be set manually as they are not automatically tuned? (Choose three.)

A. LOG_BUFFER

B. DB_KEEP_CACHE_SIZE

C. SORT_AREA_SIZE

D. DB_16K_CACHE_SIZE

E. STREAMS_POOL_SIZE

F. JAVA_POOL_SIZE

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #88

The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:
1 . Shut down the instance, if not already done.
2 . Copy one of the remaining control files to a new location.
3 . Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
Exhibit:

A. 5, 2, 3, 4; 1 and 6 not required

B. 4, 5, 6, 2, 3; 1 not required

C. 2, 4, 3, 5, 6; 1 not required

D. 1, 2, 4, 3, 5, 6

Discussion 0

Correct Answer: D Vote an answer

Download Free Oracle 1Z0-052 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-052 exam.