Oracle Autonomous Database Cloud 2023 Specialist - 1z0-931-23 Exam Questions [2026]

QUESTION NO: 1
Which four file formats are supported when loading data from Cloud Storage?

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

Correct Answer: A,B,C,E

QUESTION NO: 2
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

A. In a separate key vault external to the Exadata Infrastructure B. inside the Autonomous Database wallet C. inside the backups of the container database D. on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

Correct Answer: A

QUESTION NO: 3
Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

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

Correct Answer: C

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

QUESTION NO: 4
Which three tasks are performed from the service console of an Autonomous Database on Shared Infrastructure?

A. Set resource management rules B. Enable autoscaling C. Download the wallet D. Manage Oracle Machine Learning users E. Rotate the wallet

Correct Answer: B,C,E

QUESTION NO: 5
Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

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

Correct Answer: B,E

QUESTION NO: 6
Which statement is NOT correct when setting up compartment quotas?

A. There are three types of quota policy statements which are set, unset and zero. B. Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending. C. Compartment quotas use policies that allow allocation of resources with a high level of flexibility. D. Compartment quotas are set by Oracle.

Correct Answer: D

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

QUESTION NO: 7
Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database?

A. Scaling can happen while there are active transactions in the database B. Active transactions are terminated and rolled back C. Active transactions continue running unaffected D. Active transactions are paused E. Active transactions in Autonomous Data Warehouse are paused

Correct Answer: D,E

QUESTION NO: 8
Which predefined role that exists in Autonomous Database includes common privileges that are used by a Data Warehouse developer?

A. ADWC B. ADBDEV C. ADMIN D. DWROLE

Correct Answer: D

QUESTION NO: 9
When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

A. DBNAME_HIGH B. DBNAME_MEDIUM C. DBNAME_CONCURRENT D. DBNAME_LOW

Correct Answer: D

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

QUESTION NO: 10
What are the two supported infrastructure options for deploying an Autonomous Database?

A. Any Oracle Engineered System B. Bare-metal on Oracle Cloud Infrastructure C. Dedicated Exadata Infrastructure D. VM on Oracle Cloud Infrastructure E. Shared Exadata Infrastructure

Correct Answer: C,E

QUESTION NO: 11
Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

A. You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket B. Data can be loaded from a local data source C. Data can be loaded from a remote database using Database Links (DBLinks) D. Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage E. Data formats supported include: text, csv, json, avro and parquet

Correct Answer: A