1Z0-1093-22 Online Practice Questions and Answers

Which two circumstances are FALSE when you use the Console to recover a DB systemdatabase from a backup stored in Oracle Cloud Infrastructure Object Storage? (Choose all correct answers)

A. The pp system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.

B. You want to restore to an existing System Change Number (SCN).

C. Data Guard must be disabled, or you must first remove the Data Guard association by terminating the standby database before you can restore the database.

D. Restore the database from an unmanaged backup in Object Storage created directly by using RMAN.

E. Restore the database from a backup in Object Storage that was created by using the Console or the API.

What can you use to enable an on-premises Enterprise Manager instance to monitor Exadata Cloud Service in a private OCI subnet?

A. virtual Cloud Network (VCN)

B. Client subnet

C. Virtual Network Interface Card (VNIC)

D. FastConnect

You enable automatic backups on your Exadata Cloud@Customer.?

A. database archivelog files

B. database control files

C. Transparent Data Encryption (TDE) keystore (wallet)

D. server parameter file (SP file)

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

Resources are allocated to the DB system based on the shape selected. Which TWO are options for a DB system? (Choose all correct answers)

A. Two-node bare metal servers with 512 GB memory and locally attached drives

B. Two-node virtual machine X7 with Block Storage which can be scaled up

C. One-node bare metal server with up to 52 OCPU cores and locally attached drives to the system

D. One-node virtual machine XS with 24 OCPU cores

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.

You define a maintenance window for your MySQL DB systems. When the automatic maintenance process takes place, which TWO activities does the system perform while its status is set to UPDATING? (Choose all correct answers)

A. It patches the MySQL server itself along withany underlying hardware.

B. It analyzes, rebuilds, and optimizes MySQL database tables and indexes.

C. It patches the underlying operating system of the MySQL database.

D. It upgrades the associated compute instance to the latest Linux operating system version.

While using virtual machines (VMs), the next step after selecting a shape for theDB system is to select storage options and configuration. Which TWO configurations can be selected and used? (Choose all correct answers)

A. mount block storage locally to the node.

B. Configure storage to assign 40% to DATA and the rest to redo logs andarchive logs.

C. Use Object Storage buckets for DATA, redo logs, and archive logs.

D. Use Automatic Storage Management (ASM) for the storage management software.

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

Which are THREE strategies to migrate Oracle Database to Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)

A. GoldenGate

B. Zero DowntimeMigration (ZDM)

C. Autonomous migration

D. Real Application Clusters (RAC)

E. migration workbench

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.

What NoSQL Database Cloud Service API statement can be used to adjust table capacity?

A. tableRequest

B. tableunits

C. tableLimits

D. tableProvision

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.

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.

Which characteristic is NOT a factor that impacts the capacity units for provisioning a NoSQL Database Cloud Service table?

A. record size

B. data model

C. query pattern

D. durability level