Oracle 1z0-068 問題集

質問 1：
Which three statements are true about opatch version 12?
A. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
B. It can only apply patches on the cluster node from where it is issued.
C. It can apply some patches without shutting down database instances.
D. It cannot run with root privileges on a Unix-like system.
E. It can apply patches to a database ORACLE_HOME.
F. It can apply a patchset to a database ORACLE_HOME.
正解：C,E,F

質問 2：
Examine this command and output:

Examine this list of commands:
1. srvct1 convert db -db ron -dbtype rac -node o16n1
2. srvct1 convert db -db ron -dbtype raconenode -node 016n1
3. srvct1 add instance -db ron -instance ron_1 -node 016n1
4. srvct1 add instance -db ron -in5tance ron_2 -node 016n2
5. srvct1 start instance -db ron -instance ron_1
6. srvct1 start instance -db ron -instance ron_2
Currently, there is an instance of database ron running on o16n1.
You want to convert ron to a RAC database and make all instances available.
Identify the commands required, in the correct order, to accomplish this.
A. 1, 4 and 6
B. 1, 3, 4, 5 and 6
C. 2, 4, 5 and 6
D. 1, 4, 5 and 6
E. 2, 4 and 6
F. 2, 3, 4, 5 and 6
正解：B

質問 3：
You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2.
It runs on an eight-node cluster and a serverpool prod_pool has three servers.
Examine these commands executed on HOST01:
$ srvctl add service -db CDB1 -pdb PDB_1 -service HR -serverpool prod_pool
$ srvctl start service -db CDB1 -service HR
$ srvctl stop service -db CDB1 -service HR
Which two statements are true?
A. HR is available on a single instance of prod_pool.
B. HR is uniformly managed across all instances in prod_pool.
C. srvctl stop service prevents logins to any instance of CDB1 using service HR.
D. srvctl stop service prevents logins for HR only to CDB1 on HOST01.
E. srvctl stop service closes PDB_1 on all CDB1 instances.
F. srvctl stop service only closes PDB_1 in the instance on HOST01.
正解：B,C

質問 4：
When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?
A. using DHCP to assign Node Virtual IP addresses for nodes in the cluster
B. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster
C. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster
D. creation of a new GNS for this cluster
E. using Shared GNS running on another cluster
正解：A,C,D

質問 5：
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

質問 6：
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPS.
Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)
A. Use srvctl modify nodeapps to change the VIP on host01.
B. Use oifcfg setif to stop the VIP on host01.
C. Use srvctl start vip to start the VIP on host01.
D. Use oifcfg setif to start the VIP on host01.
E. Use srvctl stop vip to stop the VIP on host01.
正解：A,C,E

質問 7：
A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories.
Which two statements are true about user-created directories?
A. You cannot drop a directory containing aliases unless you delete the aliases first.
B. You cannot create a nested subdirectory /USER1/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn't exist.
C. You can create subdirectories under the USERS directory.
D. You cannot rename a user-created subdirectory.
E. You cannot create a user-defined directory at the root (+) level.
正解：B,E

質問 8：
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?
A. Stage the patch on the cluster node where the OPatch utility will be executed.
B. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.
C. Stage the patch on the cluster nodes.
D. Update the PATH environment variable on the node where will run the OPatch utility to point to the
$ORACLE_HOME/OPatch directory.
正解：D