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 three event types are supported for Autonomous Database?
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 »
Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing?
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 »