Get 2023 Updated Free Oracle 1z0-1093-22 Exam Questions & Answer [Q27-Q41]

ExamBoosts April 13, 2023 1z0-1093-22 > Oracle 0

Rate this post

Get 2023 Updated Free Oracle 1z0-1093-22 Exam Questions and Answer

1z0-1093-22 Dumps PDF and Test Engine Exam Questions

Oracle 1z0-1093-22 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe the Oracle Cloud Infrastructure Database Management Service Describe Oracle Cloud Platform for Database in the Cloud
Topic 2	View Fleet Summary and Management features Explain table security management
Topic 3	Explain the Exadata Database Service Manage the Exadata Database Lifecycle
Topic 4	Manage the Database Lifecycle for Database Cloud Services on a Virtual Machine DB System Describe Oracle Cloud Infrastructure Strategy (OCI)
Topic 5	Explain provisioned throughput for NoSQL Database Cloud Service MySQL Database Service and HeatWave Technical Overview
Topic 6	Utilize Exadata Cloud Management tools Describe the MySQL Database Service
Topic 7	Explain connecting to the NoSQL Database Cloud service Manage Exadata Infrastructure and VM Clusters
Topic 8	Register External Databases & enable and use Database Management Utilize Database Cloud Service Management Interfaces

NO.27 After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?

After you have provisioned a VM DB system, you cannot increase or decrease block storage.

If a vm DB system requires more block storage, increase the storage at any time without impacting the system.

If a vm DB system has different requirements for block storage, increase or decrease the storage at any time without impacting the system.

Only bare metal DB systems can increase block storage at any time without impacting the system.

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

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

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

Modifying the number of enabled OCPU cores requires database downtime.

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

NO.29 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 down time?

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

Own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively).

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

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

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

NO.30 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.

NO.31 You want to permanently delete the DB System and its attached HeatWave cluster. Which action should you perform?

Terminate the DB system and drop the associated HeatWave Cluster.

Delete the Heatwave Cluster and it will also delete the DB system.

Delete the DB system and it will also delete the attached HeatWave Cluster.

Drop the DB system and terminate the associated HeatWave Cluster.

NO.32 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.

NO.33 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

NO.34 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

NO.35 Which set of data types is supported by the NoSQL Database Cloud Service tables?

XML, JSON, array

Iong, double, triple

enum, map, record

Boolean, date stamp, float

NO.36 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.

NO.37 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 Infrastructure monitoring methods should you use? (Choose all correct answers)

data points

metrics

notifications

alarms

queries

NO.38 What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell?

Add an ingress rule for port 20.

Instantiate MySQL Shell on the MySQL database system instance.

Connect to the MySQL Database Service instance.

SSH into the compute instance from your local machine.

Start MySQL Shell on the compute instance.

NO.39 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?

NO.40 Which TWO statements are true when deciding which Oracle Cloud Infrastructure (OCI) region to register an Exadata Cloud@Customer infrastructure in? (Choose all correct answers)

Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region.

Consider any business policies or regulations that preclude the use of a particular region.

Consider the physical proximity of the region you register the infrastructure in to your data center.

The Exadata Cloud@Customer region can be changed after the infrastructure is created.

Consider which availability domain (within the region) to create the Exadata Cloud@Customer infrastructure in.

NO.41 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.

Loading …