1Z0-931-22 Online Practice Questions and Answers

Questions 4

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

A. TPPERFORMANT

B. MEDIUM

C. HIGH

D. LOW

E. TPURGENT

Buy Now

Questions 5

When integrating object storage with autonomous database how effectively oracle uses the files in the object storage?

A. Scan partition tables

B. scan hybrid partition tables

C. prun column in parquet files

D. prun columns in csv files

Buy Now

Questions 6

Whenyou are cloning from a backup, what is the earliest timestamp of the backup is allowed in Autonomous Database?

A. 2 hours

B. 30 minutes

C. 1 hours

D. 24 hours

Buy Now

Questions 7

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

A. 1524

B. 1522

C. 1521

D. 1523

E. 1526

Buy Now

Questions 8

During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator

B. the Client Credentials wallet which is used to connect to the Autonomous Database

C. the 'High Availability Container Database' in which the Autonomous instance should run

D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment

E. the Listener endpoint where the Autonomous Database should register on

Buy Now

Questions 9

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. Thestandby database is started read only

Buy Now

Questions 10

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

A. Execute alter database for user MTHEO tablespace DATA quota = 10G;

B. Execute alter user MTHEO quota unlimited on tablespace DATA;

C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

D. Execute alter tablespace DATA setquota = 10G;

Buy Now

Questions 11

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.

Buy Now

Questions 12

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

A. Data

B. Schemas

C. Tablespaces

D. Reports

Buy Now

Questions 13

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

A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores CloudObject Storage credentials in the Autonomous Data Warehouse database.

C. 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 optionsspecified for the external table in a badfile table on Autonomous Data Warehouse.

D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates anexternal table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Buy Now

Correct Answer: BCE

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, generateslog 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 witha 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 abadfiletable 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 procedureis 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 runqueries on external data from Autonomous Database.