Summer Sale- Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Activedumpsnet Logo
  1. Home
  2. Oracle
  3. Oracle Autonomous Database
  4. 1z0-931-22 - Oracle Autonomous Database Cloud 2022 Professional

Oracle 1z0-931-22 Oracle Autonomous Database Cloud 2022 Professional Exam Practice Test

Note! Following 1z0-931-22 Exam is Retired now. Please select the alternative replacement for your Exam Certification. The new exam code is 1z0-931-23
Page: 1 / 11
Total 112 questions
Get 1z0-931-22 Full Access Download 1z0-931-22 PDF

Oracle Autonomous Database Cloud 2022 Professional Questions and Answers

Question 1

Which two of the followingstatements are correct?

Options:

A.

ODI Web Edition is available only on Oracle Linux.

B.

ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

C.

The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.

D.

All of the capabilities of ODI Classic are available with ODI Web Edition,

Question 2

A new Python developer has joined your team and needs to access the Autonomous Database(ADB) data.

How does the developer connect to and interact with ADB from Python?

Options:

A.

SQL Developer

B.

JAVA JDK

C.

You can't use Python with ADB.

D.

The Oracle Client and the cx_Oracle interface for Python

Question 3

Which two methods canyou use to create database users and grant roles in Autonomous Database services? O the Oracle Cloud Infrastructure A. service console

B. SQL Developer

C. the DBMS_CLOUD_ADMIN package

D. SQL *Plus

Options:

Question 4

Which three event types are supported for Autonomous Database?

Options:

A.

Terminate End

B.

Maintenance Begin

C.

Change Compartment Begin

D.

Change Autoscaling Configuration Compartment

E.

Update IORM Begin

Question 5

Which statement is correct about the Service consolein an Autonomous Database?

Options:

A.

You can use Service console to enable or disable auto scaling of Autonomous DB

B.

You can use Service console to manage runaway SQL statements on Autonomous DB

C.

You can use Service console to move Autonomous DB betweencompartments

D.

You can use Service console to create manual backups of Autonomous database

Question 6

While creating a business model what advanced options you can enable or disable? (Choose three)

Options:

A.

Business Object Security Feature

B.

Analytic View Transparency View

C.

Autonomous Aggregate Cache

D.

Display private tables

E.

Analytic View Base Table Query Transformation

Question 7

A BusinessAnalyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.

When restoring/cloning the ADB, you must select a backup which is atleast___

hours/minutes old.

Options:

A.

24hrs

B.

2 hrs

C.

5 min

D.

1 day

Question 8

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure(OCI) console, which patch type is offered to be applied during maintenance?

Options:

A.

Release Update (RU)

B.

Prior Release Update Revision (PRUR)

C.

Prior Release Update (PRU)

D.

Quarterly Bundle Patch (QBP)

Question 9

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

Options:

A.

Network Security Group

B.

Security List

C.

VCN

D.

Route Table

E.

Subnet

Question 10

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

Options:

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 11

What is the default port number for accessing a newly created Autonomous Database?

Options:

A.

1524

B.

1522

C.

1521

D.

1523

E.

1526

Question 12

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

Options:

A.

The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

B.

The OCI compute instance does not support connecting to a Shared Autonomous Database.

C.

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

D.

The OCI compute instance can be used with an Always-Free Autonomous Database account.

E.

A Private Endpoint is required to connect to the Shared-Autonomous Database.

Question 13

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

Options:

A.

Files in Oracle Cloud Storage

B.

Backup files in block storage

C.

Local Files

D.

Files in AWS S3 Storage

E.

REST endpoints

Question 14

Which statement is FALSE about setting up compartment quotas?

Options:

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 15

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

Options:

A.

60 days

B.

7 days

C.

15 days

D.

120 days

Question 16

Oracle Data Safe is a unified control center for your Oracle databases which 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?

Options:

A.

Oracle Data Safe only supports Autonomous Databases.

B.

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

C.

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

D.

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

Load More 1z0-931-22 Questions 
Page: 1 / 11
Total 112 questions
Get 1z0-931-22 Full Access Download 1z0-931-22 PDF