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

Oracle 1Z0-931-22 Online Questions & Answers

• Question 61:

  What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

  A. Users have OS access to the database machine.
  B. Users can customize the maintenance schedule.
  C. It offers greater control and isolation starting at theExadata cloud infrastructure level.
  D. Users have SYS privileges in the database.
  E. Users can customize the OS stack and add additional packages
  B. Users can customize the maintenance schedule.
  C. It offers greater control and isolation starting at theExadata cloud infrastructure level.

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbat/index.html#articletitle

  

• Question 62:

  When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?(Choose the best answer.)

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

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage- priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7 https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID- 80E464A7-8ED4-45BB-A7D6-E201DD4107B7

• Question 63:

  Which four file formats are supported when loading data from Cloud Storage?

  A. DOC
  B. AVRO
  C. JSON
  D. DDL
  E. Dcsv
  F. Parquet
  B. AVRO
  C. JSON
  E. Dcsv
  F. Parquet

• Question 64:

  Which two statements are true about Data Insights?

  A. You can retrieve previously executed Data Insights searches.
  B. Data Insights is available with on-premises deployments of Oracle Database.
  C. Data Insights is an additional priced option.
  D. You can search for Data Insights against a base table or business model.
  A. You can retrieve previously executed Data Insights searches.
  D. You can search for Data Insights against a base table or business model.

• Question 65:

  Which three options are available to access data in an Autonomous JSONDatabase?

  A. Oracle Cloud Infrastructure console using the JSON Online Developer tool
  B. Oracle JSON Developer tool downloaded from OTN
  C. NOSQL statements using Oracle SODA drivers
  D. REST API calls to the database (not enabled by default)
  E. Regular Oracle SQL statements using a connection through the listener
  A. Oracle Cloud Infrastructure console using the JSON Online Developer tool
  C. NOSQL statements using Oracle SODA drivers
  D. REST API calls to the database (not enabled by default)

• Question 66:

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

  A. It cannot be done.
  B. Using Database Configuration Assistant (DBCA) on the database server.
  C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
  D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
  C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

  ---

  The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands. https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using- oci-curl Examples of using Autonomous Database managing by REST API https://oracle.github.io/learning-library/workshops/autonomous-transaction- processing/LabGuide900ConfigureOCI-CLI.md

• Question 67:

  Which native data type is used to store spatial information?

  A. SDO_RELATE
  B. SDO_GEOMETRY
  C. SDO_LOCATION
  D. GEO_JSON
  B. SDO_GEOMETRY

• Question 68:

  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
  C. 2700

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/manage-priorities.html#GUID-6E4DCD27-CDAA-432D-A90B- 485C19EF72B0 It's 300x the number of OCPUs for TPURGEN

  

• Question 69:

  Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?

  A. Undo Management
  B. Index Storage
  C. Memory Usage
  D. Data Organization
  E. Backup Retention
  B. Index Storage
  C. Memory Usage

• Question 70:

  What happened with the standby database when disabling Autonomous Data Guard?

  A. The standby database is started readwrite
  B. The standby database is transformed in a refreshable clone
  C. The standby database is terminated
  D. Thestandby database is started read only
  C. The standby database is terminated