Oracle 1z0-068 問題集

質問 1：
Which two statements are true about resource profiles for administrator-managed RAC database services?
(Choose two.)
A. It is automatically created when a service is created using DBMS_SERVICE.CREATE_SERVICE.
B. It contains a node list and instance-to-node mapping information for the service.
C. It contains a list of server pools on which the instances hosting the service can run.
D. It is automatically created when a service is created using SRVCTL ADD SERVICE.
E. It specifies the instance to which the service should fail over, if the preferred instance shuts down or fails.
正解：B,D

質問 2：
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c?
A. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
B. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
C. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
D. The upgrade must be done in-place.
E. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
F. The upgrade must be done out of place.
G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
正解：A,B,F,G
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two statements are true regarding ASM Dynamic Volume manager (ADVM)?
A. File systems contained in ADVM volumes may only contain database files.
B. An ADVM volume is individually named and can contain only one file system.
C. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.
D. Only one ADVM volume can be created in an ASM disk group.
E. To create an ADVM volume, disk group attributes COMAPTIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)
A. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
B. Clustered ASM has GRD resources distributed among all ASM instances
C. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
D. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
E. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
F. Shadow GRD resources may exist in more than one database instance for a resource.
G. Only one GRD shadow resource may exist for an Enqueue Resource.
正解：B,D,F

質問 5：
Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)
A. They can be policy managed.
B. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.
C. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.
D. They can be administrator managed.
E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.
F. They are automatically configured to use Enterprise Manager Express.
正解：A,B,D

質問 6：
Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? (Choose three.)
A. out-of-place patching for patch bundles
B. in-place patching for patch bundles
C. in-place patching for patch sets
D. in-place upgrades using the Oracle Universal Installer
E. out-of-place upgrades using the Oracle Universal Installer
F. in-place patching for one-off patches
正解：A,E,F

質問 7：
Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)
A. An ADVM volume cannot be used as a boot device on a leaf node.
B. ADVM volumes can be used to store the OCR and voting les to be used by a leaf node.
C. Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported.
D. To use ADVM volumes, an ASM proxy instance is not required on a leaf node.
E. An ADVM volume cannot be used as the root file system on a leaf node.
F. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes.
正解：A,E,F

質問 8：
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
A. A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool.
B. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN.
C. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS.
D. It requires a resource manager plan to be active on databases managed by QoS.
E. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server.
正解：B,D,E

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