NEW QUESTION 1
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.

Answer: BCE

Explanation: B: For an Oracle RAC CDB, one active undo tablespace exists for each instance.
C: From a physical perspective, a CDB has basically the same structure as a non-CDB, except that each PDB has its own set of tablespaces (including its own SYSTEM and SYSAUX tablespaces) and data files.
References: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268

NEW QUESTION 2
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

• A. crsctl stop crs
• B. crsctl stop cluster
• C. crsctl disable crs
• D. crsctl config crs

Answer: AC

NEW QUESTION 3
Which three statements are true about Server Categorization in Oracle 12c Clusterware?

• A. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
• B. Different Hub nodes in a flex cluster may belong to separate administrator-defined categories.
• C. All hub nodes in a flex cluster belong to the same Oracle-supplied category.
• D. A server may be added to only one category using the crsctl utility.
• E. All leaf nodes in a flex cluster belong to the same Oracle-supplied category.
• F. All server attributes used for categorization are administrator modifiable.

Answer: CEF

Explanation: CE: The SERVER_CATEGORY is the name of a registered server category, used as part of server categorization. Oracle Clusterware standard Clusters and Oracle Flex Clusters have default categories of hub and leaf.
F: Server Category Attributes
You define servers into named categories, and assign attributes that define servers as members of that category. Some attributes that you can use to define members of a category describe the state conditions for the server, and others describe the physical characteristics of the server. You can also create your own characteristics to define servers as members of a particular category.
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92638

NEW QUESTION 4
Which two statements are true about Quality of Service Management?

• A. It can enable a more efficient sharing of hardware resources.
• B. It can improve the performance of SQL statements.
• C. It can improve system stability as the workload changes.
• D. It can improve the performance of PL/SQL.
• E. It can reduce the load on the system caused by Oracle background processes.

Answer: AC

Explanation: Oracle Database QoS Management provides the following benefits: Note: More benefits are:

NEW QUESTION 5
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 instance.
• 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: CDE

NEW QUESTION 6
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)

• A. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
• B. Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
• C. Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
• D. If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterwareis started.
• E. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

Answer: AE

NEW QUESTION 7
Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 12c for a standard cluster when using Full Featured Grid Naming Service (GNS).

• A. You must create a Grid Management Repository database.
• B. You must enable the Name Server Cache Daemon (NSCD).
• C. ADHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP.
• D. Each cluster node must have at least two network interface cards,
• E. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster.
• F. ADHCP service on the public network for the cluster is required to allocate virtual IP addresses as required by the cluster.

Answer: CEF

NEW QUESTION 8
Which three statements are true regarding Flex ASM on a four-node cluster consisting of three-hub nodes and a leaf node?

• A. An ASM instance and database instances can coexist on the same hub node.
• B. A database instance on a hub node can be a client of an ASM instance running on any leaf node.
• C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
• D. A database instance on a leaf node can be a client of an ASM instance running on any hub node.
• E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
• F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.

Answer: ACF

NEW QUESTION 9
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)

Answer: C

Explanation: The Fast Connection Failover (FCF) feature is an Oracle RAC/Fast Application Notification (FAN) client implemented through the connection pool. The feature requires the use of an Oracle JDBC driver and an Oracle RAC database.
References: https://docs.oracle.com/cd/B28359_01/java.111/e10788/rac.htm

NEW QUESTION 10
Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?

• A. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.
• B. Use ocrcheck command to view the location of the OCR only if stored in a file system.
• C. Use crsctl querry votedisk to view the location of voting files if stored in ASM.
• D. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.
• E. Use crsctl query votedisk to view the location of voting files if stored in a file system.
• F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.

Answer: ACE

NEW QUESTION 11
Which two types of IP addresses does Oracle Clusterware 12c acquire from DHCP when it started up on a cluster node using Grid Naming Service (GNS)? (Choose two.)

• A. Single Client Access Name (SCAN) virtual IP addresses (VIPs)
• B. Grid Naming Service (GNS) VIPs
• C. ASM Listener VIPs
• D. High Available IP (HAIP) addresses uses for the cluster interconnect
• E. Intelligent Platform Management Interface (IPMI) IP addresses

Answer: DE

NEW QUESTION 12
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.

Answer: ADE

NEW QUESTION 13
You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners.
Which two statements are true regarding client-side connect-time load balancing? (Choose two.)

• A. You must add SCAN VIPs to the REMOTE_LISTENER parameter to enable correct listenercross-registration.
• B. Client connection requests are automatically load balanced across the IP addresses defined for the SCAN listeners.
• C. You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used.
• D. The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node.
• E. SCAN listeners redirect connection requests to a node listener for the appropriate instance.

Answer: BE

NEW QUESTION 14
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.
• F. The action script is automatically set when using a policy-managed resource.

Answer: AE

Explanation: A: With policy-based management, administrators specify the server pool (excluding the Generic and Free pools) in which the servers run. For example, a database administrator uses SRVCTL to create a server pool for servers hosting a database or database service. A clusterware administrator uses CRSCTL to create server pools for non-database use, such as creating a server pool for servers hosting an application.
E: Administrator-managed resources refer to databases. You must use SRVCTL to create server pools that host Oracle databases. You must use CRSCTL to create server pools that host non-database resources such as middle tiers and applications.
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92894

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

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

Answer: DEG

NEW QUESTION 16
Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c?

• A. The installer permits the creation of a disk group for use by the voting disks and OCR file.
• B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
• C. The installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
• D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
• E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

Answer: AB

Explanation: You can store Oracle Cluster Registry (OCR) and voting files in Oracle ASM disk groups. d

NEW QUESTION 17
Which three statements are true about Oracle 12 RACDatabase software installations?

• A. It is possible to install RAC database software on a one node cluster.
• B. It is possible to install multiple RAC database 12c software homes on the same cluster.
• C. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OS users.
• D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software.
• E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RAC database software.
• F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OS user.

Answer: ABD