Oracle Oracle Certifications 1Z0-931-22 Questions & Answers

• Question 11:

  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 CloudObject Storage credentials in 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 optionsspecified for the external table in a badfile table on 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_EXTERNAL_TABLE procedure creates anexternal table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

  Correct Answer: BCE

  DELETE_FILE Procedure

  This procedure removes the specified file from the specified directory on Autonomous Data Warehouse.

  CREATE_CREDENTIAL Procedure

  This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

  Use stored credentials for data loading or for querying external data residing in the Cloud.

  PUTJDBJECT Procedure

  This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The

  maximum file size allowed in this procedure is 5 gigabytes (GB).

  VALIDATE EXTERNAL TABLE Procedure This procedure validates the source files for an external table, generateslog 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. CREATE_EXTERNAL_TABLE Procedure This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.

  To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process. This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're moving the log import.log to object store witha DBMS_CLOUD.PUT_OBJECT command.

  VALIDATE_EXTERNAL_TABLE Procedure This 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 abadfiletable on Autonomous Database. The overloaded form enables you to use the operation_id parameter. PUT_OBJECT Procedure This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedureis 5 gigabytes (GB) DELETE FILE Procedure This procedure removes the specified file from the specified directory on Autonomous Database. CREATE_EXTERNAL_TABLE Procedure This procedure creates an external table on files in the Cloud. This allows you to runqueries on external data from Autonomous Database.

• Question 12:

  When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column. What does this mean?

  A. The SQL statement completed its execution.

  B. The SQL statement is executing.

  C. TheSQL statement is queued.

  D. The SQL statement did not complete either due to an error.

  Correct Answer: C

  https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm

  

• Question 13:

  Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)

  A. Oracle Cloud Infrastructure Object Storage

  B. Google Cloud Storage

  C. Amazon S3

  D. Azure Blob Storage

  E. Oracle Cloud Infrastructure Object Storage Classic

  Correct Answer: AE

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpud/load-data-using-oracle-data- pump.html#GUID025C4566-1BDB-4EF2-BFB7-0CBA8C47EA5D Data Pump Import lets you import datafrom Data Pump files residing on the Oracle Cloud Infrastructure

  Object Storage and Oracle Cloud Infrastructure Object Storage Classic .

  You can save your data to your Cloud Object Store and use Oracle Data Pump to load data to Autonomous Database. https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/#articletitle https://docs.oracle.com/en/cloud/paas/autonomous-database/adbbk/index.html#ADBBK- GUID-37922C56

  0412-45CD-B10C-2088A000113F

  https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data- pump.html#GUIDF8897403-2DE2-447E-94DC-768C9ABB05AF https://docs.oracle.com/en/cloud/paas/autonomous-database/adbdu/use-oracle-data- pump.html#GUID

  F8897403-2DE2-447E-94DC-768C9ABB05AF

• Question 14:

  Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

  A. Autonomous Transaction Processing

  B. Autonomous Data Warehouse

  C. Neither service ignores hints by default

  D. Both services ignore hints by default

  Correct Answer: B

  

  https://blogs.oracle.com/pcoe/post/autonomous-database-tools-for-database- actions#:~:text=Data% 20Catalog%3A%20it%20helps%20to,for%20a%20Data%20driven% 20company.

• Question 15:

  

  A BusinessAnalyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst.

  When restoring/cloning the ADB, you must select a backup which is atleast___hours/minutes old.

  A. 24hrs

  B. 2 hrs

  C. 5 min

  D. 1 day

  Correct Answer: A

• Question 16:

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

  A. In-flighttransactions queries are stopped

  B. Tools are no longer able to connect to a stopped instance

  C. User with DWROLE can still access the database

  D. CPU billing is halted

  Correct Answer: C

• Question 17:

  Which two of the followingstatements are correct?

  A. ODI Web Edition is available only on Oracle Linux.

  B. ODI Web Edition can be installed from Oracle Cloud Infrastructure (OCI) Marketplace.

  C. The Data Transforms Card provides access to Oracle Data Integrator (ODI) Web Edition.

  D. All of the capabilities of ODI Classic are available with ODI Web Edition,

  Correct Answer: AB

• Question 18:

  Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?

  A. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

  B. Create a database link from source databaseto the ADB environment and clone the PDB.

  C. Unplug to an xml file so database files and xml file can be uploaded to object storage.

  D. Unplug into a pdb archive which can be uploaded to object storage.

  Correct Answer: A

  Since an ADB database hassome restrictions on the object types and Oracle Database Options you need to use a logical migration method rather than a physical one.

  The main migration tool for migrating to ADB is Data Pump. You can export your schemas and import them into ADB usingData Pump. To sync up the additional/incremental changes on the source database during the export/import process you can use GoldenGate or GoldenGate Cloud Service to replicate those changes to ADB.

  In the current release you cannot use physical migrationmethods like backup/restore, Data Guard, Pluggable/Unplug , database clones, and transportable tablespaces to move your existing database to ADB.

• Question 19:

  Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

  A. Transparent Data Encryption

  B. Database Vault

  C. Customer Managed Keys

  D. Data Redaction

  E. Audit Vault

  Correct Answer: ABC

  https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features- adb1.html#GUID-89E3C22ED4EB-472B-8287-41682C2B61B3

• Question 20:

  Which statement is FALSE about Oracle Autonomous JSON Database?

  A. JSON data is stored natively in the database

  B. You can promote Autonomous JSON Database to Autonomous Transaction /Processing

  C. It supports NoSQL-style, document-centric application

  D. There is a 20 GB limit on JSON collection

  Correct Answer: D