[Mar 07, 2023] 1z0-1093-22 Exam Dumps - Try Best 1z0-1093-22 Exam Questions - Real4dumps
Verified 1z0-1093-22 exam dumps Q&As with Correct 57 Questions and Answers
Oracle 1z0-1093-22 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION 26
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)
- A. After you provision a VM DB system, you cannot change the shape. You have to provision another VM DB system using a full backup.
- B. 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.
- C. 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.
- D. 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.
- E. 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.
Answer: D,E
NEW QUESTION 27
Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?
- A. OCI CLI
- B. dbaascli
- C. cellcli
- D. exacli
Answer: D
NEW QUESTION 28
What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell?
- A. Instantiate MySQL Shell on the MySQL database system instance.
- B. Add an ingress rule for port 20.
- C. Start MySQL Shell on the compute instance.
- D. Connect to the MySQL Database Service instance.
- E. SSH into the compute instance from your local machine.
Answer: A,D,E
NEW QUESTION 29
What NoSQL Database Cloud Service API statement can be used to adjust table capacity?
- A. tableLimits
- B. tableProvision
- C. tableunits
- D. tableRequest
Answer: D
NEW QUESTION 30
Which is NOT a prerequisite for patching Grid Infrastructure or database homes when using the console?
- A. All database compute nodes of the VM cluster are up and running.
- B. Oracle Clusterware is down on the VM cluster.
- C. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes.
- D. The required patch is available on the Control Plane server.
Answer: B
NEW QUESTION 31
Which statement is FALSE about using compartments?
- A. They can be organized in a hierarchical fashion.
- B. They allow you to isolate resources.
- C. They can be used to secure resources.
- D. They are a physical concept that separates users.
Answer: D
NEW QUESTION 32
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)
- A. alarms
- B. data points
- C. queries
- D. notifications
- E. metrics
Answer: A,D,E
NEW QUESTION 33
You want to scale within Exadata System. Which of the following two statements are true? (Choose all correct answers)
- A. Modifying the number of enabled OCPU cores requires database downtime.
- B. The setting of database parameter CPU_COUNT is not affected by modifying the number of enabled OCPU cores.
- C. The setting of database parameter CPU_COUNT is affected by modifying the number of enabled OCPU cores.
- D. Modifying the number of enabled OCPU cores does not require database downtime.
Answer: C,D
NEW QUESTION 34
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?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION 35
You used the "Stop" option from the Console of an Exadata Cloud Service virtual machine within a VM cluster. What impact does this have?
- A. All the databases and infrastructure associated with the Exadata Cloud Service are stopped.
- B. All the virtual machines in the VM cluster are stopped.
- C. The Stopped virtual machine is not available to any other database deployment.
- D. The Exadata Cloud Service is stopped.
Answer: C
NEW QUESTION 36
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)
- A. View ASH Analytics.
- B. scale OCPUs for an autonomous database.
- C. Kill a running SQL session.
- D. Configure auto indexing.
- E. Configure IO resource management (IORM).
Answer: A,C
NEW QUESTION 37
In a two-node Real Applications Cluster environment, the Internet and VCN Resolver are supported for DNS in the DB system. Which TWO tasks are required for the network setup? (Choose all correct answers)
- A. After the VCN is created, modify the DNS settings to use DNS Hostnames.
- B. Select "Use DNS Hostnames in this VCN" as the VCN is being created.
- C. Select the hostname field for a DNS label when the subnet is being created.
- D. when creating the database, specify a value in the Hostname Prefix.
Answer: B,D
NEW QUESTION 38
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)
- A. allows Path MTU Discovery fragmentation messages
- B. allows SQL*NET traffic from within the VCN
- C. allows ONS and FAN traffic from within the VCN
- D. allows SSH traffic from anywhere
Answer: A,D
NEW QUESTION 39
What can you use to enable an on-premises Enterprise Manager instance to monitor Exadata Cloud Service in a private OCI subnet?
- A. FastConnect
- B. Virtual Network Interface Card (VNIC)
- C. virtual Cloud Network (VCN)
- D. Client subnet
Answer: A
NEW QUESTION 40
You define a maintenance window for your MySQL DB systems. When the automatic maintenance process takes place, which TWO activities does the system perform while its status is set to UPDATING? (Choose all correct answers)
- A. It upgrades the associated compute instance to the latest Linux operating system version.
- B. It patches the MySQL server itself along with any underlying hardware.
- C. It patches the underlying operating system of the MySQL database.
- D. It analyzes, rebuilds, and optimizes MySQL database tables and indexes.
Answer: B,C
NEW QUESTION 41
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?
- A. Back up your database, run a precheck, then apply the patch on the database home where the database resides.
- B. Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home.
- C. Download the latest patch from MOS, back up your database, and use dbaasc1i to apply the patch on the database home.
- D. Own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively).
- E. Create a new database home, patch it to the version you want, and then move the database to the new home.
Answer: E
NEW QUESTION 42
Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database?
(Choose all correct answers)
- A. You can switch over the primary database to the standby role, perform maintenance on the standby database, and then switch it back to the primary role.
- B. You can use the reinstate command to return a failed database into standby role after correcting the cause of failure.
- C. You can write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys.
- D. You can terminate a primary database DB system.
- E. If the primary database becomes unavailable, then you can use Oracle Data Guard to fail over the standby database to the primary role.
Answer: A,B,E
NEW QUESTION 43
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)
- A. Exadata Cloud@Customer is hosted in a customer data center so the Exadata infrastructure is not registered in an OCI region.
- B. Consider which availability domain (within the region) to create the Exadata Cloud@Customer infrastructure in.
- C. Consider the physical proximity of the region you register the infrastructure in to your data center.
- D. Consider any business policies or regulations that preclude the use of a particular region.
- E. The Exadata Cloud@Customer region can be changed after the infrastructure is created.
Answer: A,D
NEW QUESTION 44
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?
- A. oci cli
- B. ocpucli
- C. asmali
- D. exacli
Answer: A
NEW QUESTION 45
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?
- A. Tcp traffic only for port 1521 and port 22
- B. Open for all protocols
- C. Tcp traffic only for port 22
- D. Tcp traffic only for port 1521
Answer: D
NEW QUESTION 46
What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud Service? (Choose all correct answers)
- A. for Real Application Clusters
- B. for Fast Start Failover of storage cells
- C. for Data Guard
- D. for high availability
- E. for triple mirroring of data
Answer: D,E
NEW QUESTION 47
How many DB systems must you provision before you can enable Oracle Data Guard for a virtual machine DB system database?
- A. 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.
- B. Three, first for the primary database, second for the standby database, and a third for the staging database in the Oracle Data Guard configuration.
- C. 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.
- D. It depends on how many standby databases you want for your primary database in the Oracle Data Guard configuration in Oracle Cloud Infrastructure.
Answer: A
NEW QUESTION 48
......
Oracle 1z0-1093-22 Test Engine PDF - All Free Dumps: https://prep4sure.real4dumps.com/1z0-1093-22-prep4sure-exam.html
