Offering Free access to Oracle Autonomous Database 1z0-931-23 Exam Questions Pool Bank

Oracle Autonomous Database Cloud 2023 Specialist Questions and Answers

Testing Engine

Product Type: Testing Engine

$42 ~~$119.99~~

Add to Cart

PDF + Testing Engine

Product Type: PDF + Testing Engine

$59.5 ~~$169.99~~

Add to Cart

PDF Study Guide

Product Type: PDF Study Guide

$36.75 ~~$104.99~~

Add to Cart

Question 1

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

Options:

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.

Moving an Autonomous Database instance does not include its automatic backups.

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

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

Question 2

Which statement is true when the Autonomous Database has auto scaling enabled?

Options:

Database concurrency is scaled up when needed by the workload.

Increases the number of sessions available to the database.

Scales the PGA and SGA size when needed for the workload.

Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Question 3

On which two infrastructure classes can the Autonomous Database service be deployed?

Options:

Shared Exadata Infrastructure

Dedicated Exadata Infrastructure

Exadata Cloud Service

Oracle Cloud Infrastructure Virtual Machines

Question 4

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

Options:

the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

the Client Credentials wallet which is used to connect to the Autonomous Database

the 'High Availability Container Database' in which the Autonomous instance should run

the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

the Listener endpoint where the Autonomous Database should register on

Question 5

Which two statements are true about Oracle Cloud Infrastructure (OCI)?

Options:

An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region

A single fault domain can be associated with multiple regions and availability domains

Regions are dependent on other regions and must be located within five thousand kilometers of each other

Because availability domains do not share infrastructure, such as power or cooling, or the Internal availability domain network, a failure at one availability domain within a region is u likely to impact the availability of the there within the same region

Question 6

Which three scaling options are available in Oracle Autonomous Database on Shared Infrastructure?

Options:

Automatic online scaling of OCPU

Manual online scaling of OCPU

Manual offline scaling of Storage and OCPU

Manual online scaling of Storage

Automatic online scaling of Storage

Question 7

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

Options:

Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB

Connection button, then Download the Wallet.

Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then

Download the Wallet.

Click the Compute section of the menu, then choose Instance Configurations, then Download

Wallet.

Click on the Object Storage and find your Autonomous Bucket and Download the Wallet

Credentials.

Find the Service Console for your Autonomous Database, then pick Administration, then Download

the Client Credentials (Wallet).

Question 8

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

Options:

Data Pump Export File

Avro

Parquet

Text

JSON

Microsoft SQL Server (.mdf)

Question 9

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

Options:

An "INSERT" REST call

A "GET" REST call

A "POST" REST call

A "PUT" REST call

Question 10

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

How can they achieve this?

Options:

Change the Automatic Maintenance Schedule to "No Preference"

You cannot permanently disable scheduled automatic maintenance

Change the Automatic Maintenance Schedule to "None"

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

Question 11

What is the number of concurrent statements that can be handled by the medium database service name?

Options:

1-25 X OCPU

unlimited

20 X OCPU

Question 12

You have been tasked with analyzing a year's worth of sales data stored in an Autonomous Data Warehouse instance.

Which tool would you use to automate data exploration and create pivot tables?

Options:

Business Models

APEX

SQL Developer Web

Data Load

Question 13

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

Options:

The SQL statement completed its execution.

The SQL statement is executing.

The SQL statement is queued.

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

Question 14

Where do you find the URL for Database Actions?

Options:

in Oracle Cloud Infrastructure Object Storage

in the Database Users card under Database Actions

on the SQL Developer Client Connection tab

in the database with a SQL query

Question 15

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:

SQL Developer

JAVA JDK

You can't use Python with ADB.

The Oracle Client and the cx_Oracle interface for Python

Question 16

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?

Options:

Current settings for ACLs are cloned.

Clone can be in a different region.

All OML notebooks are cloned.

All underlying data for OML notebooks is cloned.

All resource management rules are cloned.

Question 17

Which method will NOT permit you to change the database Admin Password of a Autonomous Database on Shared Infrastructure?

Options:

Admin page of the Cloud Service Console

OCI CLI

OS command line from the database server.

SQLDeveloper

Question 18

Which statement is FALSE about setting up compartment quotas?

Options:

Quotas set on a parent compartment override quotas set on child compartments.

Compartment quotas cannot be set on the root compartment.

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

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

Question 19

Which three options are available to access data in an Autonomous JSON Database?

Options:

Oracle Cloud Infrastructure console using the JSON Online Developer tool

Oracle JSON Developer tool downloaded from OTN

NOSQL statements using Oracle SODA drivers

REST API calls to the database (not enabled by default)

Regular Oracle SQL statements using a connection through the listener

Question 20

For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Options:

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

Allow group ADB-Admins to manage autonomous-database in tenancy.

Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = 'OLTP'

Question 21

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

Options:

Files in Oracle Cloud Storage

Backup files in block storage

Local Files

Files in AWS S3 Storage

REST endpoints

Question 22

Which two methods can you use to create database users and grant roles in Autonomous Database services?

Options:

the Oracle Cloud Infrastructure A. service console

SQL Developer

the DBMS_CLOUD_ADMIN package

SQL *Plus

Question 23

You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX.

What statement describes the step to provide the developer a new workspace in APEX?

Options:

Create an IDCS user with the APEX role.

Access the APEX Administration Services and create the workspace for the developer.

Create a new developer account.

Create a database user with the APEX role.

Question 24

Which two of the following statements are correct?

Options:

ODI Web Edition is available only on Oracle Linux.

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

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

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

Question 25

Which four resources need to be provisioned by the fleet administrator and the database administrator before developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user?

Options:

Oracle Database licenses

Autonomous Container Database

Network Security Group(s)

Virtual Cloud Network and Subnet

Identity and Access Management (IAM) policy rules that allow access to the database

Autonomous Exadata Infrastructure

Autonomous Database instance

Question 26

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Options:

Autonomous Transaction Processing

Autonomous Data Warehouse

Neither service ignores hints by default

Both services ignore hints by default

Question 27

What is the correct way to list all files in the default data pump directory?

Options:

By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Log onto ADW server and issue is -al on the command line.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Question 28

Which two actions can be performed when an Autonomous Database is stopped?

Options:

Start

Update License Type

Update Network Access

Change Administrator Password

Question 29

Which statement is FALSE regarding database links?

Options:

You can call PL/SQL procedures and functions by using a database link

You can connect to an Autonomous Database from a remote database using a database link

You can create a database link from one Autonomous Database to another Autonomous Database instance

You can connect to a remote database from an Autonomous Database by using a database line

Question 30

When enabling auto-scaling, which three options do not change?

Options:

Number of OCPUs displayed in the console.

Amount of storage

I/O resources

parallelism settings

Level of concurrency

Question 31

A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment.

What should they do to remove this bottleneck?

Options:

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Remove any non-JSON data from the database.

Increase the number of OCPUs allocated to the database.

Ask Support to migrate their setup to a node without noisy neighbors.

Question 32

Which two objects are imported when using Data Pump to migrate your Oracle database to Autonomous Database?

Options:

Tablespaces

Reports

Schemas

Data

Question 33

Which two statements are true about Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for Autonomous Data Guard?

Options:

RPO is adjustable, but RTO I always 5 minutes

RTO and RPO are adjustable through the OCI console

RTO and RPO are 0 minutes for manual failovers

RTO is 2 minutes for an automatic failover

RPO is 0 minutes for an automatic failover

Question 34

Which statement is FALSE about Oracle Autonomous JSON Database?

Options:

JSON data is stored natively in the database

You can promote Autonomous JSON Database to Autonomous Transaction /Processing

It supports NoSQL-style, document-centric application

There is a 20 GB limit on JSON collection

Question 35

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:

Release Update (RU)

Prior Release Update Revision (PRUR)

Prior Release Update (PRU)

Quarterly Bundle Patch (QBP)

Question 36

Which three methods can be used to migrate on-premises databases to Oracle Autonomous Database (both Shared and Dedicated)?

Options:

RMAN backup & restore

Physical migration methods, such as database cloning

Orace Zero Downtime Migration (ZDM)

Original imp/exp tools

Oracle Data Pump

Oracle Golden Gate

Question 37

Which two statements are true about using an Oracle Autonomous Database with private endpoints?

Options:

Private endpoints can be configured when you clone an Autonomous Database on Shared Infrastructure that was initially created with public endpoints

An Autonomous Database with private endpoints can be accessed from the public Internet by adding your IP address to an Access Control List (ACL)

A Network Security Group (NSG) is required within your virtual cloud network before you can provision a Shared Autonomous Database to use private endpoints

You can configure private endpoints for an Always Free Autonomous Database

Question 38

Who, and in which order, provisions dedicated Exadata Infrastructure resources?

Options:

The database administrator provisions the Autonomous Container DB and the Autonomous DB Then, the feet administrator provisions the Autonomous Exadata Infrastructure

The fleet administrator provisions the Autonomous Exadata Infrastructure and then the Autonomous Container DB. Then, the database administrator provisions the Autonomous DB

The database administrator provisions the Autonomous Exadata Infrastructure. Then, the fleet administrator provisions the Autonomous Container DB and then the Autonomous DB

The fleet administrator provisions the Autonomous Exadata Infrastructure. Then, the database administrator provisions the Autonomous Container DB and then the Autonomous DB

Question 39

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

Options:

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

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

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

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

Question 40

Which of the following two statements regarding Data Transforms are correct?

Options:

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

All capabilities to transform data in ODI Classic are available with ODI Web Edition

Workflows for data transforms is only available on the ODI Web Edition

Data Transforms allows you to design data transformations in the form of data loads, data flows, and workflows

Question 41

You have 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:

900

1800

2700

1500

Question 42

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

Options:

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Select the snapshot of the backup.

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

Specify the archived custom image.

Question 43

What infrastructure does the Autonomous Database run on?

Options:

VM on Oracle Cloud Infrastructure

Bare-metal on Oracle Cloud Infrastructure

Exadata on Oracle Cloud Infrastructure

Any Oracle Engineered system

Question 44

Which three are Oracle-recommended best practices for Autonomous Database alarms?

Options:

Create a single alarm for each metric

Suppress alarms during investigations

Tune your alarms routinely

Select the correct alarm interval for your metric

Use a single interval for all alarms

Create multiple alarm metrics

Question 45

Which Database Actions tool is used to get information about the entities in your Oracle Autonomous Database and to also see how changing an object affects other objects?

Options:

Data Insights

JSON

Catalog

Data Load

Question 46

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

Options:

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Answer:

B, C, E

Explanation:

DELETE_FILE Procedure

This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.

CREATE_CREDENTIAL Procedure

This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.

PUTJDBJECT Procedure

This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).

VALIDATE EXTERNAL TABLE Procedure

This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

CREATE_EXTERNAL_TABLE Procedure

This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.

To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.

This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're

moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.

VALIDATE_EXTERNAL_TABLE Procedure

PUT_OBJECT Procedure

This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB)

DELETE FILE Procedure

This procedure removes the specified file from the specified directory on Autonomous Database.

CREATE_EXTERNAL_TABLE Procedure

This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.

Question 47

Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?

Options:

inside the Autonomous Database wallet

inside the backups of the container database

In a separate key vault external to the Exadata Infrastructure

on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

Question 48

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

Options:

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

Question 49

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

Options:

RMAN Cross-Platform backup and restore

Golden Gate on-premise installation

PDB unplug / plug operation

Datapump export / import

Dataguard Physical Standby

Golden Gate Cloud service

Question 50

Which statement is FALSE about Data Insights?

Options:

Data Insights displays information about patterns and anomalies in the data of entities in your Oracle Autonomous Database

The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard

Data insights are automatically generated by various analytic functions built into the database

Data Insights provides a wide range of graphical data presentation capabilities

Question 51

Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?

Options:

Autonomous Exadata infrastructure maintenance takes place at least once each quarter

Autonomous Exadata infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching

You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter

If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedules the container database maintenance for the following quarter

Load More 1z0-931-23 Questions

Winter Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Oracle 1z0-931-23 Oracle Autonomous Database Cloud 2023 Specialist Exam Practice Test

Oracle Autonomous Database Cloud 2023 Specialist Questions and Answers

Testing Engine

PDF + Testing Engine

PDF Study Guide

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options: