2023 Latest 1z0-931-23 DUMPS Q&As with Explanations Verified & Correct Answers [Q82-Q103]

Rate this post

2023 Latest 1z0-931-23 DUMPS Q&As with Explanations Verified & Correct Answers

1z0-931-23 dumps Exam Material with 175 Questions

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

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.

NEW QUESTION 83
Which two are ways Oracle Database can optimally access data in Object Storage?

Optimized data archive using hybrid partitioned tables

Optimized data archive using partitioned external tables

Scan avoidance using partitioned external tables

Scan avoidance using columnar pruning for .csv files

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

Parquet

DOC

DDL

JSON

CSV

AVRO

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

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

NEW QUESTION 86
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.

24 hrs

2 hrs

5 min

1 day

NEW QUESTION 87
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)?

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

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

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

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

NEW QUESTION 88
Which statement is correct about the Service console in an Autonomous Database?

You can use Service console to enable or disable auto scaling of Autonomous DB

You can use Service console to manage runaway SQL statements on Autonomous DB

You can use Service console to move Autonomous DB between compartments

You can use Service console to create manual backups of Autonomous database

NEW QUESTION 89
Which three functions are provided by Spatial Studio?

Spatial analysis

Geocoding

Custom SQL queries

Map visualization

Spatial data editing

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

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.

NEW QUESTION 91
Which two of the following statements are correct?

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,

NEW QUESTION 92
Which three operations are available for a quarterly maintenance update on Autonomous Container Database?

Reschedule patching

Skip patching

Apply a partial patch

Patch immediately

Reschedule and patch immediately

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

1-25 X OCPU

unlimited

20 X OCPU

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

A graph license key

Tables in an Autonomous Database instance

NoSQL configuration

Graph analytics algorithms

Graph created by a special tool downloaded from Oracle.com

NEW QUESTION 95
Which three options do NOT change when enabling auto scaling?

Parallelism settings

Amount of storage

Number of OCPUS displayed in the console

Level of concurrency

I/O resources

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

Active transactions in Autonomous Data Warehouse are paused

Active transactions continue running unaffected

Active transactions are paused

Active transactions are terminated and rolled back

Scaling can happen while there are active transactions in the database

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

1524

1522

1521

1523

1526

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

DOC

AVRO

JSON

DDL

Dcsv

Parquet

NEW QUESTION 99
While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

60 days

7 days

15 days

120 days

NEW QUESTION 100
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

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

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

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

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

NEW QUESTION 101
Which statement is FALSE about Data Insights?

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

NEW QUESTION 102
Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.

You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

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

NEW QUESTION 103
Where do you find the URL for Database Actions?

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