Q1. Examine the output of the asmcmd and srvctl commands:
$ asmcmd showclustermode
ASM cluster : Flex mode enabled $ srvctl status asm –detail ASM is running on host01,
host03 ASM is enabled.
$ srvctl config asm
ASM home: /u01/app/12.1.0/grid
Password file: +DATA/orapwASM
ASM listener: LISTENER
ASM instance count: 2
Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command:
$ srvctl relocate asm – currentnode host03 –targetnode host02
Which three statements are true regarding the execution of this command based on the
output shown?
A. It fails because an ASM instance is not configured to run on HOST02.
B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST02.
D. It fails because the ASM instance has not been shut down first on HOST03.
E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut downuntil all connected clients disconnected.
F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST01.
Answer: C,E,F
Q2. Which three statements are true about Oracle Enterprise Manager Topology Viewer?
A. It displays which listeners listen on behalf of which instances.
B. It displays the relationship between targets of different target types in a cluster.
C. It displays the status of all cluster components.
D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
E. It displays the relationship between clustered ASM and cluster databases if the database is stored in ASM.
F. It displays the type of network used by RAC database instance.
Answer: A,C,D
Q3. Examine these commands: $ srvctl add service –db racdb –service erp –serverpool srvpooll -failovertype TRANSACTION –commit_outcome TRUE – replay_init_time 1800 -retention 86400 –notification TRUE –rlbgoal SERVICE_TIME –clbgoal SHORT -failoverretry 30 – failoverdelay 10 $ srvctl start service – db racdb – service erp Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively. Which three statements are true regarding the service erp?
A. Connections to the database using erp benefit from Application Continuity.
B. erp is configured for an administrator-managed RAC database.
C. Load Balancing Advisory (LBA) will be disabled for this service.
D. Connections to the database using erp benefit from Load Balancing.
E. Connections to the database using erp benefit from Transaction Guard.
Answer: C,D,E
Q4. 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 nothing file system accessed directly by the database instances
B. a cluster file system
C. a shared NFS file system
D. the DATA disk group
E. a local file system with the same path name on each cluster node
Answer: B,D,E
Q5. Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?
A. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
B. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
C. Performance of ACFS is improved by using these diskgroups.
D. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
E. Their sector size attributes can be changed using the ALTER DISKGROUP command.
Answer: B,D
Q6. You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service –db CDB1 –pdb PDB_1 –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service CRM $ srvctl stop service –db CDB1 –service CRM
Which three statements are true?
A. CRM is only available for new logins on the CDB1 instance on host01.
B. CRM is available for new logins on one CDB1 isntance.
C. The srvctl start service command automatically opens PDB_1 if not already opened.
D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
E. The CRM service is not available for new logins on any instance of CDB1.
Answer: B,D,E
Q7. Which three statements are true about Quality of Service Management (QoS)?
A. A server-pool can be managed by QoS even if it does have database instances running on nay server inthe pool.
B. It can manage database services only if they are defined as UNIFORM services.
C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
D. It supports multiple databases assigned to the same server pool.
E. Databases managed by QoS can be administrator managed or policy managed.
Answer: C,D,E
Q8. 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 the Grid Infrastructure only on the first cluster mode.
B. It applies a patch to the Grid Infrastructure on all cluster nodes.
C. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, onlyon the first cluster node.
D. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on allcluster nodes.
E. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node.
F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes.
Answer: D,F
Q9. You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.
Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 service AR –serverpool prod_pool –cardinality singleton $ srvctl start service –db CDB1 –service AR
Which two statements are true regarding the AR service?
A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of theCDB1 instances.
B. AR is available on any one available CDB1 instance in prod_pool at any one time.
C. AR can fail over to any one of the available CDB1 instances.
D. AR is available only on the CDB1 instance on HOST01.
E. AR can fail over to any other available CDB1 instance in prod_pool.
Answer: C,D
Q10. Which two utilities support the “what-if” command evaluation?
A. asmcmd
B. ocrconfig
C. oifcfg
D. crsctl
E. srvctl
Answer: D,E