1z0-078 by Oracle Valid Free Exam Practice Test

Question 1

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

A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory. B. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges. C. An ACFS snapshot can be ACFS encrypted. D. acfsucil encr on can be used to specify the encryption key length for a directory or file. E. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.

Correct Answer: C,D,E

Question 2

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)

A. Load balancing can be done by the client or the listener, but not both, for any one connection request. B. Services support the balancing of client connections across RAC database instances. C. Load balancing can be done by the client, the listener, or both, for any one connection request. D. Client-side connect-time load balancing can balance connection requests across SCAN listeners. E. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.

Correct Answer: B,C,E

Question 3

Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)

A. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size. B. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor C. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository. D. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner. E. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.

Correct Answer: C,D

Question 4

Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)

A. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE B. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT D. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT E. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Correct Answer: A,E

Question 5

Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)

A. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced. B. The ASM_DISKGOUPS parameter is optional. C. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect. D. The maximum value of ASM_POWER_LIMIT is 1024. E. The default value of INSTANCE_TYPE is ASM.

Correct Answer: B,E

Question 6

Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

A. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes. B. The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes. C. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes. D. The CLUVFY utility can check the integrity of the OCR but not the OLR. E. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

Correct Answer: A,C,E

Question 7

A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups..
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?

A. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2. B. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2. C. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1. D. Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1. E. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1

Correct Answer: C

Question 8

You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

A. Create the current yr directory in the +data disk group. B. Add the autoextend on clause to the command. C. Create the current yr directory in the root directory (+). D. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command. E. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.

Correct Answer: A,D

Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z0-078 Exam Practice Test