Exam information

Exam 1Z0-052 ,Oracle Database 11g: Administration I (November 7th, 2014)

Other exams

Which two actions resolve the issue?

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

Oracle Database Recovery Manager (RMAN) backup and restore operations

Identify the memory component from which memory may be allocated for:1. Session memory for the shared server2. Buffers for I/O slaves3. Oracle Database Recovery Manager (RMAN) backup and restore operations


Which two statements are true about the SALES_DATA tablespace?

You executed the following command to create a tablespace calledSALES_DATA:SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACEMANAGEMENT AUTO;Which two statements are true about the SALES_DATA tablespace? (Choose two.)

which of the scenario will the DBA perform recovery?

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

Which is the correct sequence of steps for accomplishing the task?

You want to enable archiving on your database. Presently, the database is running inNOARCHIVELOG mode. Given below are the steps to accomplish the task in random order:1. Shut down the instance.2. Execute the ALTER DATABASE ARCHIVELOG command.3. Start up the instance and mount the database.4. […]

What is the location of the alert_orcl.log file?

You want to check the details of few errors that users have reported. You search for the alert log fileand execute few commands to find the location of the alert log file. View the Exhibit and check thecommands executed. What is the location of the alert_orcl.log file?See the Exhibit:

Which statements are true regarding the USERS tablespace?

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

Which two will be the implications of these values in your database?

Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET=0LOG_CHECKPOINT_INTERVAL=0Which two will be the implications of these values in your database? (Choose two.)

What is the impact of this setting?

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

Which action would help to use the previous set of statistics on the objects?

You have recently collected statistics on certain objects of a schema in your database. But youobserve suboptimal execution plans for the queries on these objects after two days of statisticscollection. The optimizer statistics retention period is set to its default value. Which action […]

Page 1 of 2312345...1020...Last »