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

1z0-931-23 Questions and Answers

Question # 6

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.

Which service will you need to connect to?

A.

TPURGENT

B.

TP

C.

MEDIUM

D.

LOW

Full Access
Question # 7

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

A.

Autonomous Transaction Processing

B.

Autonomous Data Warehouse

C.

Neither service ignores hints by default

D.

Both services ignore hints by default

Full Access
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?

A.

Release Update (RU)

B.

Prior Release Update Revision (PRUR)

C.

Prior Release Update (PRU)

D.

Quarterly Bundle Patch (QBP)

Full Access
Question # 9

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

A.

inside the Autonomous Database wallet

B.

inside the backups of the container database

C.

In a separate key vault external to the Exadata Infrastructure

D.

on the Exadata Infrastructure where Autonomous Database Dedicated is hosted

Full Access
Question # 10

What is the maximum number of days that an Autonomous Database Refreshable Clone can be trailing its source instance?

A.

15 days

B.

1 day

C.

7 days

D.

30 days

Full Access
Question # 11

You created an Autonomous Database without auto scaling. Which two ways can you enable auto scaling?

A.

Click Scale Up/Down and select the Auto Scaling checkbox

B.

Use a REST call to enable Auto Scaling

C.

Use a REST call to shut down the instance, then a second REST call to enable Auto Scaling, and a REST all to restart the instance

D.

Shut down the instance, click Scale Up/Down and select the Auto Scaling checkbox, then restart the instance

Full Access
Question # 12

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?

A.

Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.

B.

You can use the dbms_auto_index package to report on the automatic task and to set your preferences.

C.

It is enabled by default.

D.

You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.

E.

The indexing feature is implemented as an automatic task that runs at a fixed interval.

Full Access
Question # 13

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

A.

The standby database is started readwrite

B.

The standby database is transformed in a refreshable clone

C.

The standby database is terminated

D.

The standby database is started read only

Full Access
Question # 14

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

A.

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

B.

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

C.

Create a notification alert using DBMS_SNMP package

D.

Create an Oracle Cloud Infrastructure Alarm for Shutdown metric

Full Access
Question # 15

Where do you find the URL for Database Actions?

A.

in Oracle Cloud Infrastructure Object Storage

B.

in the Database Users card under Database Actions

C.

on the SQL Developer Client Connection tab

D.

in the database with a SQL query

Full Access
Question # 16

Which two Oracle Cloud Infrastructure (OCI) resources do you need to create before initiating a manual backup of Oracle Autonomous Database?

A.

Backup Job

B.

Service Gateway

C.

Auth Token

D.

Object Storage Bucket

E.

Storage Gateway

Full Access
Question # 17

Which option describes the connection type that third-party software can use to connect to an Autonomous Database (ADB)?

A.

JDBC only

B.

SQL*Net only

C.

new ADB-specific protocols

D.

any protocol supported by Oracle Net Services

Full Access
Question # 18

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

A.

Undo Management

B.

Index Storage

C.

Memory Usage

D.

Data Organization

E.

Backup Retention

Full Access
Question # 19

Which three advanced options can you enable or disable while creating a business model?

A.

Analytic View Base Table Query Transformation

B.

Analytic View Transparency Views

C.

Autonomous Aggregate Cache

D.

Business Object Security Feature

E.

Display Private Tables

Full Access
Question # 20

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

A.

Active transactions in Autonomous Data Warehouse are paused

B.

Active transactions continue running unaffected

C.

Active transactions are paused

D.

Active transactions are terminated and rolled back

E.

Scaling can happen while there are active transactions in the database

Full Access
Question # 21

Which are the two restrictions for an Always Free Autonomous Database?

A.

supports only ATP as a workload type

B.

maximum of two Always Free Databases per OCI tenancy

C.

Oracle Application Express (APEX) not included

D.

maximum of one OCPU per Database

Full Access
Question # 22

Which option is not available to access data in an Autonomous JSON Database?

A.

Regular Oracle SQL statements using a connection string to the database

B.

Oracle Cloud Infrastructure console using the JSON Developer tool

C.

REST API calls to the database

O NoSQL statements using Simple Oracle Document Access (SODA) drivers

Full Access
Question # 23

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

A.

Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB

B.

Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

C.

Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB

D.

Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

Full Access
Question # 24

Which is a feature of a graph query language?

A.

Scripting language

B.

Run key-value queries

C.

Object-oriented language

D.

Ability to specify patterns

Full Access
Question # 25

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

A.

Use SFTP to copy CSV files into Autonomous Database

B.

Use Oracle Zero Downtime Migration (ZDM)

C.

Use Recovery Manager (RMAN)

