Oracle 1z0-068 問題集

質問 1：
Which three statements are true about ASM Cloud File System (ACFS) auditing?
A. acfsutil audit init must be run by a system administrator.
B. acfsutil audit read marks audit files to indicate that it is safe to purge them.
C. acfsutil audit purge can be run by an audit manager.
D. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
E. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine the output of this command:
ASMCMD> volinfo -G ACFS -a
Diskgroup Name: ACFS
Volume Name: VOL1
Volume Device: /dev/asm/vol1-280
State: ENABLED
Size (MB): 2048
Resize Unit (MB): 32
Redundancy: MIRROR
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u01/app/grid/acfsmount
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command?
A. It succeeds but leaves the filesystem unmounted.
B. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
C. It resizes VOL1.
D. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
E. It fails to resize the filesystem because it must be unmounted before resizing.
正解：A,C

質問 3：
PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open.
PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service -db PROD -pdb PRDPDB1 -service SRVPDB1
$ srvctl start service -db PROD -service SRVPDB1
Which statement is true about the srvctl start service command?
A. It opens the PRDPDB1 PDB if not already opened.
B. It can open the PRDPDB1 PDB only if it is policy managed.
C. It can open the PRDPDB1 PDB only if it is manually managed.
D. It cannot open the PRDPDB1 PDB automatically.
正解：B

質問 4：
Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)
A. They are used to coordinate the next value for a sequence created with the CACHE and ORDER clauses.
B. They are used to coordinate access across multiple library caches for the same stored procedure.
C. They are used when an application uses the DBMS_LOCK package for UL lock types.
D. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.
E. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.
正解：A,B

質問 5：
Which three statements are true about Oracle Clusterware components, architecture, and behavior?
A. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.
B. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing the Oracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.
C. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availability of cluster resources defined in the Oracle Local Repository file (OLR).
D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.
E. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining the availability of the Clusterware stack on a cluster node.
F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).
正解：D,E,F
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?
A. Grid infrastructure must be installed on all cluster nodes.
B. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
C. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.
D. The Clusterware stack must be up on all cluster nodes.
E. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
F. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
正解：A,D

質問 7：
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
A. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
B. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
C. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
D. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
E. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
正解：B,C

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

You execute this command:
$ srvctl modify asm -count 2
All databases on the cluster are running from Oracle 12c homes.
Which statement is true about the outcome of this command?
A. The command fails because the instance count cannot be reduced to less than the minimum value of 3.
B. One ASM instance is shut down and the instance count is reduced by one.
C. The command fails because one ASM instance must be shut down manually before executing the command.
D. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.
正解：B