Tag Archives: Dumps

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 »

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints B. An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an… Read More »

When enabling auto-scaling, which three options do not change?

When enabling auto-scaling, which three options do not change? A. Number of OCPUs displayed in the console. B. Amount of storage C. I/O resources D. parallelism settings E. Level of concurrency Correct Answer: B,D,E https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/autonomous-auto-scale.html#GUID-27FAB1C1-B09F-4A7A-9FB9-5CB8110F7141

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should

You need to set up a notification for a scheduled shutdown of an Autonomous Database instance. What should you do? A. Add a “BEFORE SHUTDOWN ON DATABASE” trigger within the database B. Create a rule for the Oracle Cloud Infrastructure Event for “Autonomous Database STOP END” C. Create a notification alert using DBMS_SNMP package D. Create an Oracle… Read More »