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 31:

    What REST verb is used to create an Autonomous Database service using REST APIs?

    A. A "POST" REST call
    B. A "PUT" REST call
    C. An "INSERT" REST call
    D. A "GET" REST call

  • Question 32:

    When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

    A. Active transactions continue running unaffected.
    B. Active transactions are paused.
    C. Scaling cannot happen while there are active transactions in the database.
    D. Active transactions are terminated and rolled back.

  • Question 33:

    Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

    A. Autonomous Transaction Processing.
    B. Autonomous Data Warehouse.
    C. Neither service ignores hints by default.
    D. Both services ignore hints by default.

  • Question 34:

    Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

    A. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.
    B. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
    C. A single fault domain can be associated with multiple regions and availability domains.
    D. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

  • Question 35:

    Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

    A. Backup and recovery must be done using Recovery Manager(RMAN).
    B. Select the snapshot of the backup.
    C. Select the archived redo logs.
    D. Select the backup from which restore needs to be done.
    E. Specify the point in time (timestamp) to restore.

  • Question 36:

    Which statement is true in regards to database links?

    A. You can call PL/SQL procedures and functions using a database link.
    B. Connect from Autonomous Database to remote database using a database link.
    C. Connect to Autonomous Database from remote database using a database link.
    D. Create a database link from one Autonomous Database to another Autonomous Database instance.

  • Question 37:

    Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.

    Which statement is true regarding Oracle Data Sync?

    A. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
    B. Data Sync can not transform your data while loading it into the destination table.
    C. Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files.
    D. Data Sync can only load data from one source into one destination table.

  • Question 38:

    A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well.

    Which Oracle Cloud Infrastructure database service is appropriate for this scenario?

    A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
    B. ADW since operational reporting is a higher priority in this scenario.
    C. It is best to build a separate data warehouse, and move the OLTP data on a nightly basis.
    D. ATP. Using 'tpurgent' and 'high' TNS services to separate connection types.

  • Question 39:

    Which two statements are true with regards to Oracle Data Sync? (Choose two.)

    A. Data Sync can connect to any jdbc compatible source like MongoDB, RedShift and Sybase.
    B. Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
    C. Data Sync can load your data in parallel in order to speed up the loading process.
    D. Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

  • Question 40:

    Which can be Scaled independently of the number of CPUs in an Autonomous Database?

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

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.