Free Oracle 1z0-1111-23 Exam Dumps Questions & Answers

What is the purpose of using Resolution in a Monitoring Query Language expression?

• A.Resolution controls the total length of each time window
• B.Resolution defines the start time of each time window
• C.Resolution is used with suppression to pause alarm during system maintenance
• D.Resolution automatically resolves the alarm which is Firing state

What are the TWO features that are available for an Autonomous Database that is enabled with Database Management? (Choose two.)

• A.View average active session by CPU, I/O and wait depending on the deployment type
• B.Number of queued and running SQL statements
• C.Monitor and analyze optimizer statistics advisor tasks and implement recommendations
• D.Generate AWR report for selected time period

Which of the following capabilities does the performance management feature of Database Management Services offer to a managed database?

• A.Visualizes and performs trend analysis from AWR data to detect issues using AWR explorer
• B.Dynamically modifies database initialization parameters to improve performance
• C.Automatically invokes full stats gathering of objects to improve performance of regressed SQLS

Which is NOT a valid statement regarding the Oracle Cloud Infrastructure (OCI) Audit logs?

• A.Audit logs can be displayed at the Compartment level.
• B.Audit Logs are disabled by default and must be manually enabled for each compartment in your tenancy.
• C.One of the key reasons to view Audit Logs is to collect security related events.

What step must be performed to enable Operations Insights for an Autonomous Database?

• A.Create an Object Storage Bucket for the Database
• B.Enable Operations Insights for the Database
• C.Configure an OCI Bridge for the Database
• D.Install a Management Agent on the Database