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

    Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

    A. User with DWROLE can still access the database.
    B. Tools are no longer able to connect to a stopped instance.
    C. CPU billing is halted based on full-hour cycles of usage.
    D. In-flight transactions and queries are stopped.

  • Question 42:

    If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

    A. tnsnames.ora
    B. keystore.jks
    C. sqlnet.ora
    D. cwallet.sso
    E. ojdbc.properties

  • Question 43:

    Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?

    A. Create, Query, Update, List, Start
    B. Create, Get, List, Stop, Restore
    C. Start, Delete, Update, Query, Stop
    D. Create, Query, List, Stop, Restore

  • Question 44:

    Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

    A. Place the credential files on a share drive that all users can use to connect to the database.
    B. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
    C. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.
    D. When you share the credential files with authorized users, mail the wallet password and the file in the same email.

  • Question 45:

    The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usemames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).

    Which statement is true about the migration of the application's database success?

    A. The migration can be technically a success but the 3-rd party vendor needs to support the result.
    B. The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
    C. The tablespace names will result in a blocking error during datapump import because of ADB limitations.
    D. The migration can be a success, both technically and functional due to datapump enhancements.

  • Question 46:

    Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

    A. VALIDATE_LEVELS
    B. VALIDATE_HIERARCHY
    C. VALIDATE_DIMENSION
    D. VALIDATE_ANALYTIC_VIEW
    E. VALIDATE_MEASURES

  • Question 47:

    When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

    A. TNSNAMES.ORA
    B. CWALLET.SSO
    C. OJDBC.PROPERTIES
    D. SQLNET.ORA

  • Question 48:

    A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back.

    Which statement about the migration using Golden Gate is correct?

    A. Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
    B. Only the migration to ADB is possible from an on-premise installation of Golden Gate.
    C. Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this.
    D. The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.
    E. The described scenario is correct, can be used for migration and fallback scenarios.

  • Question 49:

    What are three methods to load data into the Autonomous Database? (Choose three.)

    A. Oracle GoldenGate
    B. Transportable Tablespace
    C. RMAN Restore
    D. Oracle Data Pump
    E. SQL*Loader

  • Question 50:

    Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import.

    Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)

    A. SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps.
    B. SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage.
    C. SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running.
    D. SQL Developer can only export/move/import files using datapump from databases running on Linux systems.

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.