Oracle 1z0-068 問題集

質問 1：
Examine the output of the asmcmd and srvct1 commands:

Then you execute this command:
$ srvctl relocate asm - currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown?
A. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.
B. It fails because the ASM instance has not been shut down first on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
D. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
E. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
F. It fails because an ASM instance is not configured to run on HOST02.
正解：A,C,E

質問 2：
Which two statements are true about clustered ASM instances? (Choose two.)
A. The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.
B. An ASM instance must store its SPFILE in ASM.
C. The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.
D. The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.
E. The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.
正解：B,C

質問 3：
Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?
A. It's enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.
C. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.
D. The service's connection load balancing goal must be manually configured to enable server-side connect-time load balancing.
E. It is based on performance metrics provided by the database instances LREG processes.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which two utilities support the "what-if" command evaluation?
A. asmcmd
B. crsctl
C. ocrconfig
D. oifcfg
E. srvctl
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about Oracle Enterprise Manager Topology Viewer?
A. It displays which listeners listen on behalf of which instances.
B. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
C. It displays the relationship between targets of different target types in a cluster.
D. It displays the status of all cluster components.
E. It displays the type of network used by RAC database instance.
F. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.
正解：A,C,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements are true about ASM Cloud File System (ACFS) replication?
A. One site of an ACFS replication configuration can be host both primary and standby file systems.
B. ACFS auditing information is replicated from the primary file system to the standby file system.
C. Standby redo log files are required on the standby site for synchronous redo transport.
D. The privilege SYSREPL has been introduced for ACFS replication.
E. Replication is automatically terminated if the primary file system has less than 2GB free space.
正解：A,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
A. The source PDB must use a global temporary tablespace.
B. The source PDB must be in READ ONLY mode on all CDB instances.
C. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
E. All running CDB instances must be open in restricted mode.
F. The source PDB must be closed on the CDB instance from where the command is executed.
正解：B,C,D

質問 8：
Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true?
A. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the node hosting the service.
B. Clusterware will monitor the service while it is active.
C. When manually started, the service will always start on one or more available instances rather than on their preferred instances.
D. The service must be manually started with SRVCTL after a planned restart of the instance hosting the service.
E. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)