1z0-078 by Oracle Actual Free Exam Questions And Answers

Question 1

Examine this query and output:

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? (Choose two.)

A. alter sequence seql keep;

B. alter sequence seql order;

C. exec sys.dbms shared pool.keep('SEQ1','Q'>

D. alter sequence seal cache 10000;

E. alter sequence seql noorder;

Discussion 0

Correct Answer: D,E Vote an answer

Question 2

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

A. acfsutil audit purge can be run by an audit manager.

B. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.

C. acfsutil audit read marks audit files to indicate that it is safe to purge them.

D. acfsutil audit init must be run by a system administrator.

E. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 3

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

A. crsctl stop crs

B. crsctl stop cluster

C. crsctl disable crs

D. crsctl config crs

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

A. An administrator-defined policy may be activated using the srvctl utility.

B. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

C. When a policy is first created, it is initially active.

D. When a policy is activated, resources cannot be automatically started to comply with the policy definition.

E. When a policy is first created, it is initially inactive.

F. When a policy is activated, resources can be automatically stopped to comply with the policy definition.

Discussion 0

Correct Answer: A,E,F Vote an answer

Question 5

Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)

A. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

B. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.

C. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.

D. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

E. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 6

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

A. The maximum value of ASM_POWER_LIMIT is 1024.

B. The default value of INSTANCE_TYPE is ASM.

C. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.

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

E. The ASM_DISKGOUPS parameter is optional.

Discussion 0

Correct Answer: B,E Vote an answer

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 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.

B. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.

C. Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

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

Discussion 0

Correct Answer: A Vote an answer

Question 8

Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)

A. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.

B. Oracle Managed Files must be enabled or PD3 file name convert must be set.

C. The source pdb must use a global temporary

D. All running CDB instances must be open in restricted mode.

E. The source PD3 must be closed on the CDS instance from where the command is executed.

F. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

Discussion 0

Correct Answer: B,E,F Vote an answer

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

Contact Us

Useful Links

Latest Updated