Oracle Base Database Services 2023 Professional: 1Z0-1093-23

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.

Which two statements are true about changing the shape of a virtual machine (VM) database (DB) system to adapt to changes in performance needs? (Choose two.)

A. It is possible to change the shape of a VM DB system without impacting the amount of storage available to the DB system.

B. It is possible to change the shape of a VM DB system with a higher number of OCPUs. However, reducing the number of OCPUs is not permitted.

C. After you provision a VM DB system with a shape that supports Oracle RAC, you can change the current shape to another shape that does not support Oracle RAC.

D. After you provision a VM DB system, you cannot change the shape; you have to provision another VM DB system using a full backup.

E. If the current shape of the VM DB system supports Oracle Real Application Clusters (RAC), then you can only change the current shape to another shape that also supports Oracle RAC.

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