New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-931-22 Dumps Questions Answers

Page: 1 / 4
Total 112 questions

Oracle Autonomous Database Cloud 2022 Professional Questions and Answers

Question 1

When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

Options:

A.

Under Core Infrastructure then Compute then Autonomous Exadata

B.

Under Solutionsand Platform then Platform Services then Autonomous Exadata

C.

Under Database then Autonomous Transaction Processing then Autonomous Exadata

D.

Under Core Infrastructure then Autonomous Exadata

Buy Now
Question 2

What REST verb is used to create an Autonomous Database service using REST APIs?

Options:

A.

An "INSERT" REST call

B.

A "GET" REST call

C.

A "POST" REST call

D.

A "PUT" REST call

Question 3

Youhave an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.

The load on the database increases from three OCPUs to nine OCPUs.

What is the total number of concurrent statements that the TPURGENT service can support?

Options:

A.

900

B.

1800

C.

2700

D.

1500

Question 4

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

Question 5

Which statement isFALSE for Oracle Data Safe? (Choose the best answer.)

Options:

A.

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

B.

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

C.

Oracle Data Safe only supports Autonomous Databases

D.

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

Question 6

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

Options:

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 7

Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?

Options:

A.

Data Pump Export File

B.

Avro

C.

Parquet

D.

Text

E.

JSON

F.

Microsoft SQL Server (.mdf)

Question 8

Autonomous Database's auto scaling feature allowsyour database to use up to three times the current base number of CPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use.

Which statement is FALSE regarding the auto scaling feature?

Options:

A.

For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren't being used by other auto scaling databases to meethigh-load demands.

B.

The base number of OCPU cores allocated to a database is not guaranteed.

C.

For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.

D.

Auto scaling is enabled by default and can be enabled or disabled at any time.

Question 9

Which two actions are available to perform when an Autonomous Database is stopped?

Options:

A.

Start

B.

Update Network Access

C.

Change administrator password

D.

UpdateLicense Type

Question 10

Which two cloud services are supported to import data pump files from using Dedicated Exadata

Infrastructure? (Choose two.)

Options:

A.

Oracle Cloud Infrastructure Object Storage

B.

Google Cloud Storage

C.

Amazon S3

D.

Azure Blob Storage

E.

Oracle Cloud Infrastructure Object Storage Classic

Question 11

Which statement is FALSE about Oracle Autonomous JSON Database?

Options:

A.

JSON data is stored natively in the database

B.

You can promote Autonomous JSON Database to Autonomous Transaction /Processing

C.

It supports NoSQL-style, document-centric application

D.

There is a 20 GB limit on JSON collection

Question 12

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

Options:

A.

The SQL statement completed its execution.

B.

The SQL statement is executing.

C.

TheSQL statement is queued.

D.

The SQL statement did not complete either due to an error.

Question 13

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

Options:

A.

IOPS, Storage Space Used By Tablespace, Applyand Transport Lag

B.

CPU Utilization, Storage Utilization

C.

Query Latency, User Calls, Execute Count

D.

Transaction Count, Sessions, Running Statements

Question 14

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).

How can they achieve this?

Options:

A.

Change the Automatic Maintenance Schedule to'None’d.

B.

Change the Automatic Maintenance Schedule to 'Specify a Schedule' but do not select any month, week or day.

C.

You cannot permanently disable scheduled Automatic Maintenance.

D.

Change the Automatic Maintenance Schedule to 'No Preference'.

Question 15

Which cloud service is NOT supported to import data pump files from using Dedicated Exadata Infrastructure?

Options:

A.

Oracle Cloud Infrastructure Object Storage

B.

Google Cloud Storage

C.

Amazon S3

D.

Oracle Cloud Infrastructure Object Storage Classic

Question 16

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

Options:

A.

A Network Security Group is required within your Virtual Cloud Network before you can provision a

Shared Autonomous Database to use Private Endpoints

B.

An Autonomous Database with privateendpoints can be accessed from the public internet by

adding your ip address to an Access Control List.

C.

Private Endpoints can be configured when you clone a Shared Autonomous Database that was

initially created with public endpoints.

D.

You can configure Private Endpoints for an Always Free Autonomous Database

Page: 1 / 4
Total 112 questions