Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

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

Oracle 1z0-078 Premium Access     Download Demo    
Page: 1 / 3
Total 77 questions

Examine the output of theasmcmdandsrvctlcommands:

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

A.

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

B.

It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.

C.

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

D.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.

E.

It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

F.

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

Which three statements are true about undo management in a RAC environment? (Choose three.)

A.

You can dynamically assign a newly created undo tablespace to an instance.

B.

In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database.

C.

An instance that performs instance recovery can write to the undo tablespace of a failed instance.

D.

A mixture of automatic undo management and manual undo management is supported within a RAC database.

E.

It is necessary to assign a specific undo tablespace to a specific instance.

Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

A.

The disk group compatibility attribute for advm must be set to 12. l or higher.

B.

The parent snapshot must be read-only.

C.

The underlying advm volume must be configured with high redundancy.

D.

The parent snapshot must be read/write.

You performed these steps to disable an ADVM volume containing an ACFS file system:

1. Dismount the file system.

2. Disable the volume with the ASMCMDvoldisablecommand.

Which two statements are true regarding the actions performed? (Choose two.)

A.

The ACFS file system will be permanently removed from the volume.

B.

The ACFS mount registry with Oracle restart is automatically deleted.

C.

The disabling of volume does not destroy data in the file system.

D.

The volume can be enabled and the file system can be mounted back again to access the existing data.

E.

The ACFS file system will be permanently removed from the volume only if the file system is empty.

Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

A.

The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

B.

newtemplate must be defined for the +DATA disk group.

C.

Existing data files in TBS1 must also use the same template.

D.

User-defined subdirectories ORCL and USERS must already exist.

E.

The +DATA disk group should not be part of Flex ASM.

Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)

A.

It is uniformly available on all instances for administrator-managed databases.

B.

It cannot be used to automate the opening of the PDB by the Clusterware.

C.

It is automatically registered in the OCR.

D.

It is created and started on only one instance when using policy-managed database configuration.

E.

It is not automatically registered in the OCR.

Examine this query and output:

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.

TheSEQ1sequence is incremented from all instances equally and is frequently used.

Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

A.

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

B.

alter sequence seal cache 10000;

C.

alter sequence seql noorder;

D.

alter sequence seql keep;

E.

alter sequence seql order;

You administer a RAC database that currently runs on a four-node cluster but which has three instances.

Which two statements are always true about redo logs for this RAC database? (Choose two.)

A.

A thread of redo must be created before starting a fourth instance if a thread is not already available.

B.

A thread of redo is automatically dropped when an instance is removed from a RAC database by usingSRVCTL.

C.

All the instances must have the same number of redo log groups and each group must have the same number of redo log members.

D.

A redo log group added using alter database add logfile without the instance clause is added to each instance.

E.

A thread of redo must contain at least two log groups before it can be enabled.

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

A.

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

B.

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

C.

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

D.

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

E.

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

F.

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

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

A.

Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.

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.

D.

Recovery of the user database session is done safely by enabling auto recover within the user database session.

E.

Transparent Application Continuity is enabled when failover type=All