Oracle Autonomous Database Cloud 2024 Professional (1Z0-931-24) Free Practice Test

Question 1

Which three data dictionary views contain information about analytic view objects?

A. ALL_ANALYTIC_VIEW_DIM_CLASS

B. ALL_ANALYTIC_VIEW_KEYS

C. ALL_ANALYTIC_VIEW_LVLGRPS

D. ALL_ANALYTIC VIEW_ID _ATTRS

E. ALL_ANALYTIC_VIEW_PATH

Correct Answer: A,B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

A. Network Security Group

B. Route Table

C. Subnet

D. Security List

E. VCN

Correct Answer: A,C,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Which task is NOT automatically performed by the Oracle Autonomous Database?

A. Mask your sensitive data.

B. Backing up the database.

C. Automatically optimize the workload.

D. Patching the database.

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

When exporting a notebook, what type of file is created?

A. JSON

B. SQL

C. XML

D. TXT

E. ASCII

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which statement is correct about the Service console in an Autonomous Database?

A. You can use Service console to manage runaway SQL statements on Autonomous DB

B. You can use Service console to create manual backups of Autonomous database

C. You can use Service console to move Autonomous DB between compartments

D. You can use Service console to enable or disable auto scaling of Autonomous DB

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

A. SQLDeveloper

B. OCI CLI

C. Admin page of the Cloud Service Console

D. OS command line from the database server.

Correct Answer: D

Question 7

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

A. Storage in TB cannot be larger than the number of OCPUs.

B. OCPUs and storage can be scaled independently.

C. OCPUs and storage must remain in sync.

D. Increasing OCPUs will automatically increase storage.

Correct Answer: B

Question 8

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

A. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

B. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

C. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

D. It is enabled by default.

E. The indexing feature is implemented as an automatic task that runs at a fixed interval.

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

A. through SQLPIus

B. through SQL/Developer s

C. through the Oracle Cloud Infrastructure service console

D. using DBMS_CLOUD_ADMIN package

Correct Answer: A,B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

A. Quarterly Bundle Patch (QBP)

B. Prior Release Update Revision (PRUR)

C. Release Update (RU)

D. Prior Release Update (PRU)

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 11

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?

A. 1500

B. 900

C. 2700

D. 1800

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 12

You need to create a new database via the Oracle Cloud Infrastructure (OCI) CLI with the following requirements:
* Autonomous Transaction Processing
* License Included
* Shared Infrastructure
Which parameter would you NOT use?

A. db-type

B. db-workload

C. is-dedicated

D. license-model

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 13

When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

A. prun column in parquet files

B. prun columns in csv files

C. scan hybrid partition tables

D. Scan partition tables

Correct Answer: D

Question 14

Which four resources need to be provisioned by the fleet administrator and the database administrator before developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user?

A. Autonomous Exadata Infrastructure

B. Oracle Database licenses

C. Virtual Cloud Network and Subnet

D. Network Security Group(s)

E. Autonomous Database instance

F. Identity and Access Management (IAM) policy rules that allow access to the database

G. Autonomous Container Database

Correct Answer: A,C,D,G

Welcome to TestSimulate

Oracle Autonomous Database Cloud 2024 Professional (1Z0-931-24) Free Practice Test