1Z0-068 Online Practice Questions and Answers

Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

A. They are contained in a directory on the same volume as their parent file system.

B. All ACFS snapshot operations for all filesystem are serialized clusterwide.

C. You can create a snapshot from an existing snapshot.

D. They can be administered using ASMCMD.

E. They can only be accessed when the file system is mounted.

F. They are always point-in-time copies of the parent file system.

Which three statements are true about the services created when the DBCA is used to create a RAC database?

A. They can be policy managed for a multitenant database.

B. Singleton services are not permitted for multitenant databases.

C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.

D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.

E. They can be administrator managed for a multitenant database.

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?

A. An XCUR block image may exist for a specific database block in only one instance.

B. A CR image may get served from one instance to another to satisfy a read request.

C. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

D. A PI block image may exist for a specific database block in only one instance.

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 any server in the 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.

Which three statements are true about Global Resource Management in an Oracle 12c RAC database?

A. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.

B. Object remastering causes all blocks in any instances' buffer cache from the same object to be mastered in the Global Resource Directory (GRD).

C. When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances.

D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.

E. Global Enqueue resources are recovered after Global Cache Resources after an instance failure.

When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04?

A. Run ocr.config 璻epair on another node in the cluster to repair the ocr.loc file on host01

B. Stop the clusterware stack on host01 only.

C. Stop the clusterware stack on all cluster nodes.

D. Run ocrconfig 璻epair on host01.

E. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig 璻epair command.

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.

You administer a RAC database that currently runs on a four-node cluster but which has three instances. Which two statements are always true about redo logs for this RAC database? (Choose two.)

A. A thread of redo must be created before starting a fourth instance if a thread is not already available.

B. A thread of redo must contain at least two log groups before it can be enabled.

C. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.

D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

E. A thread of redo is automatically dropped when as instance is removed from a RAC database by using . SRVCTL

Which two actions can restrict the number of instances used for parallel execution of a SQL statement? (Choose two.)

A. setting the PARALLEL_DEGREE_POLICY to LIMITED

B. setting the PARALLEL_FORGE_LOCAL to TRUE

C. setting the PARALLEL_SERVERS_TARGET value equal to that of PARALLEL_MAX_SERVERS

D. using a database service to limit the number of instances that participate in parallel execution

E. creating a UNIFORM service for a policy-managed RAC database

You plan to use DBCA to convert a single-instance Oracle 12c database on a local filesystem on a stand- alone server to RAC by using ASM.

You installed Grid Infrastructure 12c on a four-node cluster.

Examine this list of possible conversion steps:

1.

Create a template and image files from the single-instance database by using DBCA.

2.

Perform an RMAN backup of the single-instance database.

3.

Validate the cluster using CLUVFY.

4.

Copy the template and image files to a cluster node.

5.

Restore the RMAN backup to the recovery area disk group on the cluster.

6.

Perform an Oracle Database 12c RAC installation.

7.

Create a RAC database with DBCA using the RMAN backup.

8.

Create a RAC database with DBCA using the template.

Which statement correctly lists the minimum steps required to perform the conversion?

A. 1, 3, 4, 6, 8

B. 2, 3, 5, 7

C. 2, 5, 6, 7

D. 1, 4, 6, 8

E. 1, 4, 8

F. 2, 5, 7

Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 12c?

A. Update the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.

B. Stage the patch on the cluster node where the OPatch utility will be executed.

C. Update the PATH environment variable on the node where will run the OPatch utility to point to the directory. $ORACLE_HOME/OPatch

D. Stage the patch on the cluster nodes.

Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1.

All databases have one or more services defined.

The Oracle 10g Release 2 database clients connect to the database instances using the public VIP. The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN).

You must change the public VIPS.

Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)

A. Use srvctl stop vip to stop the VIP on host01.

B. Use oifcfg setif to stop the VIP on host01.

C. Use srvctl start vip to start the VIP on host01.

D. Use srvctl modify nodeapps to change the VIP on host01.

E. Use oifcfg setif to start the VIP on host01.

Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)

A. ocrcheck

B. ocrcheck -config -local

C. ocrcheck -local

D. ocrcheck -config

E. cluvfy comp ocr -n all -verbose

Examine this tnsnames entry from a RAC configuration using a SCAN listener:

HR=(DESCRIPTION=

(LOAD_BALANCE =on)

(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=1521)) (CONNECT_DATA=(SERVICE_NAME=HRSRV)))

Which two statements are true about clients using this entry to connect? (Choose two.)

A. The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.

B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.

C. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.

D. A client connection request is received by a SCAN listener that creates the connection to the least- loaded database instance.

E. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

Identify two reasons for the gc current block busy wait event. (Choose two.)

A. A block is busy in the local cache.

B. A block is busy in the remote cache.

C. The Cluster Interconnect is congested.

D. Either the local or remote CPUs have too large a run queue.