1Z0-053 試験問題を無料オンラインアクセス

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.
Given below are some of the commands required to achieve this:
1.SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?

• A.1, 4, 3, 2, 5
• B.2, 3, 4, 5, 1
• C.4, 5, 2, 3, 1
• D.1, 4, 2, 3, 5
• E.1, 4, 5, 2, 3

What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)

• A.selection of SQL plan baselines
• B.creation of bitmap, function-based, and B-tree indexes
• C.partitioning of tables and indexes
• D.optimization of materialized views for maximum query usage and fast refresh
• E.creation of index-organized tables

You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?

• A.It will display a list of files that need backup after five days
• B.It will apply the current retention policy to determine the files that need to be backed up
• C.It will display a list of files that were backed up in the last five days
• D.It will display a list of files that have not been backed up in the last five days
• E.It will display a list of files that need incremental backup

View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.
Which statement is true about the block corruption detected by the command?
Exhibit:

• A.No action is taken except the output in the Exhibit.
• B.The failure is logged into the Automatic Diagnostic Repository (ADR).
• C.The corruption is repaired by the command implicitly.
• D.The ADVISE FAILURE command is automatically called to display the repair script.

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline.
Which action would you take before performing this task?

• A.Decrease the window size for the baseline.
• B.Decrease the expiration time for the baseline.
• C.Take an immediate AWR snapshot.
• D.Compute the baseline statistics.