1z0-931

1z0-931 practice questions, page 3 of 3, with answer review and explanations.

Question 11

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

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

Question 12

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

  1. Active transactions continue running unaffected.
  2. Active transactions are paused.
  3. Scaling cannot happen while there are active transactions in the database.
  4. Active transactions are terminated and rolled back.