Oracle Autonomous Database Cloud 2019 Specialist

Here you have the best Oracle 1z0-931 practice exam questions

  • You have 60 total questions to study from
  • Each page has 5 questions, making a total of 12 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on December 1, 2024
Question 1 of 60

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

    Correct Answer: A, B

    Data Pump offers two clear advantages when migrating Oracle Databases to Autonomous Database. First, it allows excluding objects such as indexes and materialized views that are not necessary for the Autonomous Database, which helps streamline the migration process. Second, Data Pump is platform-independent, enabling the migration of Oracle Databases across different platforms without compatibility issues. These factors make options A and B the correct choices.

Question 2 of 60

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

    Correct Answer: B

    The default eight-day retention period for Autonomous Database performance data can be modified using the DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS subprogram procedure. This procedure allows configuring retention periods and other settings related to snapshot management in the Automatic Workload Repository.

Question 3 of 60

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

    Correct Answer: B

    Oracle Autonomous Database automatically takes care of tasks such as backing up the database, patching the database, and optimizing the workload. However, it does not automatically perform data masking, which is required to mask sensitive data.

Question 4 of 60

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

    Correct Answer: B, C, E

    The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. 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. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud, allowing you to run queries on external data from the Autonomous Data Warehouse.

Question 5 of 60

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

    Correct Answer: C

    Real Application Clusters (RAC) are not supported in the Autonomous Database. The Autonomous Database is designed to provide fault tolerance and high availability through different architecture and internal mechanisms, reducing the need for RAC to be included as part of its feature set.