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

A. They run from the Grid Infrastructure home by default. 

B. They listen only for database instances on the same node. 

C. They listen only for the ASM instance on the same node. 

D. There only can be one node listener per node. 

E. They listen on behalf on any ASM instance and all database instances on the same node. 

View Answer

Q2. Which three statements are true about ASM Cloud File System (ACFS) encryption? 

A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory. 

B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors. 

C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges. 

D. acfsutil encr on can be used to specify the encryption key length for a directory or file. 

E. An ACFS snapshot can be ACFS encrypted. 

View Answer

Q3. Which three statements are true regarding multitenant architecture for RAC databases? 

A. One UNDO tablespace for each PDB is required. 

B. One UNDO tablespace for each instance is required. 

C. PDBs can have local temporary tablespaces. 

D. All the containers share the same SYSTEM and SYSAUX tablespaces. 

E. You can open one, several, or all PDBs on one, several, or all CDB instances. 

View Answer

Q4. 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. 

View Answer

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. 

View Answer

Q6. Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c? 

A. the Grid Naming Service (GNS) VIP 

B. public IP addresses 

C. High Available VIP (HAIP) addresses 

D. Single Client Access Name (SCAN) VIPs 

E. Storage Network IP addresses 

View Answer

Q7. Which three are benefits of using RAC One Node in Oracle 12c? 

A. automatic failover for high availability 

B. ability to perform rolling patches 

C. online conversion from RAC One Node databases to multi-instance RAC databases 

D. load-balancing of services within a single instance 

E. online-conversion from non-RAC databases to RAC One Node databases 

F. multiple instances of the same database on a single node to protect against instance failure 

View Answer

Q8. Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation? 

A. Some grid infrastructure patchsets may not be installed in a rolling fashion. 

B. They can be applied in-place. 

C. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of thesoftware running anywhere in the cluster 

D. When performing rolling patches, the VIPs for the node being patched are relocated to another node. 

View Answer

Q9. Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture? 

A. Each leaf node must be connected to storage shared across all cluster nodes. 

B. Hub nodes require direct access to the voting disks. 

C. Each leaf node must be connected to storage shared across all leaf nodes. 

D. Each hub node must be connected to storage shared across all hub nodes. 

E. Hub nodes require direct access to the OCR file. 

F. Leaf nodes require direct access to the voting disks. 

View Answer

Q10. 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. 

View Answer