Latest [Jun 27, 2023] Oracle 1z0-1093-22 Exam Practice Test To Gain Brilliante Result [Q27-Q43]

QUESTION 27
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 28
Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

cellcli

OCI CLI

dbaascli

exacli

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

QUESTION 30
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 31
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

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

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

OCI CLI

ocpucli

exacli

dbaascli

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

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

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

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

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

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

QUESTION 42
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 43
Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)

Local storage

Object Storage

EFS Storage

Block Storage

File Storage

EBS Storage