Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-931

Oracle 1z0-931 Exam Practice Questions (P. 1)

  • Full Access (60 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)
  1. A
    Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
  2. B
    Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
  3. C
    Data Pump is faster to migrate database than using RMAN.
  4. D
    Data Pump creates the tablespaces used by your Autonomous Database.

Correct Answer:
AC
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-data-pump.html#GUID-30DB1EEA-DB45-49EA-9E97-
DF49A9968E24

Question #2
The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?
  1. A
    UPDATE_OBJECT_INFO
  2. B
    MODIFY_SNAPSHOT_SETTINGS
  3. C
    CREATE_BASELINE_TEMPLATE
  4. D
    MODIFY_BASELINE_WINDOW_SIZE

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

Question #3
Which task is NOT automatically performed by the Oracle Autonomous Database?
  1. A
    Backing up the database.
  2. B
    Mask your sensitive data.
  3. C
    Patching the database.
  4. D
    Automatically optimize the workload.

Correct Answer:
B
Reference:
https://www.oracle.com/database/what-is-autonomous-database.html

Question #4
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
  1. A
    The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
  2. B
    The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
  3. 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.
  4. D
    The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
  5. 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.

Correct Answer:
BDE
Reference:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-930632E1-B7BF-4ECA-8F78-5E5A205C0865

Question #5
Which of these database features is NOT part of the Autonomous Database?
  1. A
    Online Indexing
  2. B
    Flashback Database
  3. C
    Real Application Clusters (RAC)
  4. D
    Java in the Database

Correct Answer:
D

Next Questions

All Pages