1z1-068 Exam Training Practice Tests (Oracle Database 12c: RAC and Grid Infrastructure Administrator)]

Question 1

Which three components are integral parts of High Availability NFS (HANFS)?

A. NFS B. HAIP C. HAVIP D. DHCP E. Application VIP F. ExportFS

Correct Answer: A,C,F

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

Question 2

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. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set. B. All running CDB instances must be open in restricted mode. C. The source PDB must be in READ ONLY mode on all CDB instances. D. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container. E. The source PDB must be closed on the CDB instance from where the command is executed. F. The source PDB must use a global temporary tablespace.

Correct Answer: A,C,D

Question 3

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

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

Correct Answer: A,C,D

Question 4

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

A. RAC installations require Oracle Enterprise Edition. B. The software must be installed into a cluster le system. C. The software can be installed into an ACFS file system. D. The software must be installed into a local file system on each node. E. The software must be installed on all nodes in the cluster. F. SSH user equivalence for the Oracle user can be set up before the software installation. G. Fix-up scripts generated during the installation must be run as root on UNIX platforms.

Correct Answer: C,F,G

Question 5

Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware?

A. When a policy is activated, nodes may be reassigned to server pools based on the policy definition. B. An administrator-defined policy may be activated using the srvctl utility. C. When a policy is activated, resources can be automatically stopped to comply with the policy definition. D. When a policy is activated, resources cannot be automatically started to comply with the policy definition. E. When a policy is first created, it is initially inactive. F. When a policy is first created, it is initially active.

Correct Answer: A,B,E

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

Question 6

Which two statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM?

A. They listen only for database instances on the same node. B. They run from the Grid Infrastructure home by default. C. They listen only for the ASM instance on the same node. D. They listen on behalf on any ASM instance and all database instances on the same node. E. There only can be one node listener per node.

Correct Answer: B,D

Question 7

Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

A. The service's connection load balancing goal must be manually configured to enable server-side connect-time load balancing. B. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN. C. It's enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client. D. It is based on performance metrics provided by the database instances LREG processes. E. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.

Correct Answer: A,B

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

Question 8

Examine this command:
SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/mytab.dbf' SIZE 100M; Which two statements are required for this command to succeed? (Choose two.)

A. The +DATA disk group should not be part of Flex ASM. B. newtemplate must be defined for the +DATA disk group. C. Existing data les in TBS1 must also use the same template. D. User-defined subdirectories ORCL and USERS must already exist. E. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

Correct Answer: A,C

Question 9

Examine this output:

The ACFS disk group has 10 GB free space and the file system is currently mounted.
You execute this command to increase the volume size:
ASMCMD >volresize -G ACFS -s 3G VOL1
Which statement is true regarding the outcome?

A. It succeeds. B. It succeeds but the file system is automatically unmounted. C. It fails because the -f option is not specified. D. It fails because the file system must be unmounted before resizing. E. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.

Correct Answer: E

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

Question 10

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. exec sys.dbms_shared_pool.keep ('SEQ1', 'Q') B. alter sequence seq1 order; C. alter sequence seq1 cache 10000; D. alter sequence seq1 noorder; E. alter sequence seq1 keep;

Correct Answer: C,D

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

Question 11

Which three statements are true about the cluster file system archiving scheme?

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

Correct Answer: A,D,F

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

Oracle Database 12c: RAC and Grid Infrastructure Administrator - 1z1-068 Exam Practice Test