Question 1

Which two tools can you use to create a HeatWave MySQL Database Service System?

Options :

A : OCI Console

B : OCI Command Line Interface

C : OCI Bastion Server

D : MySQL Shell on OCI Compute

E : OCI SQL Developer

Answer: A,B

Question 2

When upgrading the Oracle Database software version on a BaseDB VM system, what is the primary responsibility of the database administrator (DBA) regarding the underlying operating system?

Options :

A : The DBA is responsible for initiating and managing the operating system upgrade process through the Oracle Cloud Infrastructure console.

B : The DBA must ensure the operating system is compatible with the target Oracle Database software version before initiating the database upgrade.

C : The DBA has no direct responsibility for the operating system as it is fully managed by Oracle Cloud Infrastructure.

D : The DBA should manually update the operating system packages after the database upgrade is successfully completed.

Answer: B

Question 3

Which of the following is a TRUE statement regarding the storage options typically available when launching an Oracle Cloud Infrastructure (OCI) Base Database Service (BaseDB) virtual machine (VM)?

Options :

A : Block Volumes provide the primary storage and are directly attached to the VM.

B : Object Storage is the default storage option for database datafiles.

C : Local NVMe storage is always the default for BaseDB.

D : File Storage is mandatory for database backups.

Answer: A

Question 4

Which BaseDB lifecycle management activity is MOST directly associated with ensuring the continued availability of a database instance during a planned maintenance window?

Options :

A : Taking a full database backup using RMAN.

B : Performing an in-place upgrade of the database software.

C : Using Oracle Data Guard for a switchover operation.

D : Applying a quarterly security patch.

E : Resizing the block volume storage.

Answer: C

Question 5

Which database lifecycle management operation in BaseDB requires the creation of a new database home and is non-reversible after completion?

Options :

A : Upgrading the Oracle Grid Infrastructure.

B : Scaling the compute shape of the VM.

C : Upgrading the Oracle Database software version.

D : Applying an operating system patch.

E : Enabling Automatic Storage Management (ASM).

Answer: C