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

Oracle 1Z0-931-21 Online Questions & Answers

• Question 81:

  During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?

  A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
  B. the Client Credentials wallet which is used to connect to the Autonomous Database
  C. the 'High Availability Container Database' in which the Autonomous instance should run
  D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
  E. the Listener endpoint where the Autonomous Database should register on
  C. the 'High Availability Container Database' in which the Autonomous instance should run

  ---

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/adb_dedicated_creating.htm

• Question 82:

  How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure?

  A. Execute alter database for user MTHEO tablespace DATA quota = 10G;
  B. Execute alter user MTHEO quota unlimited on tablespace DATA;
  C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);
  D. Execute alter tablespace DATA setquota = 10G;
  C. Execute DBMS_CLOUD_ADMIN. GRANT_TABLESPACE_QOOTA (username => 'MTHEO' , tablespace__quota => "UNLIMITED*);

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms- cloud-admin.html#GUID-4DC6A536-DC78-43FE-B173-CED1F9FB45A0

• Question 83:

  Which statement is FALSE about Oracle Autonomous JSON Database?

  A. JSON data is stored natively in the database
  B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing
  C. It supports NoSQL-style, document-centric application
  D. There is a 20 GB limit on JSON collection
  D. There is a 20 GB limit on JSON collection

  ---

  

• Question 84:

  Which can be Scaled Independently of the number of CPUs In an Autonomous Database?

  A. Parallelism
  B. Storage
  C. Concurency
  D. Memory
  E. Sessions
  B. Storage

  ---

  https://docs.oracle.com/en/cloud/paas/autonomous- database/adbsa/autonomous-key-features.html#GUID-7D0627D9-1B40-40B1-865A- 84FF65A65846 Key Features Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

  

• Question 85:

  Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)

  A. RMAN Cross-Platform backup and restore
  B. Golden Gate on-premise installation
  C. PDB unplug / plug operation
  D. Datapump export / import
  E. Dataguard Physical Standby
  F. Golden Gate Cloud service
  B. Golden Gate on-premise installation
  D. Datapump export / import
  F. Golden Gate Cloud service

  ---

  https://k21academy.com/1z0-931/migrate-database-to-oracle-autonomous-database-cloud- optionsdata-pump-sql-loader-dbms_cloud-goldengate/

• Question 86:

  While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure(OCI) console, which patch type is offered to be applied during maintenance?

  A. Release Update (RU)
  B. Prior Release Update Revision (PRUR)
  C. Prior Release Update (PRU)
  D. Quarterly Bundle Patch (QBP)
  A. Release Update (RU)

  ---

  On the Edit Automatic Maintenance card, select Release Update (RU) or Release Update Revision (RUR) from the Maintenance type list.

  Note:

  Currently, the Release Update Revision (RUR) maintenance type is not a selectable option. When release update revisions become available for Autonomous Database,this option will become selectable.

  Reference: https://docs.oracle.com/en-us/iaas/autonomous-database/doc/change- maintenance-type-acd1.html

• Question 87:

  You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism. Which service will you need to connect to?

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

  ---

  tpurgent: The highest priority application connection service for time critical transaction processing operations. This connectionservice supports manual parallelism. https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID- 9747539B-FD46-44F1-8FF8-F5AC650F15BE

• Question 88:

  Which two of the followingstatements are correct?

  A. ODI Web Edition is available only on Oracle Linux.
  B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.
  C. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
  D. All of the capabilities of ODI Classic are available with ODI Web Edition,
  A. ODI Web Edition is available only on Oracle Linux.
  B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

• Question 89:

  

  In which four ways can Oracle Database optimally access data in Object Storage?

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

• Question 90:

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

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

  ---

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data- pump.html#GUID025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D Data Pump Import lets you import datafrom Data Pump files residing on the Oracle Cloud Infrastructure Object Storage and Oracle Cloud Infrastructure Object Storage Classic . You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database. https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK- GUID-37922C56-0412-45CD-B10C-2088A000113F https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data- pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data- pump.html#GUID-F8897403-2DE2-447E-94DC-768C9ABB05AF