1Z0-1093-23 Online Practice Questions and Answers

You have permanently deleted your MySQL database system.

What happens to the two backups that are associated with the deleted database system?

A. They are archived and moved to Oracle Cloud Infrastructure file storage.

B. They are retained for their retention periods.

C. They are automatically deleted along with the database system.

D. They are moved to Oracle Cloud Infrastructure Object Storage.

Which two statements are true about cloning a Virtual Machine DB System? (Choose two.)

A. When creating a clone of the Virtual Machine DB system, you need to specify a new SSH key and admin password.

B. Cloning creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, including the storage configuration software and database volumes.

C. When creating a clone, you must use the same SSH key and admin password as the source Virtual Machine DB system.

D. Cloning only creates a copy of a source Virtual Machine DB system as it exists at the time of the cloning operation, but does not include the storage configuration software and database volumes.

While configuring a Virtual Machines (VM) database (DB) system, the next step after selecting a shape for the DB system is to select storage options and configuration. Which two configurations should you select and use? (Choose two.)

A. Use Automatic Storage Management (ASM) for the storage management software of single and two-node VM deployments.

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

C. Use Logical Volume Manager (LVM) for the storage management of single-node VM deployments.

D. Configure storage to assign 40% to DATA and the rest to redo logs and archive logs.

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 downtime?

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

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

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

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

Which Oracle Cloud service does NOT support Real Application Cluster database?

A. VM

B. Bare Metal

C. Exadata Cloud Service (both ExaCS and ExaCC)

D. Autonomous Database

What is true about scheduling Infrastructure maintenance?

A. Customers do not have control over Infrastructure maintenance schedule because Oracle undertake this effort.

B. Customers can schedule the Automatic Infrastructure maintenance window.

C. Oracle provides you a choice of three maintenance windows to choose from.

D. You can only choose the time of day that Infrastructure maintenance can be scheduled for.

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

Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

A. cellcli

B. OCI CLI

C. dbaascli

D. exacli

You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase to solve this?

A. storage capacity

B. storage capacity

C. index size

D. OCPU for all servers in the cluster

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