Online Access Free 1z1-068 Exam Questions

Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware?
(Choose three.)

• A.Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
• B.A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
• C.A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
• D.Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
• E.All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

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 listener cross-registration.
• B.Client connection requests are automatically load balanced across the IP addresses defined for the SCAN listeners.
• C.SCAN listeners redirect connection requests to a node listener for the appropriate instance.
• D.The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node.
• E.You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used.

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.The source PDB must be closed on the CDB instance from where the command is executed.
• B.The source PDB must be in READ ONLY mode on all CDB instances.
• C.Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
• D.The source PDB must use a global temporary tablespace.
• E.All running CDB instances must be open in restricted mode.
• F.It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.

A Java application will be deployed, and you must configure a RAC database to support highly available connections.
The application will use the Universal Connection Pool (UCP), and Fast Connection Failover (FCF) must be enabled.
Which two statements are true? (Choose two.)

• A.The application may use the JDBC thin driver.
• B.The ONS daemon must be started on the middle tier and client machines to enable FCF.
• C.You must configure TAF, either on the client or for the service.
• D.The ONS daemon must be started on the middle tier running the Java application.
• E.The ons.jar file must be present in the CLASSPATH.

Which three are among the minimum components in a software image that is part of a Grid Plug and Play (GPnP) profile in Oracle Clusterware? (Choose three.)

• A.the GPnP software
• B.a file system version used for the software to be installed
• C.a version of Oracle database server used in Real Application Cluster (RAC) databases
• D.a version of Automatic Storage Management (ASM) used for the cluster
• E.software required to configure nodes at startup
• F.an operating system version