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.

You are asked to measure useful quantitative data about a MySQL Database Service system. You must provide information such as current connection information, statement activity, latency, and host OCPU, memory, and disk I/O utilization. Which THREE Oracle Cloud Infrastructuremonitoring methods should you use? (Choose all correct answers)

A. data points

B. metrics

C. notifications

D. alarms

E. queries

You have been brought in to help a company with slow nightly batch processing running on theirExadata Cloud Service. You have determined the workload is CPU-bound during the batch window. Which command line tool can be used to script increase or decrease OCPUs?

A. oci cli

B. ocpucli

C. exacli

D. asmali

Which TWO statements are true when enabling autonomous Data Guard on Autonomous Exadata.(Choose all correct answers)

A. Autonomous databases inherit their Data Guard configuration from their Autonomous Container Database.

B. Data Guard can be set per individual Autonomous Database within a Container Database.

C. Data Guard is not currently supported on Autonomous Exadata Cloud@Customer.

D. Autonomous Data Guard only supports Maximum Performance and Maximum Protection protection modes.

E. When in a Data Guard configuration patching will always take place on the standby database first.

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

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.

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

In a two-node Real Applications Clusterenvironment, the Internet and VCN Resolver are supported for DNS in the DB system. Which TWO tasks are required for the network setup? (Choose all correct answers)

A. After the VCN is created, modify the DNS settings to use DNS Hostnames.

B. when creatingthe database, specify a value in the Hostname Prefix.

C. Select "Use DNS Hostnames in this VCN" as the VCN is being created.

D. Select the hostname field for a DNS label when the subnet is being created.

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.