Question 1

In a key-value NoSQL database, what is the primary mechanism for accessing data?

Options :

A : Using SQL queries to filter and retrieve data based on complex criteria.

B : Using a unique key to retrieve the associated value directly.

C : Traversing relationships between nodes to find related data.

D : Scanning all documents in the database to find matching data.

Answer: B

Question 2

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

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 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 5

Which two metrics are available for monitoring within the Performance Hub's Real-Time SQL Monitoring feature in Database Management?

Options :

A : Physical Reads

B : Average Active Sessions

C : Number of CPUs on the host

D : Database Version

Answer: A,B

Confidently Practice Online with Free 1Z0-1093-25 Exam Cram

Buying Options: