Oracle 1Z0-068 Free Practice Questions

Q1. Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database? 

A. using DBCA to migrate the database to shared storage and then start one or more RAC databaseinstances on the cluster 

B. using DBCA to create a template from the single-instance database and then to create a RAC database onthe cluster using that template 

C. using the rconfig utility to create a template from the single-instance database and then using DBCA tocreate a RAC database on the cluster using that template 

D. using the rconfig utility to migrate the database to shared storage and then using DBCA to start one ormore RAC database instances on the cluster. 

View Answer

Q2. Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC? 

A. In a RAC One Node database, there is no LMD0 process if only one instance is running. 

B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances. 

C. In a RAC database, there is no LMD0 process if only one instance is running. 

D. Global Enqueues and Instance Locks replace latches completely in RAC database isntances. 

E. Global Enqueues may have owners and waiters in the same instance. 

F. Global Enqueues may have converters and waiters in the same isntance. 

View Answer

Q3. 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 

View Answer

Q4. Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack? 

A. asmcmd 

B. srvctl predict.... 

C. crsctl fail…. 

D. asmca 

E. acfsutil 

F. advmutil 

View Answer

Q5. 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). 

View Answer

Q6. Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware? 

A. Use the cluvfy comp command for the specific resource within a component. 

B. Use the crsctl set trace res “resource_name=debugging_level” command. 

C. Use the crsctl set log res “resource_name=debugging_leve2” command. 

D. Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requiresresource debugging data to be collected. 

View Answer

Q7. Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability? 

A. A policy-managed resource can be started manually using crsctl. 

B. A policy-managed resource can be started manually using srvctl. 

C. Resource dependencies are automatically set when using a policy-managed resource. 

D. An administrator-managed resource can be started manually using crsctl.E. An administrator-managed resource can be started manually using srvctl. 

E. The action script is automatically set when using a policy-managed resource. 

View Answer

Q8. Examine this command: 

SQl> CREATE DISKROUP RECO HIGH REDUNDANCY: 

FAILGROUP fgrpl1 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’ = ’12.1’, 

‘compatible.rdbms’ = ’12.1’, 

‘compatible.advm’ = ’12.1’, 

‘content_type’ = ‘recovery’; 

Which three statements a true about this disk group? 

A. File created in it have three copies for each allocation unit. 

B. Any database instance with the COMPATIBLE parameter 10.1 and higher can use it. 

C. The Compatible attribute values of the disk group can be changed to lower values. 

D. Files created using a template with the redundancy attributes set to MIRROR will have three-way Mirroring. 

E. The RECO diskgroup may only be used for the FRA. 

F. Files created using a template with the redundancy attribute set to HIGH will have three-way mirroring. 

View Answer

Q9. Examine this query and output: 

SQL> select order_flag, cache_size, session_flag, keep_value, 

2 from user_sequences where sequence_name = ‘SEQ1’; 

O CACHE_SIZE S K 

-- ---------------- -- -Y 10 N N 

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence. 

The SEQ1 sequence is incremented from all instances equally and is frequently used. 

Which two statements should you execute to reduce SQ enqueue contention? 

A. alter sequence seq1 cache 10000; 

B. alter sequence seq1 order; 

C. alter sequence seq1 noorder; 

D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’) 

E. alter sequence seq1 keep; 

View Answer

Q10. 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 failuregroups. 

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

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. 

View Answer

Q11. Which three statements are true about Server Categorization in Oracle 12c Clusterware? 

A. All server attributes that may be used to determine the server category are discovered automatically byOracle Clusterware. 

B. Different Hub nodes in a flex cluster may belong to separate administrator-defined categories. 

C. All hub nodes in a flex cluster belong to the same Oracle-supplied category. 

D. A server may be added to only one category using the crsctl utility. 

E. All leaf nodes in a flex cluster belong to the same Oracle-supplied category. 

F. All server attributes used for categorization are administrator modifiable. 

View Answer

Q12. 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) 

View Answer

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

A. A Server Pool 

B. an application VIP 

C. an application resource 

D. a resource dependency definition 

E. a script agent 

View Answer

Q14. After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource. 

Which command, or sequence of commands, should you use? 

A. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron 

B. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2 

C. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server016n1, 016n2 

D. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2 

View Answer

Q15. 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 –repair 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 –repair on host01. 

E. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig –repair command. 

View Answer

Q16. Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation? 

A. Some grid infrastructure patchsets may not be installed in a rolling fashion. 

B. They can be applied in-place. 

C. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of thesoftware running anywhere in the cluster 

D. When performing rolling patches, the VIPs for the node being patched are relocated to another node. 

View Answer

Q17. Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c? 

A. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in theinstallation owner’s environment. 

B. The upgrade must be done in-place. 

C. The upgrade must be done out of place. 

D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-incluster verification utility. 

E. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade. 

F. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installationowner’s environment. 

G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster. 

View Answer

Q18. Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? 

A. in-place upgrades using the Oracle Universal Installer 

B. out-of-place patching for patch bundles 

C. in-place patching for patch bundles 

D. out-of-place upgrades using the Oracle Universal Installer 

E. in-place patching for one-off patches 

F. in-place patching for patch sets 

View Answer