Oracle Oracle Certifications 1Z0-1093-22 Questions & Answers

• Question 11:

  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

  Correct Answer: ABE

• Question 12:

  WhichTHREE are prerequisites for using the MySQL Database Service? (Choose all correct answers)

  A. You must create a tenancy and be able to sign in to it.

  B. You must download the latest MySQL version from https://edelivery.oracle.com/.

  C. You or your group must be granted the policies described in Mandatory Policies.

  D. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

  E. You must create a compartment to store your resources.

  Correct Answer: ACE

• Question 13:

  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

  Correct Answer: C

• Question 14:

  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.

  Correct Answer: BC

• Question 15:

  You want to scale within Exadata System. Which of the following two statements are true? (Choose all correct answers)

  A. The setting of database parameter CPU_COUNT is affected bymodifying the number of enabled OCPU cores.

  B. Modifying the number of enabled OCPU cores does not require database downtime.

  C. Modifying the number of enabled OCPU cores requires database downtime.

  D. The setting of database parameter CPU_COUNT is not affected by modifying the number of enabled OCPU cores.

  Correct Answer: AB

• Question 16:

  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.

  Correct Answer: CD

• Question 17:

  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.

  Correct Answer: A

• Question 18:

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

  Correct Answer: BC

• Question 19:

  Which statement is true about moving virtual machine (VM) database (DB) systems from one compartment to another?

  A. You do not need accesspermissions to the compartment that the resource Is being moved to when moving VM DB systems to a different compartment.

  B. You can move DB systems to a different compartment if you have sufficient access permissions to the compartment that the resource isbeing moved to, as well as the current compartment.

  C. You have to move dependent resources like Database Homes and databases to the destination compartment before moving the VM DB system.

  D. You can move VM DB systems from one compartment to another by only using Oracle Cloud Infrastructure REST APIs.

  Correct Answer: B

• Question 20:

  Patching requires role permissions. However, since roles are not granted by default, which role needs to be added to someone patching the DB system?

  A. Let security admins manage vaults, keys, and secrets.

  B. Let database and fleet admins manage Autonomous Databases.

  C. Let database administrator's manage DB systems.

  D. Let users manage compute instance configurations, instance pools, and cluster networks.

  Correct Answer: C