[Jun 28, 2022] Free Database Cloud Service 1Z0-1093-21 Official Cert Guide PDF Download [Q32-Q53]

admin • June 28, 2022

[Jun 28, 2022] Free Database Cloud Service 1Z0-1093-21 Official Cert Guide PDF Download [Q32-Q53]

Rate this post

[Jun 28, 2022] Free Database Cloud Service 1Z0-1093-21 Official Cert Guide PDF Download

Oracle 1Z0-1093-21 Official Cert Guide PDF

NEW QUESTION 32
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.

NEW QUESTION 33
Which TWO statements are true about Interface for Exadata I/O Resource Management (IORM)? (Choose all correct answers)

IORM allows workloads and databases to share I/O resources automatically according to admin-defined policies.

IORM can be enabled across multiple databases using the Cloud interface of Exadata Cloud Service.

IORM allows workloads and databases to share I/O resources automatically according to user requests.

IORM can be enabled across multiple Exadata Racks using the Cloud interface of Exadata Cloud Service.

NEW QUESTION 34
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.

NEW QUESTION 35
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).

NEW QUESTION 36
Which THREE Oracle Cloud Infrastructure (OCI) services can be used to connect to on-premises networks?
(Choose all correct answers)

Internet Gateway

Fastconnect

Dynamic Routing Gateway (DRG)

Service Gateway

IPSec VPN

NEW QUESTION 37
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

NEW QUESTION 38
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

NEW QUESTION 39
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.

NEW QUESTION 40
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.

NEW QUESTION 41
What NoSQL Database Cloud Service API statement can be used to adjust table capacity?

tableRequest

tableunits

tableLimits

tableProvision

NEW QUESTION 42
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.

NEW QUESTION 43
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.

NEW QUESTION 44
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.

NEW QUESTION 45
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.

NEW QUESTION 46
Which characteristic is NOT a factor that impacts the capacity units for provisioning a NoSQL Database Cloud Service table?

record size

data model

query pattern

durability level

NEW QUESTION 47
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.

NEW QUESTION 48
Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

cellcli

OCI CLI

dbaascli

exacli

NEW QUESTION 49
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.

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

Let security admins manage vaults, keys, and secrets.

Let database and fleet admins manage Autonomous Databases.

Let database administrator’s manage DB systems.

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

NEW QUESTION 51
When configuring connectivity 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)

allows SQL*NET traffic from within the VCN

allows ONS and FAN traffic from within the VCN

allows SSH traffic from anywhere

allows Path MTU Discovery fragmentation messages

NEW QUESTION 52
You enable automatic backups on your Exadata Cloud@Customer.?

database archivelog files

database control files

Transparent Data Encryption (TDE) keystore (wallet)

server parameter file (SP file)

NEW QUESTION 53
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.

Loading …