Oracle 1Z0-931 Online Practice Questions and Exam Preparation

Oracle 1Z0-931 Online Questions & Answers

• Question 11:

  What are two security features enabled by default by the Autonomous Database? (Choose two.)

  A. Transparent Data Encryption
  B. Encrypted Database Links
  C. SQL Net Encryption
  D. One SYSDBA account
  E. Read Only access to OS Audit logs
  A. Transparent Data Encryption
  B. Encrypted Database Links

  ---

  Reference: https://juliandontcheff.wordpress.com/category/cloud/

• Question 12:

  Which is correct about security features that are available in Oracle Autonomous Database?

  A. TDE but not Data Redaction.
  B. Data Redaction and TDE are both supported.
  C. Data Redaction but not TDE.
  D. Neither Data Redaction nor TDE are supported.
  B. Data Redaction and TDE are both supported.

  ---

  Reference: https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html

• Question 13:

  What is the default retention period for both Automatic and Manual Autonomous Database Backups?

  A. One Year
  B. 7 days
  C. 60 days
  D. 30 days
  E. 90 days
  C. 60 days

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/backup-manual.html#GUID-D95E5D6A-C470-4A68-9545-CC99D937E7D1

• Question 14:

  The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

  A. UPDATE_OBJECT_INFO
  B. MODIFY_SNAPSHOT_SETTINGS
  C. CREATE_BASELINE_TEMPLATE
  D. MODIFY_BASELINE_WINDOW_SIZE
  B. MODIFY_SNAPSHOT_SETTINGS

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/monitor-performance-intro.html#GUID-4A1E8FCA-FAF1-43F5-93E0-559C0145D6C3

• Question 15:

  When exporting a notebook, what type of file is created?

  A. XML
  B. TXT
  C. JSON
  D. SQL
  E. ASCII
  C. JSON

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/omlug/get-started-notebooks-data-analysis-and-data-visualization.html#GUID-1EE10D98-DEC3-4591-9D17-72DC5EDDD77D

• Question 16:

  Which of these database features is NOT part of the Autonomous Database?

  A. Online Indexing
  B. Flashback Database
  C. Real Application Clusters (RAC)
  D. Java in the Database
  D. Java in the Database

• Question 17:

  How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

  A. Two. They are called ATP and ADW.
  B. None. There are no pre-defined service names in tnsnames.ora.
  C. Three. They are called high, medium and low.
  D. Five. They are called tpurgent, tp, high, medium and low.
  D. Five. They are called tpurgent, tp, high, medium and low.

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8FF8-F5AC650F15BE

• Question 18:

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

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

• Question 19:

  Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.

  How should the customer unplug their database to migrate to Autonomous Database (ADB)?

  A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
  B. Create a database link from source database to the ADB environment and clone the PDB.
  C. Unplug to an xml file so database files and xml file can be uploaded to object storage.
  D. Unplug into a pdb archive which can be uploaded to object storage.
  B. Create a database link from source database to the ADB environment and clone the PDB.

• Question 20:

  Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.

  Which statement about these consumer groups is correct?

  A. Medium provides intermediate resource and concurrency, and queries run in a serial.
  B. Low provides highest concurrency, lowest resources, and DoP =1.
  C. High provides highest resources, lowest concurrency, and DoP is 1.
  D. High provides highest concurrency and lowest resources, and DoP is 1.
  B. Low provides highest concurrency, lowest resources, and DoP =1.

  ---

  Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A7D6-E201DD4107B7