Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

• A.Autonomous Transaction Processing only
• B.Hybrid Columnar compression
• C.Autonomous Data Warehouse only
• D.ATP and ADW

Comment: *

Name: *

Email: *

Verification: *

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 Cloud Infrastructure Alarm for Shutdown metric

Correct Answer: B

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

• A.through SQL/Developer s
• B.through the Oracle Cloud Infrastructure service console
• C.through SQLPIus
• D.using DBMS_CLOUD_ADMIN package

Comment: *

Name: *

Email: *

Verification: *

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

• A.It cannot be done.
• B.Using Database Configuration Assistant (DBCA) on the database server.
• C.Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
• D.Connecting to the Cloud Infrastructure Command console via SSH wallet.

Comment: *

Name: *

Email: *

Verification: *