Oracle Database 11g Administration I

Here you have the best Oracle 1z0-052 practice exam questions

You have 280 total questions to study from
Each page has 5 questions, making a total of 56 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 16, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 280

You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)

Disable automatic checkpoint tuning

Check the size of the redo log file size and increase the size if it is small

Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

Decrease the number of redo log members if there are more than one redo log members available in each redo log group

Correct Answer: B, C

Question 2 of 280

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.
Exam 1z0-052: Question 2 - Image 1

What is the location of the alert_orcl.log file?

ORACLE_HOME/dbs

ORACEL_HOME/rdbms

/u01/app/oracle/admin/orcl/adump

/u01/app/oracle/flash_recovery_area

ORACLE_BASE/diag/rdbms/orcl/alert

ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Correct Answer: F

Question 3 of 280

See the Exhibit:
Exam 1z0-052: Question 3 - Image 1

Which statements are true regarding the USERS tablespace? (Choose all that apply.)

A bitmap is used to record free extents

Free extents information is managed within the tablespace

Free extents information is managed in the SYSAUX tablespace

The data dictionary tables are updated when extents are allocated or deallocated

Correct Answer: A, B

Question 4 of 280

Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0 -

LOG_CHECKPOINT_INTERVAL=0 -
Which two will be the implications of these values in your database? (Choose two.)

The SGA advisor will be disabled

The MTTR advisor will be disabled

Automatic checkpoint tuning will be disabled

Checkpoint information will not be written to the alert log file

Correct Answer: B, C

Question 5 of 280

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?

Optimizer statistics are collected automatically.

Only timed operating system (OS) statistics and plan execution statistics are collected.

The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

Correct Answer: C