1Z0-1093-21 Exam PDF [2022] Tests Free Updated Today with Correct 56 Questions [Q28-Q44]

Rate this post

1Z0-1093-21 Exam PDF [2022] Tests Free Updated Today with Correct 56 Questions

Oracle 1Z0-1093-21 Exam Preparation Guide and PDF Download

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

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

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

File Storage

Data safe

Block Volumes

Object storage

Q31. Which two statements are true about changing the shape of a virtual machine (VM) database (DB) system to adapt to changes in performance needs?
(Choose all correct answers)

After you provision a VM DB system with a shape that supports Oracle RAC, you can change that shape to another shape that does not support Oracle RAC.

After you provision a VM DB system, you cannot change the shape. You have to provision another VM DB system using a full backup.

The shape of a VM DB system can be changed at any time, with no impact on the amount of storage available to the DB system.

It is possible to change the shape of a VM DB system with a higher number of OCPUs. However, reducing the number of OCPUs is not permitted.

If the current shape of the VM DB system supports Oracle Real Application Clusters (RAC), then you can only change that shape to another shape that also supports Oracle RAC.

Q32. While using virtual machines (VMs), the next step after selecting a shape for the DB system is to select storage options and configuration. Which TWO configurations can be selected and used? (Choose all correct answers)

mount block storage locally to the node.

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

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

Use Automatic Storage Management (ASM) for the storage management software.

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

Q34. How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database?

It depends on how many standby databases you want for your primary database in the Oracle Data Guard configuration in Oracle Cloud Infrastructure.

Three, first for the primary database, second for the standby database, and a third for the staging database in the Oracle Data Guard configuration.

Two for both the primary and standby database, because a DB system with the database that you want to use as the standby must already exist before you enable Oracle Data Guard.

One with the primary database, because a new DB system with the standby database is created and associated with the primary database when you enable Oracle Data Guard.

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

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

Q37. What can you use to enable an on-premises Enterprise Manager instance to monitor Exadata Cloud Service in a private OCI subnet?

virtual Cloud Network (VCN)

Client subnet

Virtual Network Interface Card (VNIC)

FastConnect

Q38. What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud Service?
(Choose all correct answers)

for high availability

for Fast Start Failover of storage cells

for Data Guard

for Real Application Clusters

for triple mirroring of data

Q39. Which THREE are prerequisites for using the MySQL Database Service? (Choose all correct answers)

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

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

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

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

You must create a compartment to store your resources.

Q40. Which are THREE strategies to migrate Oracle Database to Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)

GoldenGate

Zero Downtime Migration (ZDM)

Autonomous migration

Real Application Clusters (RAC)

migration workbench

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

Q42. Which tool can be used to monitor a storage server in Exadata Cloud Service?

OCI CLI

ocpucli

exacli

dbaascli

Q43. You enable automatic backups on your Exadata Cloud@Customer.?

database archivelog files

database control files