Online Access Free 1Z0-931 Practice Test

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

• A.In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition.
• B.In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition.
• C.In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
• D.In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table.

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_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.
• C.The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• D.The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• E.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.

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

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

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

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

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

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