1Z0-068 | Precise Database 12c 1Z0-068 exam question
Q11. 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
Q12. Which three statements are true about Oracle Clusterware components, architecture, and behavior?
A. The Cluster Ready Services Daemon (CRSD) is responsible for monitoring and maintaining the availabilityof cluster resources defined in the Oracle Local Repository file (OLR).
B. All cluster nodes can write or read from the Oracle Clusterware Repository (OCR) file at the same time.
C. The Oracle High Availability Services Daemon (OHASD) is responsible for monitoring and maintaining theavailability of the Clusterware stack on a cluster node.
D. Voting disks stored in Automatic Storage Management (ASM) can be discovered or used even if the ASM instance on a cluster node is down.
E. The Cluster Synchronization Services Daemon (CSSD) must connect to the cluster by accessing theOracle Clusterware Repository (OCR) file before the Oracle High Availability Services Daemon (OHASD) is started.
F. Time synchronization in an Oracle Cluster is possible without using network Time Protocol (NTP).
Answer: A,C,E
Q13. Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?
A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic StorageManagement (ASM) installation
B. an O/S group to own the software inventory
C. an O/S user to own the Oracle Database installation
D. an O/S group called dba
E. a group to own the ASMLIB-provisioned storage
F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage
Answer: C,D
Q14. Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?
A. Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03.
B. Run the rootcrs.pl – delete –force command as root on host01, or on either host02 or host03.
C. Run the rootcrs.pl – delete –force command as root on host04.
D. Run the crsctl delete node n – host04 command as root on host04. E. Run the crsctl delete node n – host04 command as root on host04.
E. Run the crsctl delete node n – host04 command as root on host01, or on either host02 or host03.
Answer: B,C
Q15. Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?
A. creating additional redo threads
B. creating additional undo tablespaces
C. creating shared ASM disk groups
D. adding cluster resources
E. creating database services
F. adding additional initialization parameters
Answer: A,B,C,F
Q16. 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
Q17. Which three statements are true about Oracle 12 RAC Database 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 OSusers.
D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RACdatabase software.
E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RACdatabase software.
F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OSuser.
Answer: C,D,F
Q18. Which three options have a RAC-specific tuning component?
A. contention on index leaf blocks
B. sequence definitions
C. the size of the online redo log buffers
D. contention for online redo log files
E. contention for archived redo log files
F. the load on the Cluster Interconnect
Answer: A,C,F
Q19. 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
Q20. 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