Q1. Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?
A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
B. TAF-settings for the service override TAF settings in TNS entry used by the client.
C. TAF can restart a query or a transaction after failover.
D. The TAF settings for a client connections overrides any TAF settings in the service definition.
E. TAF PRECONNECT requires configuration for the service and in the client TNS entry.
Answer: B,C,E
Q2. Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?
A. Server Pools must be managed with the crsctl utility for servers hosting an application or otheradministrator-defined high-availability resource.
B. All servers in a new cluster installation belong to the generic server pool.
C. The server pool contains servers that host administrator-defined high availability resources.
D. Server pools must be managed with the srvctl utility for servers hosting a database.
E. All servers in a new cluster installation belong to the free server pool.
Answer: B,D,E
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.
Answer: B,C,D
Q4. Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster?
A. at least one for the public network
B. at least one for the storage network
C. at least one for the interconnect
D. at least two for the public network
E. at least two for the storage network
F. at least two for the interconnect
Answer: D,E
Q5. Which two statements are true about v$asm – views in clustered environment?
A. They exist both in ASM and RDBMS instances, and display the same output.
B. Their names can be seen in dict when connected to an ASM instance.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on theinstance type.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in thecluster.
Answer: B,D
Q6. Which two statements are true about Flex ASM in a Flex Cluster?
A. Oracle databases from releases older than 12c cannot use Flex ASM.
B. ASFS may only be configured on a hub node running an ASM instance.
C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster.
E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
Answer: A,E
Q7. 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: B,C,E
Q8. Your flex cluster has these attributes:
1.Hub nodes host01 and host02
2.Leaf nodes host03 and host04
3.Full Featured GNS is configured and running.
You attempt to run this command to add two more nodes to the cluster:
$ ./addnode.sh –silent “CLUSTER_NEW_NODES={host05,host06}” “CLUSTER_NEW_NODE_ROLES={hub,leaf}”
What is the result and the reason for this result?
A. It fails because no VIP was specified for the hub node host05.
B. It fails because hub and leaf nodes may not be added by the same execution of addNode.sh.
C. It fails because GNS doesn’t assign VIPs for leaf nodes and no VIP was specified in the command.
D. It succeeds because no VIP specification is required for leaf nodes and none need to be specified for hubnodes when using full featured GNS.
Answer: B
Q9. Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs?
A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP isrequired.
B. An application VIP is created on the default network by the appvipcfg utility.
C. An application VIP is created on the interconnect network by the crsctl utility.
D. An application VIP can be created with the crsctl utility.
E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.
Answer: C,E
Q10. A directory +DATA/ORCL/DATAFILE/USERS exists in ASM.
USERS is a user created directory; ORCL and DATAFILE are system generated directories. Which two statements are true about user-created directories?
A. You can create subdirectories under the USERS directory.
B. You cannot rename a user-created subdirectory.
C. You cannot drop a directory containing aliases unless you delete the aliases first.
D. You cannot create a user-defined directory at the root (+) level.
E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORYcommand even if directory USER1 doesn’t exist.
Answer: A,C