Oracle Database 12c: RAC and Grid Infrastructure Administrator

QUESTION NO: 1
You plan to create a three-instance RAC database stored in ASM, with its data files in the DATA disk group.
Identify three supported storage solutions for the Fast Recovery Area (FRA).

A. a shared NFS file system B. the DATA disk group C. a local file system with the same path name on each cluster node D. a shared nothing file system accessed directly by the database instances E. a cluster file system

Correct Answer: A,B,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)

A. The command-line utility qosct1 can be used to change the password of the internal user QOSADMIN. B. It supports RAC One Node databases if they are assigned to server pools with a maximum size of one server. C. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS. D. A server pool directive override can be used to modify the database parameter CPU_COUNT for all databases within one server pool. E. It requires a resource manager plan to be active on databases managed by QoS.

Correct Answer: A,B,E

QUESTION NO: 3
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 fails to resize the filesystem because it must be unmounted before resizing. B. It resizes VOL1. C. It succeeds but leaves the filesystem unmounted. D. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group. E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.

Correct Answer: B,C

QUESTION NO: 4
Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c?
(Choose two.)

A. Single Client Access Name (SCAN) VIPs B. High Available VIP (HAIP) addresses C. the Grid Naming Service (GNS) VIP D. Storage Network IP addresses E. public IP addresses

Correct Answer: A,C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = 'SEQ1';
O CACHE_SIZE S K
-- ------------------- -- --
Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention?

A. alter sequence seq1 noorder; B. alter sequence seq1 cache 10000; C. exec sys.dbms_shared_pool.keep ('SEQ1', 'Q') D. alter sequence seq1 order; E. alter sequence seq1 keep;

Correct Answer: A,B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?

A. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes. B. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes. C. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes. D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes. E. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption. F. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both. G. The hub node is evicted from the cluster

Correct Answer: C,E,G

QUESTION NO: 7
Which three statements are true about the cluster file system archiving scheme?

A. Each node can read the archive redo log files of the other nodes. B. Each node archives to a uniquely named local directory. C. Each node can read only the archived logs written by itself. D. Nodes don't use network to archive files. E. Each node writes to a single location on the cluster file system while archiving the redo log files. F. Each node archives to a local directory with the same path on each cluster node.

Correct Answer: B,C,D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)

A. To use ADVM volumes, an ASM proxy instance is not required on a leaf node. B. An ADVM volume cannot be used as the root file system on a leaf node. C. ADVM volumes can be used to store the OCR and voting les to be used by a leaf node. D. Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported. E. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes. F. An ADVM volume cannot be used as a boot device on a leaf node.

Correct Answer: B,E,F

QUESTION NO: 9
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 can open the PRDPDB1 PDB only if it is manually managed. B. It cannot open the PRDPDB1 PDB automatically. C. It opens the PRDPDB1 PDB if not already opened. D. It can open the PRDPDB1 PDB only if it is policy managed.

Correct Answer: D

QUESTION NO: 10
Which three statements are true about the services created when the DBCA is used to create a RAC database?

A. Policy-managed services specified for a database allow the creation of a new server pool using DBCA. B. Singleton services are not permitted for multitenant databases. C. They can be administrator managed for a multitenant database. D. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service. E. They can be policy managed for a multitenant database.

Correct Answer: A,C,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z0-068 Exam Questions