Oracle 1Z0-068 Free Practice Questions

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

Q2. Which three statements are true about ASM Cloud File System (ACFS) encryption? 

A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory. 

B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors. 

C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges. 

D. acfsutil encr on can be used to specify the encryption key length for a directory or file. 

E. An ACFS snapshot can be ACFS encrypted. 

View Answer

Q3. 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 occurfor updated rows on the block. 

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

View Answer

Q4. Which two statements are true concerning ASM diskgroups using disks with a 4k sector size? 

A. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher. 

B. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher. 

C. Performance of ACFS is improved by using these diskgroups. 

D. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher. 

E. Their sector size attributes can be changed using the ALTER DISKGROUP command. 

View Answer

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

View Answer

Q6. Which three statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM? 

A. They run from the Grid Infrastructure home by default. 

B. They listen only for database instances on the same node. 

C. They listen only for the ASM instance on the same node. 

D. There only can be one node listener per node. 

E. They listen on behalf on any ASM instance and all database instances on the same node. 

View Answer

Q7. 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 –db CDB1 –pdb PDB_1 service AR –serverpool prod_pool –cardinality singleton $ srvctl start service –db CDB1 –service 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 theCDB1 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. 

View Answer

Q8. Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c? 

A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic StorageManagement (ASM) installation 

B. an O/S group to own the software inventory 

C. an O/S user to own the Oracle Database installation 

D. an O/S group called dba 

E. a group to own the ASMLIB-provisioned storage 

F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage 

View Answer

Q9. Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture? 

A. Each leaf node must be connected to storage shared across all cluster nodes. 

B. Hub nodes require direct access to the voting disks. 

C. Each leaf node must be connected to storage shared across all leaf nodes. 

D. Each hub node must be connected to storage shared across all hub nodes. 

E. Hub nodes require direct access to the OCR file. 

F. Leaf nodes require direct access to the voting disks. 

View Answer

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

Q11. Which two utilities support the “what-if” command evaluation? 

A. asmcmd 

B. ocrconfig 

C. oifcfg 

D. crsctl 

E. srvctl 

View Answer

Q12. You plan to create a three-instance RAC database stored in ASM, with its data files in the DATA disk group. Identify three supported storage solutions for the Fast Recovery Area (FRA). 

A. a shared nothing file system accessed directly by the database instances 

B. a cluster file system 

C. a shared NFS file system 

D. the DATA disk group 

E. a local file system with the same path name on each cluster node 

View Answer

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

Q14. Examine the output of the asmcmd and srvctl commands: 

$ asmcmd showclustermode 

ASM cluster : Flex mode enabled $ srvctl status asm –detail ASM is running on host01, 

host03 ASM is enabled. 

$ srvctl config asm 

ASM home: /u01/app/12.1.0/grid 

Password file: +DATA/orapwASM 

ASM listener: LISTENER 

ASM instance count: 2 

Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command: 

$ srvctl relocate asm – currentnode host03 –targetnode host02 

Which three statements are true regarding the execution of this command based on the 

output shown? 

A. It fails because an ASM instance is not configured to run on HOST02. 

B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03. 

C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST02. 

D. It fails because the ASM instance has not been shut down first on HOST03. 

E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut downuntil all connected clients disconnected. 

F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST01. 

View Answer

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

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

View Answer

Q17. You are developing a user callout procedure to send an email to the helpdesk whenever a 

RAC database instance fails to restart after node failure. 

Examine these tasks: 

1.Create a shell-script with the name callout.sh to send an email for the instance event. 

2.Create a shell script with any name to send an email for the instance event. 

3.Store the script in the <Grid Home>/racg/usrco directory on the first node of the cluster. 

4.Store the script in the <Grid Home>/racg/usrco directory on all the nodes of the cluster. 

5.Store the script in the <DB Home>/racg/usrco directory on the first node of the cluster. 

6.Store the script in the <DB Home>/racg/usrco directory on all the nodes of the cluster. 

7.Give the Clusterware owner execute permissions on the script. 

8.Give the Database owner execute permissions on the script. 

Identify the minimum steps required, in the correct sequence, to implement this. 

A. 1, 3, 7 

B. 1, 4, 6 

C. 2, 5, 8 

D. 2, 4, 7, 8 

E. 2, 4, 7 

F. 1, 4, 7, 8 

View Answer

Q18. Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster? 

A. at least one for the public network 

B. at least one for the storage network 

C. at least one for the interconnect 

D. at least two for the public network 

E. at least two for the storage network 

F. at least two for the interconnect 

View Answer