Question 1

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

Options :

A : Create the current yr directory in the root directory (+).

B : Create the currentyr directory in the +data disk group.

C : Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.

D : Add the autoextend on clause to the command.

E : lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.

Answer: B,C

Question 2

What is the purpose of the Oracle Clusterware?

Options :

A :

To manage and monitor the Grid Infrastructure components

B :

To perform backup and recovery operations for the cluster

C :

To provide high availability and fault tolerance for the cluster

D :

To manage and monitor the RAC databases

Answer: C

Question 3

Which of the following processes is responsible for coordinating message transactions between instances in a RAC database?

Options :

A :

LGWR

B :

LCK

C : LMD

D :

LMON

Answer: C

Question 4

During the installation of Oracle RAC, which configuration option should be selected to enable Oracle ASM Disk Groups?

Options :

A :

External redundancy

B :

High redundancy

C :

Normal redundancy

D :

Flex ASM

Answer: C

Question 5

What is the purpose of the Clusterware component in Oracle RAC?

Options :

A :

It is responsible for creating and managing disk groups in ASM.

B :

It provides load balancing functionality for distributing workload across database instances.

C :

It manages cluster membership and handles node failures or network failures.

D :

It ensures high availability of the database by performing automatic crash recovery.

Answer: C

Free 1Z0-078 Mock Exam – Practice Online Confidently

Buying Options: