Free Oracle 1Z0-931-20 Exam Dumps Questions & Answers

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.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.
• C.  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.
• D.  The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• E.  The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

What is the default port number for accessing a newly created Autonomous Database?

• A.  1522
• B.  1523
• C.  1521
• D.  1524
• E.  1526

Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?

• A.  Any version
• B.  17.4 onwards
• C.  12c Release 2 onwards
• D.  18.1 onwards

Which two choices are true for Autonomous Data Warehouse (ADW)? (Choose two.)

• A.  Billing stops only when the ADW is terminated
• B.  Billing stops for both CPU usage and storage usage when ADW is stopped
• C.  Billing for storage continues when ADW is stopped
• D.  Billing for compute stops when ADW is stopped

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

• A.  Active transactions continue running unaffected.
• B.  Scaling cannot happen while there are active transactions in the database.
• C.  Active transactions are terminated and rolled back.
• D.  Active transactions are paused.