23 August, 2023

The Most Recent Guide To 1z0-931-20 Free Download

Want to know Pass4sure 1z0-931-20 Exam practice test features? Want to lear more about Oracle Oracle Autonomous Database Cloud 2020 Specialist certification experience? Study Approved Oracle 1z0-931-20 answers to Rebirth 1z0-931-20 questions at Pass4sure. Gat a success with an absolute guarantee to pass Oracle 1z0-931-20 (Oracle Autonomous Database Cloud 2020 Specialist) test on your first attempt.

Oracle 1z0-931-20 Free Dumps Questions Online, Read and Test Now.

Page: 1 / 5

Total 60 questions Full Exam Access

Question 1

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

An "INSERT" REST call

A "GET" REST call

A "POST" REST call

A "PUT" REST call

Question 2

Which statement is correct about managing and monitoring of Autonomous Database?

You can use Service console to move Autonomous DB between compartments.

You can use Service console to create manual backups of 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.

Question 3

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

Exadata

Active Data Guard

RAC, but only when scaling beyond 16 OCPUs

Transparent Data Encryption

Multitenant

Question 4

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

Transparent Data Encryption

Database Vault

Customer Managed Keys

Data Redaction

Audit Vault

Question 5

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

Autonomous Transaction Processing only

ATP and ADW

Autonomous Data Warehouse only

Hybrid Columnar compression

Question 6

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

TPPERFORMANT

MEDIUM

HIGH

LOW

TPURGENT

My answer: -

Reference answer: A

Reference analysis:

Predefined Database Service Names for Autonomous Transaction Processing
The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
• tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
• tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
• high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
• medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
• low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A

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

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

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

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

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

Question 8

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?

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 9

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

Network Security Group

Security List

VCN

Route Table

Subnet

Question 10

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

alter database set application_continuity=true

alter session set application_continuity=true

exec dbms_cloucl_admi

enable_app_cont ( ' <service_name> ' ) ;

alter system set application_continuity=true

Question 11

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

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 12

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

Admin page of the Cloud Service Console

OCI CLI

OS command line from the database server.

SQLDeveloper

Question 13

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

Number of OCPUs displayed in the console.

Amount of storage

I/O resources

parallelism settings

Level of concurrency

Question 14

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

It cannot be done.

Using Database Configuration Assistant (DBCA) on the database server.

Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

Connecting to the Cloud Infrastructure Command console via SSH wallet.

Question 15

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?

Release Update (RU)

Prior Release Update Revision (PRUR)

Prior Release Update (PRU)

Quarterly Bundle Patch (QBP)

Question 16

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

through the Oracle Cloud Infrastructure service console

through SQL/Developer s

using DBMS_CLOUD_ADMIN package

through SQLPIus

Question 17

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

SQLDEV_ADMIN.GRANT_SCHEMA

ORDS_ADMIN.ENABLE_SCHEMA

ORDS_ADMIN.GRANT_SCHEMA

ORDS_PRIV.ENABLE_SCHEMA

Question 18

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

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

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

It is enabled by default.

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

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

Question 19

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?

900

1800

2700

1500

Question 20

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

Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with the

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 21

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Backup and recovery must be done using Recovery Manager(RMAN).

Select the snapshot of the backup.

Select the archived redo logs.

Select the backup from which restore needs to be done.

Specify the point in time (timestamp) to restore.

Page: 1 / 5

Total 60 questions Full Exam Access