Question 1

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

Options :

A : through the Oracle Cloud Infrastructure service console

B : through SQL/Developer s

C : using DBMS_CLOUD_ADMIN package

D : through SQLPIus

Answer: B,D

Question 2

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

Options :

A : Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

B : Autonomous Data Warehouse workloads are optimized for mixed workloads.

C : Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

D : Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Answer: D

Question 3

Which method does NOT permit you to change the database ADMIN user's password of an Oracle Autonomous Database on Shared Infrastructure?

Options :

A : Admin page of the Cloud Service Console

B : OCI CLI

C : OS command line from the database server.

D : SQLDeveloper

Answer: C

Question 4

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

Options :

A :

Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

B : Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

C :

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator

D : Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

Answer: A

Question 5

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

Options :

A : Create a separate VCN that contains only public subnets

B : Only 1 of each is allowed to be allocated per environment.

C : Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

D : Create at least 2 of each resource.

Answer: D

Higher Test Marks with Free Online 1Z0-931-25 Exam Practice

Buying Options: