Free Actual Oracle 1Z0-078 Exam Questions & Answers

Question 1

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

A2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT

B2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT

C3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT

D3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE

E3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Correct : D, E

Options Selected by Other Users:

Question 2

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

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

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

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

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

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

Correct : A, B, C

Oracle 1Z0-078 Exam Questions - Navigate Your Path to Success

Sample Questions for Oracle 1Z0-078 Exam Preparation

Options Selected by Other Users:

Options Selected by Other Users: