Free Oracle 1z0-931-22 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.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• 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.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.
• E.  The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

While provisioning a dedicated Autonomous Container Database, which backup retention can NOT be implemented?

• A.  120 days
• B.  15 days
• C.  60 days
• D.  7 days

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.
What steps do you need to take?

• A.  Create a database user with the default privileges.
• B.  Create a database user with connect, resource, and object privileges.
• C.  Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
• D.  Create an IDCS user. Create a database user with connect, resource, and object privileges.

While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?

• A.  Prior Release Update Revision (PRUR)
• B.  Quarterly Bundle Patch (QBP)
• C.  Release Update (RU)
• D.  Prior Release Update (PRU)

In Graph Studio which you can use to create a graph?

• A.  Graph analytics algorithms
• B.  A graph license key
• C.  Tables in an Autonomous Database instance
• D.  Graph created by a special tool downloaded from Oracle.com
• E.  NoSQL configuration