Oracle 1Z0-068 Free Practice Questions

Q1. Which two statements are true about database service administration in a RAC environment? 

A. When services are created with srvctl, tnsnames.ora is automatically updated. 

B. When services are created with srvctl, the service is not started automatically. 

C. Service attributes can be modified, unless an instance hosting the service is in restricted mode. 

D. When the DBMS_SERVICE package is used to modify a service, the CRS resource is automaticallysynchronized with the changes. 

E. When the DBMS_SERVICE package is used to delete a service, it is automatically removed from the OCR. 

F. When services are started with srvctl, they are automatically added to the data dictionary of the hostingdatabase if not already defined. 

View Answer

Q2. Which two statements are true about v$asm – views in clustered environment? 

A. They exist both in ASM and RDBMS instances, and display the same output. 

B. Their names can be seen in dict when connected to an ASM instance. 

C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started. 

D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on theinstance type. 

E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in thecluster. 

View Answer

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

Q4. Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c? 

A. the Grid Naming Service (GNS) VIP 

B. public IP addresses 

C. High Available VIP (HAIP) addresses 

D. Single Client Access Name (SCAN) VIPs 

E. Storage Network IP addresses 

View Answer

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

View Answer

Q6. Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)? 

A. Run the crsctl unpin css – host04 command as root on host01, or on either host02 or host03. 

B. Run the rootcrs.pl – delete –force command as root on host01, or on either host02 or host03. 

C. Run the rootcrs.pl – delete –force command as root on host04. 

D. Run the crsctl delete node n – host04 command as root on host04. E. Run the crsctl delete node n – host04 command as root on host04. 

E. Run the crsctl delete node n – host04 command as root on host01, or on either host02 or host03. 

View Answer

Q7. Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC? 

A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue inexclusive mode. 

B. The LMD0 runs only on the instance that masters all GES resources. 

C. When a GES resource is dequeued, converters if any exist for that resource, are processed before anywaiter for that resource. 

D. The LMD0 process on the requesting instance communicates with the LMD0 process on the masteringinstance if they are not the same instance. 

E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue inshared mode. 

F. An LMD0 process runs on all instances. 

G. The foreground process on the requesting instance communicates with the LMD0 process on themastering instance if they are not the same instance. 

View Answer

Q8. 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 inthe Global Resource Directory (GRD). 

C. When a database instance fails, then some global resource masters lost from the failing instance areremastered 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. 

View Answer

Q9. Which three options have a RAC-specific tuning component? 

A. contention on index leaf blocks 

B. sequence definitions 

C. the size of the online redo log buffers 

D. contention for online redo log files 

E. contention for archived redo log files 

F. the load on the Cluster Interconnect 

View Answer

Q10. Which three statements are true about ASM Cloud File System (ACFS) replication? 

A. ACFS auditing information is replicated from the primary file system to the standby file system. 

B. One site of an ACFS replication configuration can be host both primary and standby file systems. 

C. Replication is automatically terminated if the primaries file system has less than 2GB free space. 

D. Standby redo log files are required on the standby site for synchronous redo transport. 

E. The privilege SYSREPL has been introduced for ACFS replication. 

View Answer

Q11. When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)? 

A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster 

B. using Shared GNS running on another cluster 

C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster 

D. creation of a new GNS for this cluster 

E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster 

View Answer

Q12. Which two statements are true about initialization parameters for Clustered ASM instances? 

A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect. 

B. ASM_POWER_LIMIT controls he number of RDBMS instances that can access a disk group while it isbeing rebalanced. 

C. The ASM_DISKGROUP parameter is optional. 

D. The default value of INSTANT_TYPE is ASM. 

E. The maximum value of ASM_POWER_LIMIT is 1024. 

View Answer

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

Q14. 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 nay server inthe 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. 

View Answer

Q15. Examine this command executed on the first node of a three-node cluster: 

# <GRID_INFRASTRUCTURE_ORACLE_HOME>/OPatch/opatchauto apply 18139660 

Which two tasks does this command perform? 

A. It applies a patch to the Grid Infrastructure only on the first cluster mode. 

B. It applies a patch to the Grid Infrastructure on all cluster nodes. 

C. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, onlyon the first cluster node. 

D. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on allcluster nodes. 

E. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node. 

F. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes. 

View Answer

Q16. Examine these commands: $ srvctl add service –db racdb –service erp –serverpool srvpooll -failovertype TRANSACTION –commit_outcome TRUE – replay_init_time 1800 -retention 86400 –notification TRUE –rlbgoal SERVICE_TIME –clbgoal SHORT -failoverretry 30 – failoverdelay 10 $ srvctl start service – db racdb – service erp Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively. Which three statements are true regarding the service erp? 

A. Connections to the database using erp benefit from Application Continuity. 

B. erp is configured for an administrator-managed RAC database. 

C. Load Balancing Advisory (LBA) will be disabled for this service. 

D. Connections to the database using erp benefit from Load Balancing. 

E. Connections to the database using erp benefit from Transaction Guard. 

View Answer

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

Q18. Which three statements are true about the cluster file system archiving scheme? 

A. Each node can read only the archived logs written by itself. 

B. Nodes don’t use network to archive files. 

C. Each node can read the archive redo log files of the other nodes. 

D. Each node archives to a uniquely named local directory. 

E. Each node archives to a local directory with the same path on each cluster node. 

F. Each node writes to a single location on the cluster file system while archiving the redo log files. 

View Answer