Free 1Z1-052 Questions for Oracle Database 11g: Administration I 1Z1-052 Exam as PDF & Practice Test Engine

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

Exam Questions: 285
Updated On: Jun 01, 2026

Question #1

Note the following points describing various utilities in Oracle Database 11g:
Which point describes the Oracle Data Pump utility?
1. It enables the transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3 . It enables the loading of data from an external file into tables of an Oracle Database
4 . It provides a tape backup management for the Oracle ecosystem

A. 4

B. 1, 2, 3 and 4

C. 1 and 3

D. 1

E. 2

F. 3

Discussion 0

Correct Answer: D Vote an answer

Question #2

Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the previous day. Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.)

A. Use the AWR Compare Periods report.

B. Use an ADDM analysis between 7 PM and 9 PM of the previous day.

C. Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.

D. Use the Active Session History report.

Discussion 0

Correct Answer: A,B Vote an answer

Question #3

View the Exhibit and examine the output of the query.

What do you infer from this?

A. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.

B. The instance is started, but the database is not yet open.

C. The server parameter file (SPFILE) was used to start the instance.

D. The SGA_TARGET is a static parameter.

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which two statements about the background process of the database writer are true?
(Choose two.)

A. It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.

B. It writes dirty buffers, if any, to data files whenever a transaction commits.

C. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.

D. It is possible to have multiple database writers in an Oracle instance.

Discussion 0

Correct Answer: C,D Vote an answer

Question #5

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A. Lock statistics for the tables.

B. Set the STATISTICS_LEVEL parameter to BASIC.

C. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

D. Change STALE_PERCENT to zero for the tables.

E. Set the TIMED_STATISTICS parameter to TRUE.

Discussion 0

Correct Answer: A Vote an answer

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

Question #6

Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)

A. An SPFILE is a binary file

B. An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database

C. An SPFILE can store changes persistently across instance restarts

D. An SPFILE can be read by the database server, but it is not written to by the server

E. An SPFILE cannot reside on a client

F. An SPFILE cannot contain static parameters

Discussion 0

Correct Answer: A,C,E Vote an answer

Question #7

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

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

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

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

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

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

Discussion 0

Correct Answer: A,D Vote an answer

Question #8

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
What would be your next step to improve performance?

A. Run the SQL Access Advisor

B. Run the memory Advisor for the SGA

C. Run the memory advisor for the shared pool

D. Run the memory Advisor for the PGA

E. Run the memory advisor for the buffer cache

Discussion 0

Correct Answer: C Vote an answer

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

Free 1Z1-052 Questions for Oracle Database 11g: Administration I 1Z1-052 Exam as PDF & Practice Test Engine

Download Free Oracle 1Z1-052 Demo