1Z0-1093-22 Online Practice Questions and Answers

Your company's security policy requires you to patch the database within a month of a relevant database patch being released by Oracle.Which method requires the least amount of down time?

A. Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home.

B. Own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and193B respectively).

C. Back up your database, run a precheck, then apply the patch on the database home where the database resides.

D. Download the latest patch from MOS, back up your database, and use dbaasc1i to apply the patch on the database home.

E. Create a new database home, patch it to the version you want, and then move the database to the new home.

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

(Choose all correct answers)

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

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

C. The shape of a VM DB system can be changed at any time, with no impact on the amount of storage available to the DB system.

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

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

Which THREE Oracle Cloud Infrastructure (OCI) services can be used to connect to on- premises networks? (Choose all correct answers)

A. Internet Gateway

B. Fastconnect

C. Dynamic Routing Gateway (DRG)

D. Service Gateway

E. IPSec VPN

You want to move an Exadata Cloud@Customer VM cluster to a different OCI compartment for increased isolation from other teams that use Exadata. What happens when you use the console to do this?

A. The VM cluster and associated databases will move to the new compartment. All other resources will remain in the existing compartment.

B. After it is deployed, a VM cluster cannot change compartments.

C. The vm cluster, compute nodes, and associated databases willmove compartments. All other resources will remain in the existing compartment.

D. The vM cluster, compute nodes, and underlying Exadata infrastructure will move to the new compartment. All other resources remain the same.

Which three statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers)

HeatWave uses periodic long-running ETL batch jobs to refresh the data.

A. Heatwave is a in-memory,query-processing engine designed for fast execution of analytic queries.

B. Heatwave is Exclusively available in Oracle Cloud Infrastructure.

C. Heatwave uses machine learning to automate operations, increasing DBA productivity and reducing costs.

D. HeatWave data which is needed for analytic processing is stored in disk files.

Which set of data types is supported by the NoSQLDatabase Cloud Service tables?

A. XML, JSON, array

B. Iong, double, triple

C. enum, map, record

D. Boolean, date stamp, float

You want to permanently delete the DB System and its attached HeatWave cluster. Which action should you perform?

A. Terminate the DB system and drop the associated HeatWave Cluster.

B. Delete the Heatwave Cluster and it will also delete the DB system.

C. Delete the DBsystem and it will also delete the attached HeatWave Cluster.

D. Drop the DB system and terminate the associated HeatWave Cluster.

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?

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

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

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

D. From the Edit MySQL DB System Details page, select Backup Window and set the start time to 4 AM.

In Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is the minimum egress requirement needed to enable Data Guard between Exadata Cloud Services?

A. Tcp traffic only for port 1521 and port 22

B. Tcp traffic only for port 1521

C. Tcp traffic only for port 22

D. Open for all protocols

What information is required to connect to the NoSQL Database Cloud Service?

A. API signing key, adminID, user ID

B. signing key fingerprint, API signing key, tenancy OCID

C. user ID, tenancy ID, component ID

D. tenancy 1D, passphrase, handshake key

WhichTHREE are prerequisites for using the MySQL Database Service? (Choose all correct answers)

A. You must create a tenancy and be able to sign in to it.

B. You must download the latest MySQL version from https://edelivery.oracle.com/.

C. You or your group must be granted the policies described in Mandatory Policies.

D. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

E. You must create a compartment to store your resources.

How many IP addresses do you need at a minimum for the client subnet when you plan to have four Exadata compute nodes onExadata Cloud Service?

A. 32

B. 14

C. 4

D. 18

E. 8

Which network is used to facilitate the secure monitoring andadministration of Oracle- managed infrastructure components in Exadata Cloud@Customer?

A. InfiniBand network

B. Backup network

C. Client network

D. Control plane network

E. Cloud operations network

What permissions do you need to perform actions on a NoSQL table?

A. NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

B. NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

C. NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

D. NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

In addition to the automatic backup of your Oracle Database associated with a database deployment, you are planning to take an on-demand backup of a database on Exadata CloudService. How do you do this?

A. Disable the automatic backup configuration and then take an on-demand backup.

B. First connect to the Exadata Cloud Instance as the oracle user and then take a backup.

C. Use the Create Backup button in the backup section ofthe Database Details page.

D. Perform a recovery operation to a specific long-term backup.