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

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 3

Which two requirements must be met before you can create an Exadata Database Service VM Cluster?

Options :

A : A configured Oracle Cloud Infrastructure (OCI) Vault and Key.

B : A Virtual Cloud Network (VCN) with necessary subnets for client access and backups.

C : A valid support identifier (SI) associated with the OCI account.

D : A configured Exadata Cloud@Customer infrastructure.

E : An Exadata Infrastructure resource must be created first.

Answer: B,E

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 of the following is the recommended approach for migrating a large, mission-critical database from an on-premises Exadata system to Exadata Database Service with minimal downtime?

Options :

A : Traditional export/import using Data Pump over a public network.

B : Creating a physical standby database using Data Guard and switching over to the standby in OCI.

C : Performing a full backup and restore to a new Exadata Database Service instance.

D : Using SQL Developer to copy the data over a VPN connection.

Answer: B

Free 1Z0-1093-25 Mock Exam – Practice Online Confidently

Buying Options: