Oracle 1Z0-1093-22 Online Practice Questions and Exam Preparation

Oracle 1Z0-1093-22 Online Questions & Answers

• Question 1:

  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.
  C. Use the Create Backup button in the backup section ofthe Database Details page.

• Question 2:

  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.
  A. It patches the MySQL server itself along withany underlying hardware.
  C. It patches the underlying operating system of the MySQL database.

• Question 3:

  Which service is used by default by the MySQL Database Service to store user data to make it more resistant to failures?

  A. File Storage
  B. Data safe
  C. Block Volumes
  D. Object storage
  C. Block Volumes

• Question 4:

  You are asked to create a MySQL Database Service system. You can log in to the group's Oracle Cloud Infrastructure tenancy and access the assigned compartment, and all policies have been configured and tested. What is the next step to create a MySQL Database Service?

  A. Create a Virtual Cloud Network by using the VCN Wizard.
  B. Create a Linux compute instance.
  C. Create the MySQL DB system.
  D. Connect to the MySQL Database Service system endpoint.
  A. Create a Virtual Cloud Network by using the VCN Wizard.

• Question 5:

  Assume that there are no resource limits on your underlying Exadata Cloud@Customer hardware. What is the maximum number of Autonomous container databases that can be created on one Autonomous VM cluster?

  A. 12
  B. 4
  C. 5
  D. 32
  A. 12

• Question 6:

  You want to connect to your MySQL DB system's endpoint. You create an Oracle Linux computeinstance on the same Virtual Cloud Network as your MySQL DB system.

  Which TWO actions must you perform to connect to your MySQL Database Service system? (Choose all correct answers)

  A. Install the MySQL client on your local computer.
  B. Define a SQL Developer connection in your MySQL Database Service database system.
  C. Connect to your database system by using the MySQL client on the Linux compute instance.
  D. ssh into the compute instance from your local machine.
  C. Connect to your database system by using the MySQL client on the Linux compute instance.
  D. ssh into the compute instance from your local machine.

• Question 7:

  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
  C. allows SSH traffic from anywhere
  D. allows Path MTU Discovery fragmentation messages

• Question 8:

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

• Question 9:

  The /u02 directory containing Oracle Homes (OH) is 80% utilized and you need to free up space in it. you own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively).You decide to consolidate both databases into a single Oracle Home (OH193. |_A) to free up space. Which TWO actions must you perform? (Choose all correct answers)

  A. use the Move Database option from the console.
  B. Schedule a downtime window with the Test teams whouse the 193B database.
  C. Copy the sqinet.ora file from OH193_B to OH193_A.
  D. Create a new container under 0H193B and migrate the pluggable databases (PDBs) from 193B to 193A.
  A. use the Move Database option from the console.
  B. Schedule a downtime window with the Test teams whouse the 193B database.

• Question 10:

  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
  D. OCPU for all servers in the cluster