1Z0-931-22 Online Practice Questions and Answers

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

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

B. Virtual Cloud Network, Compartments, Policies, Autonomous Exadata Infrastructure

C. Autonomous Exadata Infrastructure, Autonomous Backup, Autonomous Container Database, Autonomous Database

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

Which option should you use to create a graph with Graph Studio?

A. A graph license key

B. NoSQL configuration

C. Graph created by a special tool downloaded from oracle.com

D. Graph analytics algorithms

E. Tables in an Autonomous Database instance

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

A. Backup and recovery must bedone using Recovery Manager(RMAN).

B. Select the snapshot of the backup.

C. Select the archived redo logs.

D. Select the backup from which restore needs to be done.

E. Specify the point in time (timestamp) to restore.

What are three methods to load data into the Autonomous Database?

A. Oracle GoldenGate

B. Transportable Tablespace

C. RMAN Restore

D. Oracle Data Pump

E. SQL*Loader

Which set of Oracle Cloud Infrastructure metrics is available only for Autonomous Database on Dedicated Infrastructure?

A. IOPS, Storage Space Used By Tablespace, Applyand Transport Lag

B. CPU Utilization, Storage Utilization

C. Query Latency, User Calls, Execute Count

D. Transaction Count, Sessions, Running Statements

Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?

A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure

B. Oracle Machine Learning ZeppelinNotebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator

C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database

D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure

Which two are correct actions to take in order to Download the Autonomous Database Credentials?

A. Click on the Autonomous Data Warehouse in the menu,click a database name, then Choose DB Connection button, then Download the Wallet.

B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.

C. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.

E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

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

Which three tools can be used to monitor the usage and activities of Autonomous Database on Dedicated Infrastructure?

A. RMAN

B. Logs

C. OCI Metrics

D. Performance Hub

E. Enterprise Manager Cloud Control

Whichstatement is FALSE about Oracle Data Safe?

A. It supports only Autonomous Databases.

B. It helps you assess the security of your cloud database configurations by analyzing database configurations.

C. It helps you find and mask sensitive data in your database by inspecting the actual data in your database and its data dictionary.

D. It evaluates user types, how users are authenticated, and the password policies assigned to each user.

E. It helps you evaluate risks to data, assess user security, monitor useractivity, and address data security compliance requirements.

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

A. 900

B. 1800

C. 2700

D. 1500

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization?

A. Oracle Machine Learning notebook

B. Compartment quotas

C. Resource Manager settings

D. SQL Developer Web Console

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

A. On the Autonomous Database Console.

B. SSH keys are not required in Oracle Cloud Infrastructure.

C. SSH keyscannot be added from console. They have to be added using REST APIs only.

D. Navigate to Identity, select Users panel on the console and select "Add Public Key".

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.

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.