Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
A. The software must be installed into a cluster file 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.
PROD1, PROD2, and PROD3 are three Instance that have the PROD database open.
The OLTP service was created using:
$ srvctl add service -db prod -service OLTP -preferred PROD1, PROD2 -available PROD3
After starting the OLTP service, you execute this command:
$ srvctl stop instance -db prod -instance " PROD1, PROD2 " -stopoption immediate -f Which statement is true about the outcome of this command?
A. It shuts down PROD1 and PROD2; OLTP will be started automatically on PROD3.
B. It shuts down PROD1 and PROD2; OLTP will not be started on PROD3.
C. PROD1and PROD2 are not shut down because OLTP must first be stopped.
D. PROD1and PROD2 are not shut down because OLTP must first be manually relocated to PROD3.
E. It shuts down either PROD1or PROD2 but not both, so that OLTP remains available on a preferred instance.
Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.)
A. gc cr block busy
B. gc current block request
C. gc current block busy
D. gc cr block request
E. gc current grant busy
F. gc cr grant busy
Which three resources are managed using global concurrency control in an Oracle 12c RAC multi- instance database? (Choose three.)
A. latches
B. enqueues
C. database block buffers
D. mutexes
E. cursors
F. redo log buffers
Which two statements are true concerning Oracle Enterprise Manager Cloud Control Cluster Database performance pages? (Choose two.)
A. The Interconnects page shows the load contributed by database instances on the public network.
B. The Interconnects page shows the load contributed by database instances on the private interconnect and the public network.
C. The Interconnects page shows throughput contributed by individual sessions on the private interconnect.
D. The Cluster Cache Coherency page shows which block classes are subject to intense global cache activity.
E. The Cluster Cache Coherency page shows which instances are responsible for intense global cache activity.
Which three are benefits of using RAC databases with multiple instances? (Choose three.)
A. surviving node failures
B. surviving storage network failures
C. surviving interconnect failures
D. automatic workload management for services on local connections
E. automatic workload management for services on Oracle Net connections
F. parallel execution across all instances supporting a balanced policy-management service
G. parallel execution across all instances supporting a singleton policy-management service
You performed these steps to disable an ADVM volume containing an ACFS file system:
1.
Dismount the file system.
2.
Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)
A. The ACFS file system will be permanently removed from the volume.
B. The ACFS mount registry with Oracle restart is automatically deleted.
C. The volume can be enabled and the file system can be mounted back again to access the existing data.
D. The ACFS file system will be permanently removed from the volume only if the file system is empty.
E. The disabling of volume does not destroy data in the file system.
Examine this command:
SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/ mytab.dbf' SIZE 100M;
Which two statements are required for this command to succeed? (Choose two.)
A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
B. newtemplate must be defined for the +DATA disk group.
C. Existing data files in TBS1 must also use the same template.
D. The +DATA disk group should not be part of Flex ASM.
E. User-defined subdirectories ORCL and USERS must already exist.
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
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.
Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software? (Choose three.)
A. Oracle Cluster Registry (OCR) files
B. Oracle database executables
C. Grid Infrastructure executables
D. Data files for tablespaces
E. Archive logs
F. Voting Disks
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-068 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.