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

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

Page: 1 / 11
Total 149 questions

Oracle Autonomous Database Cloud 2025 Professional Questions and Answers

Question 1

Which two are correct actions to take in order to download the Autonomous Database Credentials? (Choose two.)

Options:

A.

Click the compute section of the menu, then choose instance configurations, then download wallet

B.

Find the service console for your Autonomous Database, then pick administration, then download the credential wallet

C.

Click on the Object Storage and find your Autonomous bucket and download the wallet credentials

D.

Click on the Autonomous Database in the menu, click a database name, then choose DB Connection button, then download the wallet

Buy Now
Question 2

Which stage of the indexing pipeline divides text into tokens?

Options:

A.

Sectioner

B.

Tokenizer

C.

Filter

D.

Lexer

Question 3

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

Options:

A.

NoSQL statements using Simple Oracle Document Access (SODA) drivers

B.

Regular Oracle SQL statements using a connection through the listener

C.

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

D.

Oracle Cloud Infrastructure console using the JSON Online Developer tool

E.

Oracle JSON Developer tool downloaded from Oracle Technology Network (OTN)

Question 4

Which statement is correct about the Service Console in an Autonomous Database?

Options:

A.

You can use the Service Console to enable or disable auto-scaling of an Autonomous Database.

B.

You can use the Service Console to manage runaway SQL statements on an Autonomous Database.

C.

You can use the Service Console to create manual backups of an Autonomous Database.

D.

You can use the Service Console to move an Autonomous Database between compartments.

Question 5

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do?

Options:

A.

Create a rule for the Oracle Cloud Infrastructure Event for 'Autonomous Database STOP END'

B.

Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

C.

Add a 'BEFORE SHUTDOWN ON DATABASE' trigger within the database

D.

Create a notification alert using DBMS_SNMP package

Question 6

What happens with the standby database when disabling Autonomous Data Guard?

Options:

A.

The standby database is terminated.

B.

The standby database is started read-write

C.

The standby database is started read-only

D.

The standby database is transformed into a refreshable clone

Question 7

A corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add any more admin responsibility to the team and is looking for a database option that’s low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

Options:

A.

ATP using 'tpurgent' and 'high' TNS services to separate connection types

B.

Since the application needs to be highly available, it should be deployed on a Kubernetes Cluster

C.

It is best to build a separate data warehouse, and move the OLTP data on a nightly basis

D.

ADW since operational reporting is a higher priority in this scenario

Question 8

Which two statements are true regarding active transactions when scaling OCPUs in an Autonomous Database? (Choose two.)

Options:

A.

Active transactions are terminated and rolled back

B.

Scaling can happen while there are active transactions in the database

C.

Active transactions continue running unaffected

D.

Active transactions are paused

Question 9

Which is a feature of a graph query language?

Options:

A.

Run key-value queries

B.

Scripting language

C.

Object-oriented language

D.

Ability to specify patterns

Question 10

What is a best practice when planning and instituting access controls for your Autonomous Dedicated environment regarding subnets, compartments, and user groups?

Options:

A.

Only 1 subnet and 1 compartment are allowed, multiple groups highly advised.

B.

Only 1 of each is allowed to be allocated per environment.

C.

Create a separate VCN that contains only public subnets.

D.

Create at least 2 of each resource.

Question 11

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

Options:

A.

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

B.

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

C.

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.

D.

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

Question 12

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

Options:

A.

Exadata

B.

Active Data Guard

C.

Real Application Clusters (RAC), but only when scaling beyond 16 OCPUs

D.

Multitenant

E.

Transparent Data Encryption (TDE)

Question 13

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?

Options:

A.

Using the DBCA on the database server

B.

Connecting to the cloud infrastructure console using the SSH wallet

C.

It cannot be done

D.

Using the cloud infrastructure command line interface or REST API calls

Question 14

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

Options:

A.

Local Files

B.

Files in Oracle Cloud Storage

C.

REST endpoints

D.

Files in AWS S3 Storage

E.

Backup files in block storage

Question 15

Which workload is particularly suited to Oracle Autonomous JSON Database?

Options:

A.

Data Marts

B.

Transactions

C.

Data Lakes

D.

Schema-less, document-centric

Question 16

Your customer has upgraded their on-premises 11.2 Database to 12.2. During this migration, the database was migrated to a pluggable database (PDB) and is now in production. How should the customer unplug their database to migrate to an Autonomous Database?

Options:

A.

Unplug into an XML file so that the database and XML files can be uploaded to Object Storage.

B.

PDBs cannot be migrated to an Autonomous Database using plug, unplug, or clone.

C.

Create a database link from the source database to the Autonomous Database environment and clone the PDB.

D.

Unplug into a PDB archive, which can be uploaded to Object Storage.

Question 17

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

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata Infrastructure for Autonomous Database Dedicated?

Options:

A.

Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour

B.

Month of the Quarter, Week of the Month, Day of the Week, Start Hour

C.

Month of the Year, Week of the Month, Day of the Week, Start Hour

D.

Week of the Quarter, Day of the Week, Start Hour

Question 19

Your company has a .NET application and wants to deploy it on Autonomous Database (ADB). What software is used to connect to ADB from the .NET application?

Options:

A.

SQL*Plus

B.

You cannot use .NET with ADB

C.

Java

D.

Oracle Data Access Components for Windows

Question 20

Which two statements are true about accessing the Autonomous Database Tools?

Options:

A.

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

B.

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

C.

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

D.

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

Question 21

Which index type is designed to index catalog information?

Options:

A.

CONTEXT

B.

CTXCAT

C.

CTXRULE

D.

CONSTRAINS

Question 22

Which terminology is used to refer to a communication channel for sending messages to a subscription, such as email or SMS, in Oracle Cloud Infrastructure?