D.

Use GoldenGate

E.

Use Data Pump

Full Access
Question # 26

Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

A.

Transparent Data Encryption

B.

Database Vault

C.

Customer Managed Keys

D.

Data Redaction

E.

Audit Vault

Full Access
Question # 27

In Graph Studio which you can use to create a graph?

A.

A graph license key

B.

Tables in an Autonomous Database instance

C.

NoSQL configuration

D.

Graph analytics algorithms

E.

Graph created by a special tool downloaded from Oracle.com

Full Access
Question # 28

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

A.

Autonomous Exadata infrastructure maintenance takes place at least once each quarter

B.

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

C.

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

D.

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

Full Access
Question # 29

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

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

Full Access
Question # 30

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

A.

through the Oracle Cloud Infrastructure service console

B.

through SQL/Developer s

C.

using DBMS_CLOUD_ADMIN package

D.

through SQLPIus

Full Access
Question # 31

You are requested to analyze a year's stock purchase data which is stored in Autonomous Data Warehouse instance.

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

A.

Business Models

B.

Data Load

C.

SQL Developer Web

D.

APEX

Full Access
Question # 32

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

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

Full Access
Question # 33

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?

A.

Data Insights

B.

JSON

C.

Catalog

D.

Data Load

Full Access
Question # 34

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

A.

On the Autonomous Database Console.

B.

SSH keys are not required in Oracle Cloud Infrastructure.

C.

SSH keys cannot be added from console. They have to be added using REST APIs only.

D.

Navigate to Identity, select Users panel on the console and select "Add Public Key".

Full Access
Question # 35

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

A.

Number of OCPUs displayed in the console.

B.

Amount of storage

C.

I/O resources

D.

parallelism settings

E.

Level of concurrency

Full Access
Question # 36

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 nonpeak hours. The architecture team is debating whether such reports should be run on the online transaction processing (OLTP) database or in a separate data mart. The DBA Manager does not want to add anymore 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

A.

Use Autonomous Transaction Processing (ATP) with "tpurgent" and "high" TNS services to separate connection types

B.

The application should be deployed on a Kubernetes Cluster because it needs to be highly available

C.

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

D.

Use Autonomous Data Warehouse (ADW) because operational reporting is a higher priority in this scenario

Full Access
Question # 37

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 anymore 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?

A.

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

B.

ADW since operational reporting is a higher priority in this scenario.

C.

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

D.

ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

Full Access
Question # 38

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

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

Full Access
Question # 39

Which native data type is used to store spatial information?

A.

SDO_RELATE

B.

SDO_GEOMETRY

C.

SDO_LOCATION

D.

GEO_JSON

Full Access
Question # 40

When an administrator rotates the instance wallet for an Autonomous Database on Shared Infrastructure, what happens to the regional wallets used with that instance?

A.

They continue to work

B.

They revert to pending

C.

They are also rotated

D.

They become invalid

Full Access
Question # 41

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

A.

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

B.

Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.

C.

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.

D.

Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

Full Access
Question # 42

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

A.

Start

B.

Update License Type

C.

Update Network Access

D.

Change Administrator Password

Full Access
Question # 43

Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.

How should the customer unplug their database to migrate to Autonomous Database (ADB)?

A.

Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

B.

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

C.

Unplug to an xml file so database files and xml file can be uploaded to object storage.

D.

Unplug into a pdb archive which can be uploaded to object storage.

Full Access
Question # 44

Which three event types are supported for Autonomous Database?

A.

Terminate End

B.

Maintenance Begin

C.

Change Compartment Begin

D.

Change Autoscaling Configuration Compartment

E.

Update IORM Begin

Full Access
Question # 45

Which four file formats are supported when loading data from Cloud Storage?

A.

DOC

B.

AVRO

C.

JSON

D.

DDL

E.

Dcsv

F.

Parquet

Full Access
Question # 46

Which statement is true when you provision an Autonomous Database using the cloning method?

A.

After an Autonomous database is created using a clone, the network access option can be changed.

B.

A clone database source can be a running database instance.

C.

A clone database source can be from a point-in-time backup that is less than 2 hours old.

D.

When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Full Access
Question # 47

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

A.

Network Security Group

B.

Security List

C.

VCN

D.

Route Table

E.

Subnet

Full Access
Question # 48

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

A.

1524

B.

1522

C.

1521

D.

1523

E.

1526

Full Access
Question # 49

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 50

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

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.

Full Access
Question # 51

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

A.

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

Connection button, then Download the Wallet.

B.

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

Download the Wallet.

C.

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

Wallet.

D.

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

Credentials.

E.

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

the Client Credentials (Wallet).

Full Access