1z0-931-22 by Oracle Actual Free Exam Q&As

Question 1

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

A. exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ; B. alter session set application_continuity=true C. alter system set application_continuity=true D. alter database set application_continuity=true

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

A. The OCI compute instance does not support connecting to a Shared Autonomous Database. B. A Private Endpoint is required to connect to the Shared-Autonomous Database. C. The OCI compute instance can be used with an Always-Free Autonomous Database account. D. The Autonomous Database must belong to a Network Security Group (NSG). E. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.

Discussion 0

Correct Answer: C Vote an answer

Question 3

Which stage of the indexing pipeline divides text into tokens?

A. FILTER B. Otokenizer C. LEXER D. SECTIONER

Discussion 0

Correct Answer: C Vote an answer

Question 4

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

A. Both services ignore hints by default B. Autonomous Data Warehouse C. Neither service ignores hints by default D. Autonomous Transaction Processing

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated?

A. Month of the Quarter, Week of the Month, Day of the Week, Start Hour B. Month of the Year, Week of the Month, Day of the Week, Start Hour C. Week of the Quarter, Day of the Week, Start Hour D. Quarter of the Year, Month of the Quarter, Date of the Month, Start Hour

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

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

A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); B. Log onto ADW server and issue is -al on the command line. C. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW). D. By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;

Discussion 0

Correct Answer: A Vote an answer

Question 7

Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

A. 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. B. 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. C. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure. D. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

Discussion 0

Correct Answer: C Vote an answer

Question 8

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

A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations. B. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar. C. Autonomous Data Warehouse workloads are optimized for mixed workloads. D. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)

A. Amazon S3 B. Azure Blob Storage C. Oracle Cloud Infrastructure Object Storage D. Google Cloud Storage E. Oracle Cloud Infrastructure Object Storage Classic

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Oracle Autonomous Database Cloud 2022 Professional - 1z0-931-22 Exam Practice Test