Q1. Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?
A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
B. The DATA disk group must not be created with external redundancy.
C. The DATA disk group must not contain any other volume.
D. The DATA disk group must have at least three failure groups.
E. The DATA disk group must have an AU size of 1MB.
Answer: A,D
Explanation:
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to
11.2 or higher for the disk group.
A high redundancy disk group must contain at least three failure groups.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG1007
2 https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm
Q2. Which three statements are true about ASM Cloud File System (ACFS) replication?
A. ACFS auditing information is replicated from the primary file system to the standby file system.
B. One site of an ACFS replication configuration can be host both primary and standby file systems.
C. Replication is automatically terminated if the primaries file system has less than 2GB free space.
D. Standby redo log files are required on the standby site for synchronous redo transport.
E. The privilege SYSREPL has been introduced for ACFS replication.
Answer: B,C,D
Explanation:
A site can host both primary and standby file systems.
If the primary file system has less than 2 GB available free disk space, Oracle ACFS attempts to automatically terminate replication on the primary file system. Reference: https://docs.oracle.com/database/121/OSTMG/GUID-8522E0B6-BE6E-4BE3-B7C7-
5EA2ED4A602C.htm#OSTMG34600
https://docs.oracle.com/cd/B19306_01/server.102/b14239/log_transport.htm#i1280979
Q3. Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability?
A. A policy-managed resource can be started manually using crsctl.
B. A policy-managed resource can be started manually using srvctl.
C. Resource dependencies are automatically set when using a policy-managed resource.
D. An administrator-managed resource can be started manually using crsctl.E. An administrator-managed resource can be started manually using srvctl.
E. The action script is automatically set when using a policy-managed resource.
Answer: A,E
Q4. Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?
A. asmcmd
B. srvctl predict....
C. crsctl fail….
D. asmca
E. acfsutil
F. advmutil
Answer: C,E
Q5. 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. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
C. An administrator-defined policy may be activated using the srvctl utility.
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 activated, resources can be automatically stopped to comply with the policy definition.
Answer: A,C,E
Q6. Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?
A. In a RAC One Node database, there is no LMD0 process if only one instance is running.
B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
C. In a RAC database, there is no LMD0 process if only one instance is running.
D. Global Enqueues and Instance Locks replace latches completely in RAC database isntances.
E. Global Enqueues may have owners and waiters in the same instance.
F. Global Enqueues may have converters and waiters in the same isntance.
Answer: E,F
Q7. Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?
A. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes.
B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where theDatabase Software will be installed.
D. Grid infrastructure must be installed on all cluster nodes.
E. The Clusterware stack must be up on all cluster nodes.
Answer: A,D
Q8. 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 theinstallation owner’s environment.
B. The upgrade must be done in-place.
C. The upgrade must be done out of place.
D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-incluster verification utility.
E. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
F. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installationowner’s environment.
G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
Answer: A,B,F,G
Q9. Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 12c Clusterware?
A. A Server Pool
B. an application VIP
C. an application resource
D. a resource dependency definition
E. a script agent
Answer: B,C
Q10. Examine this output: 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 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 fails because the file system must be unmounted before resizing.
C. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.
D. It succeeds but the file system is automatically unmounted.
E. It fails because the –f option is not specified.
Answer: C