Free Oracle 1Z0-997-25 Exam Dumps Questions & Answers

To reduce database load, where should you integrate OCI Cache in a typical request flow?

• A.In application health check logic
• B.At database driver level
• C.After database call
• D.Before database read, after service logic

What key metric should trigger an alarm to avoid cache node failure due to memory exhaustion?

• A.CPUUtilization
• B.MemoryUtilization > ~80%
• C.EvictionCount
• D.NetworkThroughput

You are running a mission-critical database application in Oracle Cloud Infrastructure (OCI). You take regular backups of your DB system to OCI Object Storage. Recently, you notice a failed database backup status in the console.
What troubleshooting action can you perform to determine the cause of the backup failure?
Response:

• A.Ensure that your database host can connect to OCI Object Storage.
• B.Ensure that the dcsagent program is not restarted in case of a stop/waiting status.
• C.Ensure that the database is not active and running while the backup is in progress.
• D.Ensure the database archiving mode is set to NOARCHIVELOG.

Custom metric ingestion is failing under high-frequency updates. What should you tweak first?

• A.Optimize Monitoring Query Language (MQL) aggregation window
• B.Increase log storage
• C.Increase log retention
• D.Add more tracing spans

Which tool provides real-time performance monitoring and historical query analysis for Autonomous DB?

• A.SQL*Plus
• B.OCI Monitoring Console only
• C.Performance Hub in Database Actions
• D.Performance Insights