PDF (New 2022) Actual Oracle 1z0-931-22 Exam Questions [Q51-Q67]

QUESTION 51
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 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 52
Which three are Oracle-recommended best practices for Autonomous Database alarms?

Suppress alarms during investigations.

Create multiple alarm metrics.

Create a single alarm for each metric.

Select the correct alarm interval for your metric.

Routinely tune your alarms.

Use a single interval for all alarms.

QUESTION 53
Which statement is not correct when the Autonomous Database is stopped?

In-flight transactions queries are stopped

Tools are no longer able to connect to a stopped instance

User with DWROLE can still access the database

CPU billing is halted

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

TPURGENT

TP

MEDIUM

LOW

QUESTION 55
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.

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

QUESTION 56
Which stage of the indexing pipeline divides text into tokens?

SECTIONER

FILTER

Otokenizer

LEXER

QUESTION 57
Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

User’s OCID

Tenancy’s OCID

Database ADMIN password

Fingerprint of the public key

QUESTION 58
Which statement is true about the use of Access Control Lists (ACLS) with an Autonomous Database on Shared Infrastructure?

When you restore a database, the existing ACLs are not overwritten by the restore.

An ACL can only be set during the creation of an Autonomous Database on Shared Infrastructure.

ACLs can only be used with private endpoints.

An ACL can be set up for an IP address or a virtual cloud network (VCN) but not both at the same time.

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

Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations

Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user

Oracle Data Safe only supports Autonomous Databases

Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary

QUESTION 60
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 61
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

QUESTION 62
What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Users have OS access to the database machine.

Users can customize the maintenance schedule.

It offers greater control and isolation starting at the Exadata cloud infrastructure level.

Users have SYS privileges in the database.

Users can customize the OS stack and add additional packages

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

Data Pump Export File

Avro

Parquet

Text

JSON

Microsoft SQL Server (.mdf)

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

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

QUESTION 65
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.

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

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.

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
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 Database. The overloaded form enables you to use the operation_id parameter.
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 67
Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

RMAN

Logs

OCI Metrics

Performance Hub

Enterprise Manager Cloud Control

Leave a Reply Cancel reply