Oracle 1z0-063 問題集

質問 1：
You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

Which two statements are true? (Choose two.)
A. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
B. RMAN must be connected to a recovery catalog for the execution of the command.
C. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
D. The root and seed databases are included in the duplication.
E. A backup of the SALES PDB must exist before the execution of the command.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true? (Choose two.)
A. Only DML and DDL statements will be monitored for the session.
B. All subsequent statements in the session will be treated as one database operation and will be monitored.
C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
D. Database operations will be monitored only when they consume a significant amount of resource.
E. Database operations for all sessions will be monitored.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which four actions are possible during an Online Datafile Move operation? (Choose four.)
A. Performing Block Media Recovery for a data block in the datafile being moved
B. Executing DML statements on objects stored in the datafile being moved
C. Creating and dropping tables in the datafile being moved
D. Querying tables in the datafile being moved
E. Performing file shrink of the data file being moved
F. Flashing back the database
正解：A,B,C,D

質問 4：
One of your multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL> CREATE ROLE C##CONNECT;
SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which three are true? (Choose three.)
A. The C##CONNECT role can be granted different roles and privileges in each PDB.
B. The C##CONNECT role is a local role defined only in CDB$ROOT.
C. C##ADMIN has the orcl123 password in all PDBs.
D. CREATE SESSION is granted to the C##ADMIN user in all PDBs.
E. The C##CONNECT role is granted to the C##ADMIN user in all PDBs.
正解：A,B,E

質問 5：
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
A. authentication by using the local OS of the database server
B. authentication by password file
C. authentication by using certificates over SSL
D. authentication by using the Oracle Internet Directory
正解：B

質問 6：
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?
A. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
B. It fails and returns an error because a connection is not made by using the SYSDBA privilege.
C. It succeeds and displays all the tablespaces that belong to the root database.
D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
正解：A