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

When configuringconnectivity for hosts in the VCN, security lists contain defaults for implementing security rules. Which TWO additional rules are needed for database systems? (Choose all correct answers)

A. allows SQL*NET traffic from within the VCN

B. allows ONS and FANtraffic from within the VCN

C. allows SSH traffic from anywhere

D. allows Path MTU Discovery fragmentation messages

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.

Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)

A. Local storage

B. Object Storage

C. EFS Storage

D. Block Storage

E. File Storage

F. EBS Storage

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

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

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

What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud Service? (Choose all correct answers)

A. for high availability

B. for Fast StartFailover of storage cells

C. for Data Guard

D. for Real Application Clusters

E. for triple mirroring of data

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.