1Z0-1093-21 Practice Test Questions Answers Updated 56 Questions [Q19-Q36]

30 Oct, 2022 By admin 1Z0-1093-21, Oracle 0 Comments

1Z0-1093-21 Practice Test Questions Answers Updated 56 Questions [Q19-Q36]

Rate this post

1Z0-1093-21 Practice Test Questions Answers Updated 56 Questions

1Z0-1093-21 dumps & Database Cloud Service Sure Practice with 56 Questions

QUESTION 19
Your MySQL Database Service system is automatically backed up between midnight and 1 AM. What must you do to change the starting time to 4 AM?

Use the mysqlbackup command to establish a 4 AM backup start time.

Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.

Update the Oracle Cloud Infrastructure (OCI) MySQL DB System Details page to specify the 4 AM backup window start time.

From the Edit MySQL DB System Details page, select Backup Window and set the start time to 4 AM.

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

tableRequest

tableunits

tableLimits

tableProvision

QUESTION 21
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

QUESTION 22
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

QUESTION 23
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.

QUESTION 24
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.

QUESTION 25
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

QUESTION 26
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

QUESTION 27
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.

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

QUESTION 29
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.

QUESTION 30
Which tool can be used to monitor a storage server in Exadata Cloud Service?

OCI CLI

ocpucli

exacli

dbaascli

QUESTION 31
Which system configuration is offered by the Oracle Database Exadata Cloud Service?

Each system configuration starts with a fixed amount of memory and storage resources.

Each system configuration starts with a fixed amount of OCPU and storage resources.

Each system configuration starts with a fixed amount of OCPU, memory, storage, and network resources.

Each system configuration starts with a fixed amount of OCPU, memory, and network resources.

QUESTION 32
How many IP addresses do you need at a minimum for the client subnet when you plan to have four Exadata compute nodes on Exadata Cloud Service?

Explanation
((3 address * 2 nodes) +3 for SCANs +3 reserved in subnet )

QUESTION 33
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

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

QUESTION 35
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

QUESTION 36
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

Loading …