1Z0-068 Online Practice Questions and Answers

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 DIRETORY command even if directory USER1 doesn't exist.

Examine this command:

SQL> CREATE DISKROUP data NORMAL REDANDUNCY:

FAILGROUP fgrpl DISK

`/dev/disk1' NAME disk1,

`/dev/disk2' NAME disk2,

`/dev/disk3' NAME disk3,

FAILGROUP fgrpl2 DISK

`/dev/disk4' NAME disk4,

`/dev/disk5' NAME disk5,

`/dev/disk6' NAME disk6,

FAILGROUP fgrpl3 DISK

`/dev/disk7' NAME disk7,

`/dev/disk8' NAME disk8,

`/dev/disk9' NAME disk9,

ATTRIBUTE `au_size'='4M',

`compatible.asm' = '11.12',

`compatible.rdbms' = '11.12',

`compatible.advm' = '11.12',

`content_type' = `recovery';

Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

A. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

B. File created in this disk group always has two copies for each allocation unit: one primary and one secondary.

C. It can contain ASM Dynamic Volume Manager (ADVM) volumes.

D. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.

E. The ASM compatible attributes can be changed to 11.1 for this disk group.

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3.

Server pool prod_pool has a cardinality of three and all six hosts of the cluster app.

Examine these commands executed on HOST01:

$ srvctl add service 璬b CDB1 璸db PDB_1 service AR 璼erverpool prod_pool 璫ardinality singleton $ srvctl start service 璬b CDB1 璼ervice AR

Which two statements are true regarding the AR service?

A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.

B. AR is available on any one available CDB1 instance in prod_pool at any one time.

C. AR can fail over to any one of the available CDB1 instances.

D. AR is available only on the CDB1 instance on HOST01.

E. AR can fail over to any other available CDB1 instance in prod_pool.

Which three are benefits of using RAC One Node in Oracle 12c?

A. automatic failover for high availability

B. ability to perform rolling patches

C. online conversion from RAC One Node databases to multi-instance RAC databases

D. load-balancing of services within a single instance

E. online-conversion from non-RAC databases to RAC One Node databases

F. multiple instances of the same database on a single node to protect against instance failure

PROD1, PROD2 and PROD3 are three active instances of the PROD database.

Examine these commands executed on PROD1:

SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid='*'; SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid='PROD1';

Which statement is true?

A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.

B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.

C. The second statement returns an error because this parameter must be identical for all instances.

D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)

A. They are automatically configured to use Enterprise Manager Express.

B. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.

C. They can be policy managed.

D. They can be administrator managed.

E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource,

F. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

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 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 two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)

A. The Clusterware binaries may be installed without installing ASM binaries.

B. The Grid Infrastructure Management Repository is only required when using ASM.

C. Specifying the use of Grid Naming Service is optional.

D. Normal Redundancy ASM Disk Groups used for Clusterware flies will contain three voting files regardless of the number of failgroups.

E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

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. an operating system version

B. a version of Oracle database server used in Real Application Cluster (RAC) databases

C. software required to configure nodes at startup

D. the GPnP software

E. a file system version used for the software to be installed

F. a version of Automatic Storage Management (ASM) used for the cluster