1Z0-068 Online Practice Questions and Answers

Examine this command to create a volume in the DATA disk group:

SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH

STRIPE_WIDTH 1M;

STRIPE_COLUMNS 1;

The DATA disk group has 50GB free space.

Which two are prerequisites for successful execution of this command?

A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.

B. The DATA disk group must not be created with external redundancy.

C. The DATA disk group must not contain any other volume.

D. The DATA disk group must have at least three failure groups.

E. The DATA disk group must have an AU size of 1MB.

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.

B. Taking an AWR snapshot in a RAC database captures data from the local instance only.

C. Data captured by an AWR is aggregated across all instances before being stored in the database.

D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.

E. AWR snapshots are created when control_management_pack_access is set to "none"

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)

Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

A. HANFS does not depend on NFS services provided by the underlying operating system.

B. HANFS performance depends on the characteristics of the underlying ASM disks.

C. HANFS provides high availability in case of an NFS client failure.

D. HANFS provides high availability in case of cluster node failure.

E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.

Which three statements are true about fully qualified file names in ASM? (Choose three.)

A. They are system generated at the time of ASM file creation.

B. They can be used to reference existing ASM files.

C. They can be created only if OMF is enabled.

D. They are the only valid form that can be used for single file creation of a control file.

E. An alias may be created for an existing file by referring to the fully qualified file name.

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

Examine this command and output:

You want to relocate this database online to node 016n2.

Which two statements must be true for a successful online migration? (Choose two.)

A. The database must be stored on shared storage.

B. The database must have at least two UNDO tablespaces.

C. The database must have at least two redo threads defined by the DBA.

D. Database clients must disconnect before the online relocation timeout expires.

E. Database clients must use Transaction Guard to prevent them from losing their connection.

F. The database must be open.

Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 12c Clusterware? (Choose two.)

A. A Server Pool

B. an application VIP

C. an application resource

D. a resource dependency definition

E. a script agent

Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

A. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.

B. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

C. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database Software will be installed.

D. Grid infrastructure must be installed on all cluster nodes.

E. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.

F. The Clusterware stack must be up on all cluster nodes.