Oracle 1Z0-053 Exam Questions & Answers

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

A. It does not allow you to change the moving window size.

B. Adaptive threshold functionalities use it by default to compute statistics.

C. It is created by default with the window size being equal to the AWR retention time.

D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:

1.

Put the tablespaces in backup mode.

2.

Back up the datafiles for all tablespaces.

3.

Take the tablespaces out of backup mode.

4.

Back up all archived redo logs.

Your colleague asks for you to comment on his plan. Which response would be correct?

A. The plan will work as is.

B. The plan needs to be modified to allow for an archive-log switch after step 3.

C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.

D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

E. The plan cannot work as presented.

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. The RVPC user can do which of the following? (Choose all that apply.)

A. Register databases if granted the register database privilege

B. See all databases in the recovery-catalog schema

C. See all database-related metadata in the recovery catalog if they are granted access to that database

D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command

E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes