1z0-931-23 Exam Training Practice Tests (Oracle Autonomous Database Cloud 2023 Specialist)]

Question 1

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

A. It is enabled by default. B. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused. C. You can use the dbms_auto_index package to report on the automatic task and to set your preferences. D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints. E. The indexing feature is implemented as an automatic task that runs at a fixed interval.

Correct Answer: A

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

Question 2

Which three are use cases for Graph Studio? (Choose three.)

A. Facial recognition B. Clustering C. Churn analysis D. 3-D modelling E. Pattern matching

Correct Answer: B,D,E

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

Question 3

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

A. Logs B. Enterprise Manager Cloud Control C. Performance Hub D. OCI Metrics E. RMAN

Correct Answer: B,C,D

Question 4

You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements:
* Autonomous Transaction Processing
* Licence Tracluded
* Shared Infrastructure
Which parameter would you NOT use?

A. licence-model B. is-dedicaced C. db-type D. db-workload

Correct Answer: C

Question 5

Which index type is designed to index catalog information?

A. CONTEXT B. CTXRULE C. CTXCAT D. CONTAINS

Correct Answer: C

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

Question 6

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

A. Undo Management B. Memory Usage C. Index Storage D. Backup Retention E. Data Organization

Correct Answer: B,C

Question 7

Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)

A. Azure Blob Storage B. Oracle Cloud Infrastructure Object Storage C. Google Cloud Storage D. Oracle Cloud Infrastructure Object Storage Classic E. Amazon S3

Correct Answer: B,D

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

Question 8

Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

A. You do not need to have sufficient access permissions on the compartment that the resource is being moved to. B. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure. C. Moving an Autonomous Database instance does not include its automatic backups. D. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with them. Associated (non-dependent) resources remain in their current compartments.

Correct Answer: D

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

Question 9

Which native data type is used to store spatial information?

A. SDO_GEOMETRY B. SDO_LOCATION C. SDO_RELATE D. GEO_JSON

Correct Answer: A

Question 10

Which two protection modes are supported by Data Guard on Autonomous Database on Dedicated Infrastructure?

A. Maximum Continuity B. Maximum Availability C. Maximum Performance D. Maximum Protection

Correct Answer: B,C

Question 11

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

A. TPURGENT B. LOW C. HIGH D. MEDIUM E. TPPERFORMANT

Correct Answer: E

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

Question 12

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

A. ATP and ADW B. Autonomous Transaction Processing only C. Autonomous Data Warehouse only D. Hybrid Columnar compression

Correct Answer: A

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

Question 13

In which four ways can Oracle Database optimally access data in Object Storage?

A. optimized data archive using partitioned external tables B. scan avoidance using partitioned external tables C. scan avoidance using block skipping when reading parquet and ore files D. optimized data archive using hybrid partitioned tables E. scan avoidance using columnar pruning for .csv files F. scan avoidance using columnar pruning for columnar stores like parquet and orc

Correct Answer: A,B,D,F

Question 14

Which four file formats are supported when loading data from Cloud Storage?

A. DOC B. Parquet C. JSON D. Dcsv E. DDL F. AVRO

Correct Answer: B,C,D,F

Question 15

What are three methods to load data into the Autonomous Database?

A. Oracle Data Pump B. Oracle GoldenGate C. RMAN Restore D. Transportable Tablespace E. SQL*Loader

Correct Answer: A,B,E

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

Oracle Autonomous Database Cloud 2023 Specialist - 1z0-931-23 Exam Practice Test