Free Oracle 1Z0-078 Exam Questions

Become Oracle Certified with updated 1Z0-078 exam questions and correct answers

Page: 1 / 106

Total 529 Questions | Updated On: Jan 13, 2026

Add To Cart

Question 1

Which resource in RAC allows multiple instances to concurrently access the same data without conflicts?

A : Cluster Database Service (CDB)

B : Global Enqueue Service (GES)

C : Automatic Storage Management (ASM)

D : Database Control File

Answer: B

Question 2

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

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 3

What is the role of the Oracle RAC database instance in the architecture?

A : To manage the disk storage for the database

B : To manage the shared cache across cluster nodes

C : To synchronize data across cluster nodes

D : To provide a connection to the database for clients

Answer: D

Question 4

What is the purpose of the Oracle Global Cache Service (GCS) in Oracle RAC?

A : To provide high availability through automatic failover

B : To manage network communication between nodes in the cluster

C : To ensure data consistency and prevent concurrent access conflicts

D : To manage the shared cache across multiple cluster nodes

Answer: D

Question 5

Which of the following statements is true about the Flashback Database feature in RAC?

A : Flashback Database can only be used to recover individual RAC instances.

B : Flashback Database can only be used in single-instance databases and not in RAC.

C : Flashback Database allows for point-in-time recovery of the entire RAC database.

D : Flashback Database is not a recommended feature for backup and recovery in RAC.

Answer: C

Page: 1 / 106

Total 529 Questions | Updated On: Jan 13, 2026

Add To Cart