Oracle 1z0-063 問題集

質問 1：
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:

What is the outcome of the import?
A. It fails because RMAN is not connected to the target database with DBID=1423241.
B. It succeeds but the database is not automatically registered in the RC12c catalog.
C. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
D. It fails because the target database and recovery catalog database are of different versions.
正解：D

質問 2：
Which three are true about Transparent Data Encryption (TDE)? (Choose three.)
A. It stores the current and all past master keys in the keystore.
B. It encrypts only data on the client.
C. It replaces secure application roles.
D. It uses a single master key for a database.
E. It can encrypt data at the column level.
F. Master encryption keys are managed by Oracle Database Vault.
正解：A,E,F

質問 3：
You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
A. Database Replay
B. SQL Performance Analyzer
C. Active Session History (ASH) report
D. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
正解：D

質問 4：
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. The other_groups group is not included in the resource plan.
B. The pending area is automatically submitted when creating plan directives.
C. The sys_group group is not included in the resource plan.
D. Pending areas can not be validated until submitted.
E. The procedure must be executed before creating any plan directive.
正解：A

質問 5：
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)
A. RMAN Media Management Library
B. Enterprise Manager Cloud Control
C. RMAN recovery catalog
D. Oracle Secure Backup
E. Enterprise Manager Database Express
正解：B,C

質問 6：
Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)
A. creating an SPFILE for the target database
B. connecting to an auxiliary instance
C. matching the database identifier (DBID) of the source database and the duplicate database
D. connecting to the target database and a recovery catalog to execute the DUPLICATE command
E. creating a password file for an auxiliary instance
正解：D,E