Q1. Which statement is FALSE about Autonomous Database maintenance on Dedicated Infrastructure?
A.You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow.
B. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates) and includes container database patching.
C. If a scheduled container database maintenance run cannot take place, Oracle automatically reschedules the container database maintenance for the following quarter.
D. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter.
Correct Answer: B
Q2. Autonomous Database's auto scaling feature allows your database to use up to three times the current base number of OCPU cores at any time. As demand increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores in use. Which statement is FALSE regarding the auto scaling feature?
A.For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that are not being used by other auto scaling databases to meet high-load demands.
B. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in the Exadata infrastructure instance.
C. The base number of OCPU cores allocated to a database is not guaranteed.
D. Auto Scaling is enabled by default and can be enabled or disabled at any time.
Correct Answer: C
Q3. You see a clock icon in the Status column on the SQL Monitoring tab of Performance Hub. What does it indicate?
A.The SQL statement is queued.
B. The SQL statement is executing.
C. The SQL statement did not complete either due to an error.
D. The SQL statement completed its execution.
Correct Answer: A
Q4. 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.1500
B. 1800
C. 900
D. 2700
Correct Answer: D
Q5. Which two statements are true about accessing the Autonomous Database Tools?
A.Database Actions is accessible from a server running on the same virtual cloud network (VCN) when the Autonomous Database is configured with Private Endpoint networking.
B. Oracle APEX can be accessed only from the Developer menu in the Service Console.
C. Oracle Machine Learning is available only with Autonomous Data Warehouse (ADW) Database.
D. Access to Database Actions is available for all users of Autonomous Database.
E. SQL Developer Web is exclusive to Autonomous Database, not traditional Oracle databases.
Correct Answer: B, E
$ 39
Reviews
There are no reviews yet.