Oracle 1Z0-931-21 Exam Questions & Answers

Which two statements are true about accessing Autonomous Database Tools?

A. Access to Database Actions is available for all users of Autonomous Database.

B. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.

C. SQL Developer Web is available exclusively on the Autonomous Database.

D. Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpointnetworking.

E. Oracle APEX can be accessed only from the Developer menu in the Service Console.

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

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

B. Autonomous Data Warehouse workloads are optimized for mixed workloads.

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

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

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