1. Home
  2. Oracle
  3. 1Z0-931

Oracle 1Z0-931 Online Practice Questions and Exam Preparation

1Z0-931 Exam Details

  • Exam Code
    :1Z0-931
  • Exam Name
    :Oracle Autonomous Database Cloud 2019 Specialist
  • Certification
    :Oracle Certifications
  • Vendor
    :Oracle
  • Total Questions
    :60 Q&As
  • Last Updated
    :Sep 11, 2022

Oracle 1Z0-931 Online Questions & Answers

  • Question 51:

    Which operating system can Data Visualization Desktop be run on?

    A. AIX
    B. Linux
    C. Windows
    D. Solaris

  • Question 52:

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

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

  • Question 53:

    Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)

    A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
    B. Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet.
    C. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
    D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials. E. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.

  • Question 54:

    Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

    A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
    B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
    C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
    D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
    E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

  • Question 55:

    Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?

    A. TPURGENT
    B. MEDIUM
    C. HIGH
    D. TPPERFORMANT
    E. LOW

  • Question 56:

    What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

    A. ADBDEV
    B. ADMIN
    C. DWROLE
    D. ADWC

  • Question 57:

    Which two system privileges does a user need to create analytic views? (Choose two.)

    A. CREATE ANALYTIC MEASURE
    B. CREATE ANALYTIC LEVEL
    C. CREATE ANALYTIC HIERARCHY
    D. CREATE ANALYTIC VIEW
    E. CREATE ATTRIBUTE DIMENSION

  • Question 58:

    Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

    A. Replicate the table using Golden Gate
    B. Create a Data Set
    C. Load data using Data Pump
    D. Import Table

  • Question 59:

    What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)

    A. Autonomous Databases monitoring for usage and query performance.
    B. Creating schemas.
    C. Creating and scaling of Autonomous Database service.
    D. Wizard to download connection wallet for connection from desktop tools.

  • Question 60:

    When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

    A. Storage in TB cannot be larger than the number of OCPUs.
    B. OCPUs and storage must remain in sync.
    C. Increasing OCPUs will automatically increase storage.
    D. OCPUs and storage can be scaled independently.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-931 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.