Options:

A.

Subject

B.

Notification

C.

Topic

D.

Event

Question 23

What are three characteristics of Data Lake data captured in Object Storage? (Choose three.)

Options:

A.

High concurrency

B.

High transaction performance

C.

Schema on read

D.

Multiple subject areas

E.

Mixed data types

Question 24

Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low. Which statement is true?

Options:

A.

Low provides highest concurrency and lowest resources, and DoP is 1.

B.

High provides highest concurrency and lowest resources, and DoP is 1.

C.

Medium provides intermediate resource and concurrency, and queries run serially.

D.

High provides highest resource and lowest concurrency, and Degree of Parallelism (DoP) is 1.

Question 25

Which two statements are true about Data Insights?

Options:

A.

You can search for Data Insights against a base table or business model.

B.

Data Insights is available with on-premises deployments of Oracle Database.

C.

You can retrieve previously executed Data Insights searches.

D.

Data Insights is an additional priced option.

Question 26

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

Options:

A.

A "POST" REST call

B.

A "GET" REST call

C.

A "PUT" REST call

D.

An "INSERT" REST call

Question 27

Which three functions are provided by Spatial Studio? (Choose three.)

Options:

A.

Map visualization

B.

Custom SQL queries

C.

Spatial analysis

D.

Geocoding

E.

Spatial data editing

Question 28

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

Options:

A.

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

B.

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

C.

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

D.

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 unlikely to impact the availability of the others within the same region.

Question 29

Which management operation is correct about Autonomous Databases on Shared Exadata Infrastructure?

Options:

A.

You can skip a scheduled maintenance run. For Autonomous Database on Shared Exadata Infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed

B.

You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node on the Autonomous Database is restarted separately while the remaining nodes continue to be available

C.

You cannot configure the scheduling for your Autonomous Databases on Shared Exadata Infrastructure

D.

You can choose to use Release Update or Release Update Revision updates for your Autonomous Databases on Shared Infrastructure

Question 30

Which two actions can be performed when an Autonomous Database is stopped? (Choose two.)

Options:

A.

Change administrator password

B.

Start

C.

Update License type

D.

Update Network Access

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:

A.

Remove any non-JSON data from the database.

B.

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

C.

Increase the number of OCPUs allocated to the database.

D.

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Question 32

Which three methods can be used to migrate your existing Oracle database to Autonomous Database? (Choose three.)

Options:

A.

Using SFTP to copy CSV files into an Autonomous Database

B.

Using Oracle Zero Downtime Migration (ZDM)

C.

Using GoldenGate

D.

Using Data Pump

E.

Using Recovery Manager (RMAN)

Question 33

Which three are Oracle-recommended best practices for Autonomous Database alarms? (Choose three.)

Options:

A.

Suppress alarms during investigations

B.

Create multiple alarm metrics

C.

Select the correct alarm interval for your metric.

D.

Routinely tune your alarms

Question 34

Which predefined service connection should you use when running lots of high concurrent queries in an Autonomous Database?

Options:

A.

DBNAME_LOW

B.

DBNAME_MEDIUM

C.

DBNAME_HIGH

D.

DBNAME_CONCURRENT

Question 35

Which can be used to ensure that your Autonomous Database is accessible only from a given set of IPs?

Options:

A.

Security List

B.

IP Vault

C.

Access Control List

D.

IPSec List

Question 36

An Autonomous Database user with an instance wallet has left the company. The user had shared a database user ID with other users when accessing the Autonomous Database. Other than changing the shared user password, what can an administrator do to protect the instance?

Options:

A.

Trust the user who left not to access the database

B.

Delete the user

C.

Rotate the instance wallet and share the new wallet with the remaining users

D.

Shutdown and restart the instance

Question 37

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 Database then Autonomous Transaction Processing then Autonomous Exadata

C.

Under Solutions and Platforms then Platform Services then Autonomous Exadata

D.

Under Core Infrastructure then Autonomous Exadata

Question 38

What is the difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases?

Options:

A.

Only ATP manages optimizer statistics.

B.

Only ADW supports autoscaling

C.

Only ADW uses columnar compression by default.

D.

Only ATP supports automatic backups.

Question 39

Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure? (Choose two.)

Options:

A.

Amazon S3

B.

Azure Blob Storage

C.

Oracle Cloud Infrastructure Object Storage Classic

D.

Google Cloud Storage

E.

Oracle Cloud Infrastructure Object Storage

Question 40

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:

A.

APEX

B.

SQL Developer Web

C.

Business Models

D.

Data Load

Question 41

DBSRV1 is an Autonomous Database with the display name PRODDB. You plan to take manual backups of this database periodically. What must be the name of the bucket that will be used to store manual backups?

Options:

A.

backup_proddb

B.

BACKUP_PRODDB

C.

backup_dbsrv1

D.

BACKUP_DBSRV1

Question 42

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

Options:

A.

RTO and RPO are adjustable through the OCI console

B.

RPO is adjustable, but RTO is always 5 minutes

C.

RPO is 0 minutes for an automatic failover

D.

RTO and RPO are 0 minutes for manual failovers

E.

RTO is 2 minutes for an automatic failover

Question 43

Which is an Autonomous Database critical event?

Options:

A.

Maintenance Begin

B.

Database Connection

C.

Schedule Maintenance Warning

D.

Admin Password Warning

E.

New Maintenance Schedule

Question 44

Which subset of services is offered via OCI-CLI (Command Line Interface) for Autonomous Database (ADB) via calls made to the OCI APIs?

Options:

A.

Start, Delete, Update, Query, Stop

B.

Create, Get, List, Stop, Restore

C.

Create, Query, Update, List, Start

D.

Create, Query, List, Stop, Restore

Page: 1 / 11
Total 149 questions