1Z0-1093-23 Online Practice Questions and Answers

You have permanently deleted your MySQL database system.

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

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

B. They are retained for their retention periods.

C. They are automatically deleted along with the database system.

D. They are moved to Oracle Cloud Infrastructure Object Storage.

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

A. 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.

B. Exadata Snapshots are unable to utilize all the Exadata features.

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

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

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

Which two statements are true about cloning a Virtual Machine DB System? (Choose two.)

A. When creating a clone of the Virtual Machine DB system, you need to specify a new SSH key and admin password.

B. Cloning creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, including the storage configuration software and database volumes.

C. When creating a clone, you must use the same SSH key and admin password as the source Virtual Machine DB system.

D. Cloning only creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, but does not include the storage configuration software and database volumes.

Which two must you create or configure to manage an external database? (Choose two.)

A. A dynamic group

B. A database handle

C. A database group

D. A database connection

You want to check if cloud tools are up-to-date in Exadata Database Service.

Which two steps should you perform to obtain the current version of cloud tooling on a database server? (Choose two.)

A. You must first connect to Exadata Cloud Service as the oracle user.

B. Run the dbaascli patch tools list command.

C. You must first connect to Exadata Cloud Service as opc and sudo to the root user.

D. Run the rpm -qa|grep -i dbaastools_exadata command.

Which users created on Database Servers can be used for both Oracle database and host management of your Exadata Database Service?

A. root, opc, oracle, and grid users

B. root, opc, oracle, grid, and cloud users

C. opc, oracle, and grid users

D. root, oracle, and grid users

NoSQL Database Cloud Service supports all three types of big data. Which is NOT considered big data?

A. structured data

B. semi-structured data

C. unstructured data

D. free-structured data

Which two statements are true about using a Service Gateway? (Choose two.)

A. The Service Gateway with a private subnet can be used to access Object Storage.

B. The Service Gateway can connect to services in the same region of its VCN.

C. The Service Gateway can connect to services in other regions outside of the VCN.

D. The Service Gateway can be used to connect to the Internet.

E. The Service Gateway with a public subnet can be used to access Object Storage.

On the Add HeatWave Cluster dialog, you are asked to provide the shape for the HeatWave nodes. Which detail does the shape selection provide to HeatWave?

A. The associated database system network Gbps

B. The Disk partition count for the HeatWave cluster

C. The private IP address for the Analytic Cluster

D. The number of CPUs for the Analytic cluster

Which statement is FALSE related to loading a table into HeatWave?

A. Data is distributed among analytics nodes by slicing tables by vertically.

B. Data is read from InnoDB using batched, multi-threaded reads.

C. Data is partitioned by primary key unless data placement keys are defined.

D. Data is converted into columnar format and sent over the network.

You want to create a backup of only the data that was added or changed since the last FULL backup.

Which type of supported backup by MySQL Database Service must you use?

A. Incremental

B. Full

C. Mirror

D. mysqldump

When you created your development database on Exadata Cloud@Customer, you selected "None" for backup location. You now need to enable Automatic backups on the development database with a retention period of 60 days.

Which action should you perform?

A. Change the database backup location to a local storage and set the retention period to 60 days.

B. No action can be taken, because a new backup location cannot be set after creation.

C. Change the database backup location to an NFS backup location and set the retention period to 60 days.

D. Change the database backup location to Object storage with the default retention period set.

You can manage and monitor performance of an autonomous database running on autonomous Exadata Cloud @ Customer using the Performance Hub. Which two actions can be undertaken by Performance Hub? (Choose all correct answers)

A. Configure auto indexing.

B. Kill a running SQL session.

C. View ASH Analytics.

D. scale OCPUs for an autonomous database.

E. Configure IO resource management (IORM).

Which TWO statements are true about Interface for Exadata I/O Resource Management (IORM)? (Choose all correct answers)

A. IORM allows workloads and databases to share I/O resources automatically according to admin-defined policies.

B. IORM can be enabled across multiple databases using the Cloud interface of Exadata Cloud Service.

C. IORM allows workloads and databases to share I/O resources automatically according to user requests.

D. IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service.

You are using the CLI command oci mysql db-system get, to retrieve the MySQL Database System details. What value must you provide to perform this task?

A. DB System Tenancy ID

B. DB System DB ID

C. DB System IP address

D. DB System OCID