Oracle Autonomous AI Database Professional (1Z0-931-26) Free Practice Test

Question 1

Which two methods can you use to create database users and grant roles in Autonomous Database services?

A. SQL*Plus

B. DBMS_CLOUDADMIN package

C. SQL Developer

D. Oracle Cloud Infrastructure (OCI) service console

Correct Answer: A,C

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

Question 2

Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure? (Choose two.)

A. Oracle Cloud Infrastructure Object Storage Classic

B. Azure Blob Storage

C. Amazon S3

D. Oracle Cloud Infrastructure Object Storage

E. Google Cloud Storage

Correct Answer: A,D

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

Question 3

What are two differentiators of Oracle Autonomous Database on Dedicated Infrastructure? (Choose two.)

A. Users have OS access to the database machine.

B. Users can customize the OS stack and add additional packages.

C. Users have SYS privileges in the database.

D. Users have more control over the maintenance schedule.

E. Users are offered greater control and isolation starting at the Exadata Cloud Infrastructure level.

Correct Answer: D,E

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

Question 4

Which statement is true when connecting an OCI Marketplace image to a shared Autonomous Database?

A. Compute Image and Shared ADB must be in the same VCN and Subnet

B. ADB must be configured with NSG

C. ADB must be configured with Private endpoints

D. Cannot connect OCI Marketplace image to shared ADB

Correct Answer: A

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

Question 5

Oracle Data Safe is a unified control center for your Oracle databases that helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. Which statement is FALSE?

A. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.

B. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

C. Oracle Data Safe only supports Autonomous Databases.

D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

Correct Answer: C

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

Question 6

Which is a feature of a graph query language?

A. Scripting language

B. Object-oriented language

C. Ability to specify patterns

D. Run key-value queries

Correct Answer: C

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

Question 7

Which native data type is used to store spatial information?

A. GEO_JSON

B. SDO_RELATE

C. SDO_GEOMETRY

D. SDO_LOCATION

Correct Answer: C

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

Question 8

When cloning from a backup, what is the earliest timestamp of the backup allowed in Autonomous Database?

A. 2 hours

B. 1 hour

C. 24 hours

D. 30 minutes

Correct Answer: A

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

Question 9

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, License Included, Shared Infrastructure. Which parameter would you NOT use?

A. db-type

B. db-workload

C. is-dedicated

D. license-model

Correct Answer: A

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

Question 10

Which statement is true about connecting a marketplace Oracle Cloud Infrastructure (OCI) image to an Autonomous Database on Shared Infrastructure?

A. A Private Endpoint is required to connect to the Autonomous Database on Shared Exadata infrastructure.

B. The Autonomous Database must belong to a Network Security Group (NSG).

C. The marketplace OCI image can be used with an Always Free Autonomous Database account.

D. The marketplace OCI image does not support connecting to an Autonomous Database on Shared Infrastructure.

Correct Answer: C

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

Question 11

What is the default time range in Performance Hub?

A. 15 Minutes

B. 24 Hours

C. 1 Hour

D. 1 Week

Correct Answer: B

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

Question 12

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

A. Catalog

B. Data Insight

C. JSON

D. Data Load

Correct Answer: A

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

Question 13

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

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

B. Moving the compartment of the Autonomous Database also moves the Autonomous Container Database and Autonomous Exadata Infrastructure.

C. You do not require sufficient access permissions on the compartment that the resource is being moved to.

D. Moving an Autonomous Database instance does not include its automatic backups.

Correct Answer: A

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

Question 14

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

A. Parallelism is not enabled by default.

B. You have direct access to the database node.

C. Oracle Database Result Cache is enabled by default for all SQL statements.

D. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

Correct Answer: C,D

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

Welcome to TestSimulate

Oracle Autonomous AI Database Professional (1Z0-931-26) Free Practice Test