Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
 

Oracle 1z0-931 Exam Actual Questions

The questions for 1z0-931 were last updated on July 7, 2024.
  • Viewing page 1 out of 15 pages.
  • Viewing questions 1-4 out of 60 questions

Topic 1 - Single Topic

Question #1 Topic 1

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.
Reveal Solution Hide Solution   Discussion   14

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 Topic 1

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
Reveal Solution Hide Solution   Discussion   3

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 Topic 1

Which task is NOT automatically performed by the Oracle Autonomous Database?

  • A. Backing up the database.
  • B. Mask your sensitive data.
  • C. Patching the database.
  • D. Automatically optimize the workload.
Reveal Solution Hide Solution   Discussion   6

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

Question #4 Topic 1

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

  • A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
  • B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
  • 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.
  • D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
  • 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.
Reveal Solution Hide Solution   Discussion   11

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

Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in