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

Oracle 1Z0-931-25 Online Questions & Answers

• Question 1:

  Users connect to Autonomous Data Warehouse by using one of the following consumer groups: High, Medium, and Low. Which statement is true?

  A. Low provides highest concurrency and lowest resources, and DoP is 1.
  B. High provides highest concurrency and lowest resources, and DoP is 1.
  C. Medium provides intermediate resource and concurrency, and queries run serially.
  D. High provides highest resource and lowest concurrency, and Degree of Parallelism (DoP) is 1.
  A. Low provides highest concurrency and lowest resources, and DoP is 1.

• Question 2:

  You need to create a new database by using the Oracle Cloud Infrastructure (OCI) Command Line Interface (CLI) with the following requirements: Autonomous Transaction Processing, License Included, Shared Infrastructure. Which parameter would you NOT use?

  A. db-type
  B. is-dedicated
  C. db-workload
  D. license-model
  A. db-type

• Question 3:

  Which is NOT needed to manage Oracle Autonomous Database with REST APIs?

  A. User's OCID
  B. Tenancy's OCID
  C. Fingerprint of the public key
  D. Database ADMIN password
  D. Database ADMIN password

• Question 4:

  Which two cloud services allow you to import Data Pump files to an Autonomous Database on Dedicated Infrastructure? (Choose two.)

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

• Question 5:

  Which two statements are true about Data Insights?

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

• Question 6:

  Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

  A. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
  B. The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.
  C. The target table will be created in Autonomous Database if it does not already exist.
  D. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
  E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
  B. The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.
  E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

• Question 7:

  Which statement is FALSE about loading data into the Autonomous Database using the Data Load card in Database Actions?

  A. Data formats supported include: text, CSV, JSON, Avro, and Parquet
  B. Data can be loaded from a local data source
  C. Data can be uploaded from several cloud storage sources including S3, Azure, Google Cloud, and Oracle Object Storage
  D. You must first manually create your database credentials usingDBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket
  E. Data can be loaded from a remote database using Database Links (DBLinks)
  D. You must first manually create your database credentials usingDBMS_CLOUD.CREATE_CREDENTIAL before accessing your Oracle Object Storage Bucket

• Question 8:

  What are three characteristics of Data Lake data captured in Object Storage? (Choose three.)

  A. High concurrency
  B. High transaction performance
  C. Schema on read
  D. Multiple subject areas
  E. Mixed data types
  C. Schema on read
  D. Multiple subject areas
  E. Mixed data types

• Question 9:

  What are two advantages of using Data Pump to migrate your Oracle databases to Autonomous Database? (Choose two.)

  A. Data Pump is faster to migrate database than using RMAN
  B. Data Pump creates the tablespaces used by your Autonomous Database
  C. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database
  D. Data Pump is platform-independent - it can migrate Oracle databases running on any platform
  C. Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database
  D. Data Pump is platform-independent - it can migrate Oracle databases running on any platform

• Question 10:

  Which statement is FALSE about the Catalog tool?

  A. You can delete an entity from the Autonomous Database via the Catalog tool.
  B. You can limit the display of entities to only those with certain names, schemas, types, or applications by entering values in the Search field.
  C. You can view the data definition of an entity.
  D. Impact shows the entities that depend on the source.
  A. You can delete an entity from the Autonomous Database via the Catalog tool.