Exit demo 1Z0-931-22 Oracle Autonomous Database Cloud 2022 Professional PDF format · free preview

Oracle 1Z0-931-22 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/1z0-931-22.html

Question 1
Multiple choice

Which two statements are true about accessing Autonomous Database Tools?

A.

Access to Database Actions is available for all users of Autonomous Database.

B.

Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

C.

SQL Developer Web is available exclusively on the Autonomous Database.

D.

Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpointnetworking.

E.

Oracle APEX can be accessed only from the Developer menu in the Service Console.

Question 2
Single choice

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

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.

Question 3
Single choice

The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

A.

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

B.

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

C.

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

D.

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

Question 4
Single choice

Which statement is FALSE about setting up compartment quotas?

A.

Quotas set on a parent compartment override quotas set on childcompartments.

B.

Compartment quotas cannot be set on the root compartment.

C.

Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

D.

You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.

Question 5
Single choice

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

A.

SQLDEV_ADMIN.GRANT_SCHEMA

B.

ORDS_ADMIN.ENABLE_SCHEMA

C.

ORDS_ADMIN.GRANT_SCHEMA

D.

ORDS_PRIV.ENABLE_SCHEMA

Question 6
Multiple choice

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

A.

DOC

B.

AVRO

C.

JSON

D.

DDL

E.

Dcsv

F.

Parquet

Question 7
Single choice

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

A.

A graph license key

B.

NoSQL configuration

C.

Graph created by a special tool downloaded from oracle.com

D.

Graph analytics algorithms

E.

Tables in an Autonomous Database instance

Question 8
Multiple choice

Which two options are available to restore an Oracle Autonomous Database?

A.

Select the backup from which restore needs to be done.

B.

Specify the point in time (timestamp) to restore.

C.

Select the snapshot of the backup.

D.

Use Recovery Manager (RMAN) to connect to Autonomous Database and back it up.

E.

Specify the archived custom image.

Question 9
Multiple choice

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

A.

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

B.

The source files can reside inOracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

C.

A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

D.

The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

E.

The target table will be created in Autonomous Database if it does not already exist.

Question 10
Single choice

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

A.

TPPERFORMANT

B.

MEDIUM

C.

HIGH

D.

LOW

E.

TPURGENT

Showing 10 of 112 questions · Unlock the full set