Tag Archives: 1z0-931-22

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure

Your customer wants to permanently disable scheduled maintenance on Autonomous Dedicated Infrastructure to keep their current database version(s).How can they achieve this? A. Change the Automatic Maintenance Schedule to ‘None’d. B. Change the Automatic Maintenance Schedule to ‘Specify a Schedule’ but do not select any month, week or day. C. You cannot permanently disable scheduled Automatic Maintenance. D.… Read More »

A Business Analyst joined in your organization and wanted to explore the database tools. Which statement

A Business Analyst 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. 24 hrs B. 2 hrs C. 5 min D. 1 day Correct Answer: A

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.) A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage. C. A valid credential must be created prior to running… Read More »

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata

Which set of options can be specified when defining the preferred maintenance schedule of the Exadata infrastructure for Autonomous Database Dedicated? A. Week of the Quarter, Day of the Week, Start Hour B. Month of the Year, Week of the Month, Day of the Week, Start Hour C. Quarter of the Year, Month of the Quarter, Date of… Read More »

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service. The load on the database increases from three OCPUs to nine OCPUs. What is the total number of concurrent statements that the TPURGENT service can support? A. 900 B. 1800 C. 2700 D. 1500 Correct… Read More »

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

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. The SQL 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

Which statement is FALSE about Oracle Autonomous JSON Database?

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

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control

In the Autonomous Database (ADB) Dedicated service, what does the fleet administrator use to control OCPU utilization? A. Oracle Machine Learning notebook B. Compartment quotas C. Resource Manager settings D. SQL Developer Web Console Correct Answer: B https://docs.oracle.com/en-us/iaas/Content/Database/Concepts/adboverview.htm

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? A. Parallelism is not enabled by default. B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default. C. Oracle Database Result Cache is enabled by default for all SQL statements. D. You have direct access to the… Read More »