Oracle Database 12c: RAC and Grid Infrastructure Administrator (1z0-068) Free Practice Test

Question 1

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c?

A. The upgrade must be done in-place.

B. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.

C. The upgrade must be done out of place.

D. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

E. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.

F. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

Correct Answer: B,C,D,G

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

Question 2

A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?

A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

B. Transparent Application Failover (TAF)

C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)

D. Fast Connection Failover (FCF)

Correct Answer: C

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

Question 3

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. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.

B. All running CDB instances must be open in restricted mode.

C. The source PDB must use a global temporary tablespace.

D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.

E. The source PDB must be in READ ONLY mode on all CDB instances.

F. The source PDB must be closed on the CDB instance from where the command is executed.

Correct Answer: A,D,E

Question 4

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 cannot open the PRDPDB1 PDB automatically.

B. It can open the PRDPDB1 PDB only if it is policy managed.

C. It opens the PRDPDB1 PDB if not already opened.

D. It can open the PRDPDB1 PDB only if it is manually managed.

Correct Answer: B

Question 5

Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

A. You can create a snapshot from an existing snapshot.

B. They can only be accessed when the file system is mounted.

C. They are contained in a directory on the same volume as their parent file system.

D. They can be administered using ASMCMD.

E. They are always point-in-time copies of the parent file system.

F. All ACFS snapshot operations for all filesystem are serialized clusterwide.

Correct Answer: A,B,F

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

Question 6

You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

A. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

B. A thread of redo must be created before starting a fourth instance if a thread is not already available.

C. A thread of redo must contain at least two log groups before it can be enabled.

D. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.

E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

Correct Answer: B,C

Question 7

Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 12.1
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

A. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.

B. New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

C. New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.

D. Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.

Correct Answer: C,D

Question 8

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 resizes the filesystem mounted on /u01/app/grid/acfsmount.

B. It succeeds but leaves the filesystem unmounted.

C. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.

D. It resizes VOL1.

E. It fails to resize the filesystem because it must be unmounted before resizing.

Correct Answer: B,D

Question 9

Examine this command and output:
[root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete.
Examine this command:
[root@host01 ~]# / sbin/acfsutil snap create -p snap001
Snap002 /u01/app/grid/ acfsmount/
Which statement must be true for the successful execution of the second command?

A. The parent snapshot must be read/write.

B. The parent snapshot must be read-only.

C. The disk group compatibility attribute for ADVM must be set to 12.1 or higher.

D. The underlying ADVM volume must be configured with high redundancy.

Correct Answer: D

Question 10

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 a patchset to a database ORACLE_HOME.

D. It can apply some patches without shutting down database instances.

E. It cannot run with root privileges on a Unix-like system.

F. It can apply patches to a database ORACLE_HOME.

Correct Answer: C,D,F

Question 11

Examine this command executed on the first node of a three-node cluster:
# <GRID_INFRASTRUCTURE_ORACLE_HOME>/OPatch/opatchauto apply 18139660
Which two tasks does this command perform?

A. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node.

B. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, only on the first cluster node.

C. It applies a patch to the Grid Infrastructure only on the first cluster node.

D. It applies a patch to the Grid Infrastructure on all cluster nodes.

E. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on all cluster nodes.

F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes.

Correct Answer: D,E

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

Question 12

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

A. When a policy is first created, it is initially active.

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, nodes may be reassigned to server pools based on the policy definition.

E. When a policy is first created, it is initially inactive.

F. When a policy is activated, resources cannot be automatically started to comply with the policy definition.

Correct Answer: B,D,E

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

Welcome to TestSimulate

Oracle Database 12c: RAC and Grid Infrastructure Administrator (1z0-068) Free Practice Test