Oracle Cloud Database Services 2021 Specialist (1Z0-1093-21) Free Practice Test

Question 1

You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase to solve this?

A. storage capacity

B. OCPU for all servers in the cluster

C. storage capacity

D. index size

Correct Answer: B

Question 2

What THREE steps must you perform to connect to a MySQL database in the database system by using SSH and MySQL Shell?

A. Connect to the MySQL Database Service instance.

B. Add an ingress rule for port 20.

C. Start MySQL Shell on the compute instance.

D. SSH into the compute instance from your local machine.

E. Instantiate MySQL Shell on the MySQL database system instance.

Correct Answer: A,D,E

Question 3

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

A. tableRequest

B. tableLimits

C. tableunits

D. tableProvision

Correct Answer: A

Question 4

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

B. 5

C. 32

D. 12

Correct Answer: D

Question 5

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. Kill a running SQL session.

B. Configure IO resource management (IORM).

C. Configure auto indexing.

D. scale OCPUs for an autonomous database.

E. View ASH Analytics.

Correct Answer: A,E

Question 6

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

A. NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

B. NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

C. NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

D. NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

Correct Answer: B

Welcome to TestSimulate

Oracle Cloud Database Services 2021 Specialist (1Z0-1093-21) Free Practice Test