Oracle 1Z0-931-25 Online Practice Questions and Exam Preparation

Oracle 1Z0-931-25 Online Questions & Answers

• Question 61:

  Which statement is true when the Autonomous Database has auto scaling enabled?

  A. Increases the number of sessions available to the database
  B. Scales the PGA and SGA size when needed for the workload
  C. Database concurrency is scaled up when needed by the workload
  D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload
  D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload

• Question 62:

  As a database architect, you are tasked with configuring a high concurrency, production OLTP(EXAM) application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?

  A. TPURGENT
  B. TP
  C. HIGH
  D. MEDIUM
  C. HIGH

• Question 63:

  Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

  A. Autonomous Transaction Processing only
  B. Hybrid Columnar Compression
  C. ATP and ADW
  D. Autonomous Data Warehouse only
  C. ATP and ADW

• Question 64:

  Which predefined service connection should you use when running lots of high concurrent queries in an Autonomous Database?

  A. DBNAME_LOW
  B. DBNAME_MEDIUM
  C. DBNAME_HIGH
  D. DBNAME_CONCURRENT
  A. DBNAME_LOW

• Question 65:

  How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure Console?

  A. Using the DBCA on the database server
  B. Connecting to the cloud infrastructure console using the SSH wallet
  C. It cannot be done
  D. Using the cloud infrastructure command line interface or REST API calls
  D. Using the cloud infrastructure command line interface or REST API calls

• Question 66:

  Which file is NOT a component of the client credentials wallet used to connect to an Oracle Autonomous Database?

  A. protocol.ora
  B. ewallet.p12
  C. sqlnet.ora
  D. keystore.jks
  E. cwallet.sso
  A. protocol.ora

• Question 67:

  In which four ways can Oracle Database optimally access data in Object Storage? (Choose four.)

  A. Scan avoidance using partitioned external tables
  B. Scan avoidance using columnar pruning for .csv files
  C. Scan avoidance using block skipping when reading parquet and orc files
  D. Scan avoidance using columnar pruning for columnar stores like parquet and orc
  E. Optimized data archive using hybrid partitioned tables
  F. Optimized data archive using partitioned external tables
  A. Scan avoidance using partitioned external tables
  D. Scan avoidance using columnar pruning for columnar stores like parquet and orc
  E. Optimized data archive using hybrid partitioned tables
  F. Optimized data archive using partitioned external tables

• Question 68:

  Which three advanced options can you enable or disable while creating a business model? (Choose three.)

  A. Autonomous Aggregate Cache
  B. Analytic View Transparency View
  C. Analytic View Base Table Query Transformation
  D. Display private tables
  E. Business Object Security Feature
  A. Autonomous Aggregate Cache
  B. Analytic View Transparency View
  C. Analytic View Base Table Query Transformation

• Question 69:

  Which three options do NOT change when enabling auto scaling? (Choose three.)

  A. Amount of storage
  B. Parallelism settings
  C. I/O resources
  D. Number of OCPUs displayed in the console
  E. Level of concurrency
  A. Amount of storage
  B. Parallelism settings
  E. Level of concurrency

• Question 70:

  Which two actions can you perform with Autonomous Data Guard enabled on Autonomous Database on Shared Infrastructure? (Choose two.)

  A. View Apply Lag
  B. Reinstate
  C. Switchover
  D. Failover
  E. Change Protection Mode
  C. Switchover
  D. Failover