Quickly and Easily Pass Oracle Exam with 1z0-1093-22 real Dumps Updated on Nov-2022 [Q31-Q53] : Valid Premium Exam : http://premium.validexam.com

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

NO.32 Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

cellcli

OCI CLI

dbaascli

exacli

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

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

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

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

NO.37 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.38 Which tool can be used to monitor a storage server in Exadata Cloud Service?

OCI CLI

ocpucli

exacli

dbaascli

NO.39 What permissions do you need to perform actions on a NoSQL table?

NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

NO.40 In Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is the minimum egress requirement needed to enable Data Guard between Exadata Cloud Services?

Tcp traffic only for port 1521 and port 22

Tcp traffic only for port 1521

Tcp traffic only for port 22

Open for all protocols

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

NO.42 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.43 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.

NO.44 Which statement is FALSE about using compartments?

They allow you to isolate resources.

They can be used to secure resources.

They can be organized in a hierarchical fashion.

They are a physical concept that separates users.

NO.45 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.46 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.47 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.48 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.49 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.50 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.

NO.51 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.52 Which TWO statements are true when enabling autonomous Data Guard on Autonomous Exadat a. (Choose all correct answers)

Autonomous databases inherit their Data Guard configuration from their Autonomous Container Database.

Data Guard can be set per individual Autonomous Database within a Container Database.

Data Guard is not currently supported on Autonomous Exadata Cloud@Customer.

Autonomous Data Guard only supports Maximum Performance and Maximum Protection protection modes.

When in a Data Guard configuration patching will always take place on the standby database first.