Oracle 1z0-1093-23 Exam Questions

Question 6 of 66

You define a maintenance window for your MySQL DB systems. When the automatic maintenance process takes place, which two activities does the system perform while its status is set to UPDATING?

It upgrades the associated compute instance to the latest Linux operating system version.

It analyzes, rebuilds, and optimizes MySQL database tables and indexes.

It patches the MySQL server itself along with any underlying hardware.

It patches the underlying operating system of the MySQL database.

Correct Answer: C, D

During the maintenance window for MySQL DB systems, the system typically performs activities such as patching the MySQL server itself along with any underlying hardware, and patching the underlying operating system of the MySQL database. These activities ensure that both the database software and the operating system are kept up-to-date and secure.

Question 7 of 66

Which two use cases can be used by the Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose two.)

Database datafiles

Database backups

Database log files

Database binaries

Correct Answer: B, C

Question 8 of 66

How many IPs are required for the Backup Subnet supporting an Exadata Database Service with six Database Compute Servers?

Correct Answer: A

For an Exadata Database Service with six Database Compute Servers, each server would typically require two IP addresses, one for each network interface. Therefore, the total number of IPs needed would be 6 servers * 2 IPs = 12 IPs.

Question 9 of 66

Which two statements are true about recommended Subnet configurations for Exadata Database Service? (Choose two.)

Use Regional Subnets for both Client and Backup.

Use a Public Subnet for Client and a Service Subnet for Backup.

Use a Private Subnet for Client and a Service Subnet for Backup.

Use two Public Subnets for Client and Backup.

Use a Private Subnet for Client and Private Subnet for Backup.

Correct Answer: A, E

Question 10 of 66

Which three statements are true about Exadata Snapshots on the Exadata Database Service? (Choose three.)

Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain all the data that is read and written by the Snapshots.

Exadata Snapshots are unable to utilize all the Exadata features.

Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain only changed blocks.

Multiple users can create independent Exadata Snapshots from the same test master, which is a full Read-Only clone of the source database.

Before creating Exadata Snapshots from the test master, you can modify the data in the test master, if required.

Correct Answer: C, D, E

Exadata Snapshots utilize the Exadata SPARSE disk group to store the sparse files that contain only the changed blocks. Multiple users can create independent Exadata Snapshots from the same test master, which is a full Read-Only clone of the source database. Additionally, before creating Exadata Snapshots from the test master, you can modify the data in the test master if required.