Pass Oracle 1z0-931-23 Exam Info and Free Practice Test [Q70-Q92]

December 2, 2023 1z0-931-23, Oracle 0 Comments

Pass Oracle 1z0-931-23 Exam Info and Free Practice Test [Q70-Q92]

4.5/5 - (20 votes)

Pass Oracle 1z0-931-23 Exam Info and Free Practice Test

New 2023 Latest Questions 1z0-931-23 Dumps – Use Updated Oracle Exam

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

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

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

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

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

NEW QUESTION 71
You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.

Create a database user with the default privileges.

Create a database user with connect, resource, and object privileges.

Create an IDCS user. Create a database user with connect, resource, and object privileges.

NEW QUESTION 72
As a database architect, you are tasked with configuring a high concurrency, production OLTP (online transaction processing) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode.
Which connection service is appropriate for such a workload?

MEDIUM

HIGH

TPURGENT

NEW QUESTION 73
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 74
Which two actions are available to perform when an Autonomous Database is stopped?

Start

Update Network Access

Change administrator password

Update License Type

NEW QUESTION 75
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.

Autonomous Data Warehouse workloads are optimized for mixed workloads.

Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

NEW QUESTION 76
Which three event types are supported for Autonomous Database?

Terminate End

Maintenance Begin

Change Compartment Begin

Change Autoscaling Configuration Compartment

Update IORM Begin

NEW QUESTION 77
The Oracle Autonomous Database dedicated Exadata infrastructure feature is based upon which Oracle Cloud resources?

Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata Infrastructure, Fleet Administrator, Database Administrator,

Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

Fleet Administrator, Database Administrator, Database User, Autonomous Exadata Infrastructure

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

Files in Oracle Cloud Storage

Backup files in block storage

Local Files

Files in AWS S3 Storage

REST endpoints

NEW QUESTION 79
For Fleet admins to access dedicated Exadata infrastructure, which policy should be assigned?

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘DW’

Allow group ADB-Admins to manage autonomous-database in tenancy.

Allow group ADB-Admins to manage autonomous-database-family in tenancy.

Allow group ADB-Admins to manage autonomous-database in tenancy where target.workloadType = ‘OLTP’

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

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

NEW QUESTION 82
Which statement is FALSE regarding database links?

You can call PL/SQL procedures and functions by using a database link

You can connect to an Autonomous Database from a remote database using a database link

You can create a database link from one Autonomous Database to another Autonomous Database instance

You can connect to a remote database from an Autonomous Database by using a database line

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

Transparent Data Encryption

Database Vault

Customer Managed Keys

Data Redaction

Audit Vault

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

NEW QUESTION 85
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 86
When working with an Autonomous Exadata Infrastructure supporting Autonomous Databases, where do you go to view the maintenance history of the Exadata?

Under Core Infrastructure then Compute then Autonomous Exadata

Under Solutions and Platform then Platform Services then Autonomous Exadata

Under Database then Autonomous Transaction Processing then Autonomous Exadata

Under Core Infrastructure then Autonomous Exadata

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

Undo Management

Index Storage

Memory Usage

Data Organization

Backup Retention

NEW QUESTION 88
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?

Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.

Remove any non-JSON data from the database.

Increase the number of OCPUs allocated to the database.

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

NEW QUESTION 89
Which three are Oracle-recommended best practices for Autonomous Database alarms?

Create a single alarm for each metric

Suppress alarms during investigations

Tune your alarms routinely

Select the correct alarm interval for your metric

Use a single interval for all alarms

Create multiple alarm metrics

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