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

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

1Z0-931-21 Exam Details

  • Exam Code
    :1Z0-931-21
  • Exam Name
    :Oracle Autonomous Database Cloud 2020 Specialist
  • Certification
    :Oracle Certifications
  • Vendor
    :Oracle
  • Total Questions
    :112 Q&As
  • Last Updated
    :May 28, 2026

Oracle 1Z0-931-21 Online Questions & Answers

  • Question 21:

    While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statementis true about the workloads?

    A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
    B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
    C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
    D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

  • Question 22:

    Which statement is true when you provision an Autonomous Database using the cloning method?

    A. After an Autonomous database is created using a clone, the network access option can be changed.
    B. A clone database source can be a running database instance.
    C. A clone database source can be from a point-in-time backup that is less than 2 hours old.
    D. When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

  • Question 23:

    A customer wants to increase the throughput of their inserts. They have discovered that the bottleneck is in the storage I/Os of their environment. What should theydo to remove this bottleneck?

    A. Run the DBMS_CLOUD.INCREASE_THROUGHPUT procedure.
    B. Remove any non-JSON data from the database.
    C. Increase the number of OCPUs allocated to the database.
    D. Ask Support to migrate their setup to a node without noisy neighbors.

  • Question 24:

    Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

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

  • Question 25:

    Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

    A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
    B. The OCI compute instance does not support connecting to a Shared Autonomous Database.
    C. The Autonomous Database must belong to a Network Security Group (NSG).
    D. The OCI compute instance can be used with an Always-Free Autonomous Database account.
    E. A Private Endpoint is required to connect to the Shared-Autonomous Database.

  • Question 26:

    You are the admin user of an Autonomous Database (ADB) instance. A new business analysthas joined the team and would like to explore ADB tables using SQL Developer Web. What steps do you need to take?

    A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
    B. Create a database user with the default privileges.
    C. Create a database user with connect, resource, and object privileges.
    D. Create an IDCS user. Create a database user with connect, resource, and object privileges.

  • Question 27:

    Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

    A. through the Oracle Cloud Infrastructure service console
    B. through SQL/Developer s
    C. using DBMS_CLOUD_ADMIN package
    D. through SQLPIus

  • Question 28:

    In Graph Studio which you can use to create a graph?

    A. A graph license key
    B. Tables in an Autonomous Database instance
    C. NoSQL configuration
    D. Graph analytics algorithms
    E. Graph created by a special tool downloaded from Oracle.com

  • Question 29:

    According to Oracle documentation, it is a best practice whenplanning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.

    Which statement is true?

    A. Create a separate VCN that contains only public subnets
    B. Only 1 of each is allowed to be allocated per environment.
    C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
    D. Create at least 2 of each resource

  • Question 30:

    Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

    A. Network Security Group
    B. Security List
    C. VCN
    D. Route Table
    E. Subnet

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-21 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.