1z0-1093-22 Certification Overview – [Jan 02, 2024] Latest 1z0-1093-22 PDF Dumps [Q13-Q34]

Rate this post

1z0-1093-22 Certification Overview – [Jan 02, 2024] Latest 1z0-1093-22 PDF Dumps

The Best Oracle 1z0-1093-22 Study Guides and Dumps of 2024

Q13. Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?

The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes.

Oracle Clusterware is down on the VM cluster.

The required patch is available on the Control Plane server.

All database compute nodes of the VM cluster are up and running.

Q14. You want to connect to your MySQL DB system’s endpoint. You create an Oracle Linux compute instance 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)

Install the MySQL client on your local computer.

Define a SQL Developer connection in your MySQL Database Service database system.

Connect to your database system by using the MySQL client on the Linux compute instance.

ssh into the compute instance from your local machine.

Q15. In a two-node Real Applications Cluster environment, 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)

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

when creating the database, specify a value in the Hostname Prefix.

Select “Use DNS Hostnames in this VCN” as the VCN is being created.

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

Q16. You used the “Stop” option from the Console of an Exadata Cloud Service virtual machine within a VM cluster. What impact does this have?

The Exadata Cloud Service is stopped.

All the virtual machines in the VM cluster are stopped.

All the databases and infrastructure associated with the Exadata Cloud Service are stopped.

The Stopped virtual machine is not available to any other database deployment.

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

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

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

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.

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

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

Q18. You are considering whether or not to implement bare metal or virtual machine shapes. Which TWO statements are true about bare metal and virtual machine (VM) database (DB) systems? (Choose all correct answers)

Both bare metal and vm DB systems support two-node Real Application Clusters (RAC) systems.

The Console, API, and Oracle Cloud Infrastructure CLI are options for managing bare metal DB systems.

Bare metal shapes determine the total raw storage allocated to bare metal DB systems.

Bare metal and VM DB can only have a single Database Home, and the single database will be the version of the Database Home.

Q19. 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 Cloud Service. How do you do this?

Disable the automatic backup configuration and then take an on-demand backup.

First connect to the Exadata Cloud Instance as the oracle user and then take a backup.

Use the Create Backup button in the backup section of the Database Details page.

Perform a recovery operation to a specific long-term backup.

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

storage capacity

index size

OCPU for all servers in the cluster

Q21. Which three statements are true regarding MySQL Database Service HeatWave? (Choose all correct answers) HeatWave uses periodic long-running ETL batch jobs to refresh the data.

Heatwave is a in-memory, query-processing engine designed for fast execution of analytic queries.

Heatwave is Exclusively available in Oracle Cloud Infrastructure.

Heatwave uses machine learning to automate operations, increasing DBA productivity and reducing costs.

HeatWave data which is needed for analytic processing is stored in disk files.

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

use the Move Database option from the console.

Schedule a downtime window with the Test teams who use the 193B database.

Copy the sqinet.ora file from OH193_B to OH193_A.

Create a new container under 0H193B and migrate the pluggable databases (PDBs) from 193B to 193A.

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

tableRequest

tableunits

tableLimits

tableProvision

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

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

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

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

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

Q25. 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?

Create a Virtual Cloud Network by using the VCN Wizard.

Create a Linux compute instance.

Create the MySQL DB system.

Connect to the MySQL Database Service system endpoint.

Q26. When you created your development database on Exadata Cloud@Customer, you selected “None” for backup location during provisioning. You now need to enable automatic backups on the development database with a retention period of 45 days. Which action should you perform?

No action can be taken, because a new backup location cannot be set after creation.

Change the database backup location to local storage backups and set retention to 45 days.

Change the database backup location to an NFS backup location with a 45-day retention period set.

Change the database backup location to Object Storage with the default retention period set.

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

Configure auto indexing.

Kill a running SQL session.

View ASH Analytics.

scale OCPUs for an autonomous database.

Configure IO resource management (IORM).

Q28. You have been brought in to help a company with slow nightly batch processing running on their Exadata 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?

oci cli

ocpucli

exacli

asmali

Q29. What permissions do you need to perform actions on a NoSQL table?

NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

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

cellcli

OCI CLI

dbaascli

exacli

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

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

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

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

One-node virtual machine XS with 24 OCPU cores

Q32. What information is required to connect to the NoSQL Database Cloud Service?

API signing key, admin ID, user ID

signing key fingerprint, API signing key, tenancy OCID

user ID, tenancy ID, component ID

tenancy 1D, passphrase, handshake key

Q33. You want to move an Exadata Cloud@Customer VM cluster to a different OCI compartment for increased isolation from other teams that use Exadat a. What happens when you use the console to do this?

The VM cluster and associated databases will move to the new compartment. All other resources will remain in the existing compartment.

After it is deployed, a VM cluster cannot change compartments.

The vm cluster, compute nodes, and associated databases will move compartments. All other resources will remain in the existing compartment.

The vM cluster, compute nodes, and underlying Exadata infrastructure will move to the new compartment. All other resources remain the same.

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

It patches the MySQL server itself along with any underlying hardware.

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

It patches the underlying operating system of the MySQL database.

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