Oracle 1Z0-1093-21 Cert Guide PDF 100% Cover Real Exam Questions [Q15-Q34]

29Apr 2022 by admin No Comments

Rate this post

Oracle 1Z0-1093-21 Cert Guide PDF 100% Cover Real Exam Questions

Pass 1Z0-1093-21 Exam – Real Questions and Answers

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

OCI CLI

ocpucli

exacli

dbaascli

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

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

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

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

NO.20 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.21 Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

cellcli

OCI CLI

dbaascli

exacli

NO.22 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.23 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

NO.24 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.25 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.26 What NoSQL Database Cloud Service API statement can be used to adjust table capacity?

tableRequest

tableunits

tableLimits

tableProvision

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

NO.28 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).

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

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

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

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

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

100% Free 1Z0-1093-21 Daily Practice Exam With 56 Questions: https://www.practicematerial.com/1Z0-1093-21-exam-materials.html

Leave a Reply Cancel reply