Online Access Free 1Z0-931-21 Practice Test

Which two of the following statements are correct?

• A.ODI Web Edition is available only on Oracle Linux.
• B.The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.
• C.All of the capabilities of ODI Classic are available with ODI Web Edition,
• D.ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

Which three options are available to access data in an Autonomous JSON Database?

• A.Oracle Cloud Infrastructure console using the JSON Online Developer tool
• B.Oracle JSON Developer tool downloaded from OTN
• C.Regular Oracle SQL statements using a connection through the listener
• D.REST API calls to the database (not enabled by default)
• E.NOSQL statements using Oracle SODA drivers

Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

• A.Active Data Guard
• B.Multitenant
• C.Exadata
• D.Transparent Data Encryption
• E.RAC, but only when scaling beyond 16 OCPUs

Which statement is not correct when the Autonomous Database is stopped?

• A.User with DWROLE can still access the database
• B.Tools are no longer able to connect to a stopped instance
• C.In-flight transactions queries are stopped
• D.CPU billing is halted

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.DELETE_FILE procedure removes the credentials file from 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.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in 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.