Category: 1Z0-052 (v.1)

Exam 1Z0-052 ,Oracle Database 11g: Administration I (update June 23th, 2013)

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

You want to enable archiving on your database. Presently, the database is running in
NOARCHIVELOG 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. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.

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

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 you
observe suboptimal execution plans for the queries on these objects after two days of statistics
collection. The optimizer statistics retention period is set to its default value.
Which action would help to use the previous set of statistics on the objects?


Page 1 of 2112345...1020...Last »