Oracle Autonomous Database Cloud 2025 Professional (1Z0-931-25) Free Practice Test

Question 1

Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?

A. Access Control List

B. IPSec List

C. Security List

D. IP Vault

Correct Answer: A

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

Question 2

Which three of the following data sources are available when using the Data Load page on Database Actions?

A. REST endpoints

B. Files in Oracle Cloud Storage

C. Files in AWS S3 Storage

D. Backup files in block storage

E. Local Files

Correct Answer: B,C,E

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

Question 3

Which three functions are provided by Spatial Studio? (Choose three.)

A. Map visualization

B. Spatial data editing

C. Custom SQL queries

D. Geocoding

E. Spatial analysis

Correct Answer: A,B,E

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

Question 4

Which are the two restrictions for an Always Free Autonomous Database? (Choose two.)

A. Oracle Application Express (APEX) not included

B. Maximum of two Always Free Databases per OCI tenancy

C. Supports only ATP as a workload type

D. Maximum of one OCPU per Database

Correct Answer: B,D

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

Question 5

Which four levels of access can be defined in policies? (Choose four.)

A. Read

B. Use

C. Create

D. Inspect

E. Manage

Correct Answer: A,B,D,E

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

Question 6

Which option should you use to create a graph with Graph Studio?

A. Tables in an Autonomous Database instance

B. Graph analytics algorithms

C. Graph created by a special tool downloaded from oracle.com

D. A graph license key

E. NoSQL configuration

Correct Answer: A

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

Question 7

Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure? (Choose two.)

A. Switchover

B. Change Protection Mode

C. View Apply Lag

D. Failover

E. Reinstate

Correct Answer: A,D

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

Question 8

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

B. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.

C. A single fault domain can be associated with multiple regions and availability domains.

D. Regions are dependent on other regions and must be located within 5 thousand kilometers of each other.

Correct Answer: A,B

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

Question 9

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should they do to remove this bottleneck?

A. Ask Support to migrate their setup to a node without noisy neighbors.

B. Remove any non-JSON data from the database.

C. Increase the number of OCPUs allocated to the database.

D. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Correct Answer: C

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

Question 10

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

A. Performance Hub

B. Logs

C. OCI Metrics

D. RMAN

E. Enterprise Manager Cloud Control

Correct Answer: A,C,E

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

Question 11

What is the correct way to list all files in the default data pump directory?

A. Log onto ADW server and issue ls -al on the command line

B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW)

C. By executing SELECT * FROM UTL_FILE.LIST('DATA_PUMP_DIR');

D. By executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

Correct Answer: D

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

Question 12

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?

A. Using the DBCA on the database server

B. Connecting to the cloud infrastructure console using the SSH wallet

C. It cannot be done

D. Using the cloud infrastructure command line interface or REST API calls

Correct Answer: D

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

Welcome to TestSimulate

Oracle Autonomous Database Cloud 2025 Professional (1Z0-931-25) Free Practice Test