Oracle Base Database Services 2023 Professional

Here you have the best Oracle 1z0-1093-23 practice exam questions

You have 35 total questions to study from
Each page has 5 questions, making a total of 7 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on May 30, 2025
This site is not affiliated with or endorsed by Oracle.

Question 1 of 35

What is the NoSQLHandle interface NOT used for?

to set the row retention time

to gets rows from a table

to get dynamic information on a table

to access multiple tables

Correct Answer: A

The NoSQLHandle interface is not used to set the row retention time. It is utilized to interact with and manage data within NoSQL databases, including getting rows from a table, getting dynamic information on a table, and accessing multiple tables. However, setting the row retention time is typically managed through different configuration settings or commands outside the scope of NoSQLHandle interface.

Question 2 of 35

You have permanently deleted your MySQL database system.

What happens to the two backups that are associated with the deleted database system?

They are archived and moved to Oracle Cloud Infrastructure file storage.

They are retained for their retention periods.

They are automatically deleted along with the database system.

They are moved to Oracle Cloud Infrastructure Object Storage.

Correct Answer: C

When a MySQL database system is permanently deleted, the automatic backups associated with it are also automatically deleted. This is a standard behavior for backup systems where backups are tightly coupled with the existence of the primary resource. Hence, they do not continue to exist independently after the primary resource is removed unless specific retention policies or configurations are set beforehand.

Question 3 of 35

Your MySQL Database Service system is automatically backed up between midnight and 1 AM.

What must you do to change the starting time to 4 AM?

Select Backup Window from the Edit MySQL DB System Details page and set the start time to 4 AM.

Use the mysqlbackup command to establish a 4 AM backup start time.

Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time.

Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.

Correct Answer: C

To change the starting time for automatic backups in Oracle Cloud Infrastructure (OCI) MySQL Database Service, you must update the backup window setting on the OCI MySQL DB System Details page. This is where you can specify the desired start time, such as 4 AM. The other methods mentioned either do not provide the correct approach or mix up backup settings with other configurations.

Question 4 of 35

Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.)

Oracle 18c Database deployed on Oracle Exadata Cloud@Customer

Oracle Autonomous Database 19c deployed on an OCI Tenant

Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine

Oracle 11gR2 Database deployed on an Oracle Private Cloud

Correct Answer: A, C

OCI Database Management Service can monitor Oracle 18c Database deployed on Oracle Exadata Cloud@Customer and Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine, as these are considered external databases to the OCI environment.

Question 5 of 35

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.