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

View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'on PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?

• A.Pending areas can not be validated until submitted.
• B.The other_groups group is not included in the resource plan.
• C.The procedure must be executed before creating any plan directive.
• D.The pending area is automatically submitted when creating plan directives.
• E.The sys_group group is not included in the resource plan.

You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A.The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
• B.Corrupted blocks, if any, are repaired in the backup created.
• C.Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D.Only those data files that have corrupted blocks are backed up.

For which three pieces of information can you use the RMAN LIST command? (Choose three.)

• A.backups that are marked obsolete according to the current retention policy
• B.backups of tablespaces
• C.stored scripts in the recovery catalog
• D.backup sets and image copies that are obsolete
• E.available archived redo log files

You take your database backups by using the RMAN media management interface (MMI).
Which two are true about the use of the RMAN MMI? (Choose two.)

• A.You can use it to create backup sets for database files.
• B.You can use it to create image copies for entire file systems.
• C.You can use it to create proxy copies for database files.
• D.You can use it to create proxy copies for entire file systems.
• E.You can use it to create image copies for database files.

Your database instance is started using an SPFILE. You are connected to CDB$ROOT, as a DBA.
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)

• A.It is immediately set to ALL in the SPFILE and the CDB instance.
• B.It is set to ALL for all PDBs only in the SPFILE.
• C.It is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter is not set.
• D.It is immediately set to ALL only for CDB$ROOT.
• E.It is immediately set to ALL in only those pluggable databases (PDBs) where the value is set to TYPICAL.