Summer Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dealsixty

1z0-931-23 Exam Dumps - Oracle Autonomous Database Questions and Answers

Question # 24

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

24 hrs

B.

2 hrs

C.

5 min

D.

1 day

Buy Now
Question # 25

As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.

Which connection service is appropriate for such a workload?

Options:

A.

MEDIUM

B.

HIGH

C.

TP

D.

TPURGENT

Buy Now
Question # 26

Autonomous Database's auto scaling feature allows your 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 meet high-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.

Buy Now
Question # 27

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)

Buy Now
Question # 28

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

Options:

A.

Data

B.

Schemas

C.

Tablespaces

D.

Reports

Buy Now
Question # 29

Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

Options:

A.

You must first manually create your database credentials using dms_cloud.create_credentia before accessing your Oracle Object Storage Bucket

B.

Data can be loaded from a remote database using Database Links (DBLinks)

C.

Data can be loaded from a local data source

D.

Data can be uploaded from several cloud storage sources including 53, Azure, Google Cloud and Oracle Object Storage

E.

Data formats supported include: text, csv, json, avro and parquet

Buy Now
Question # 30

When integrating object storage with autonomous database how effectively oracle uses the files in the

object storage?

Options:

A.

Scan partition tables

B.

scan hybrid partition tables

C.

prun column in parquet files

D.

prun columns in csv files

Buy Now
Question # 31

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

Options:

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 an Autonomous Database instance does not include its automatic backups.

C.

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

D.

Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

Buy Now
Question # 32

What are the two differentiators of Oracle Autonomous Data Base on Dedicated Infrastructure?

Options:

A.

Users can customize the OS stack and add additional packages

B.

Users have more control over the maintenance schedule

C.

Users have OS access to the database machine

D.

Users are offered greater reutral and isolation starting at the Exade Cloud infrastructure level

E.

Users have SYS privileges in the database

Buy Now
Question # 33

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

Options:

A.

Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure

B.

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator

C.

Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

D.

Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

Buy Now
Exam Code: 1z0-931-23
Exam Name: Oracle Autonomous Database Cloud 2023 Specialist
Last Update: May 8, 2025
Questions: 180
1z0-931-23 pdf

1z0-931-23 PDF

$34  $84.99
1z0-931-23 Engine

1z0-931-23 Testing Engine

$38  $94.99
1z0-931-23 PDF + Engine

1z0-931-23 PDF + Testing Engine

$54  $134.99