Limited-Time Offer: Enjoy 50% Savings! Ends in 00h 00m 00s Coupon code: 50OFF
Skip to content
Login Sign up

Free Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration 1Z0-078 Exam Questions

Page: 1 / 8 Total 77 questions

Want more questions? Get Premium Access.

Question 1

Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)

Correct Answer: C. If network time protocol (NJP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.; D. Configure network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.

Question 2

Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

Correct Answer: B. All ASM Disks belonging to a disk group should be of the same size for optimal performance.; D. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

Question 3

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?

Correct Answer: C. Fast Connection Failover (FCF)

Question 4

Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)

Correct Answer: D. an application resource; E. a script agent

Question 5

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

Correct Answer: B. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.; D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

Question 6

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

Correct Answer: A. The source PD3 must be closed on the CDS instance from where the command is executed.; D. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.; E. Oracle Managed Files must be enabled or PD3 file name convert must be set.

Question 7

Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)

Correct Answer: B. Transparent Application Continuity is enabled when failover type=auto.; C. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.

Question 8

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

Correct Answer: B. 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.

Question 9

Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

Correct Answer: B. They can be policy managed for a multitenant database.; C. Policy-managed services specified for a database allow the creation of a new server pool using dbca.; D. They can be administrator managed for a multitenant database.

Question 10

Examine the output of this command:

The ACFS disk group is a normal redundancy disk group with 5 GB of free space.

To increase the size of the ACFS file system, you execute this command as the root user:

$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount

Which two statements are true regarding the outcome of this command? (Choose two.)

Correct Answer: D. It resizes voli.; E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Page: 1 / 8 Total 77 questions