DBS-C01 Monitoring and Troubleshooting Practice Question
A company is running a critical Oracle database on Amazon RDS. The DBA wants to set up monitoring to detect if the database is experiencing a high number of full table scans, which may indicate missing indexes. Which TWO metrics should the DBA monitor? (Choose TWO.)
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
TableScanRows
The DBA should monitor TableScanRows (A) and FullTableScans (B). FullTableScans directly counts the number of full table scan operations, while TableScanRows indicates the number of rows read during full scans. High values in either metric suggest missing indexes. BufferCacheHitRatio (C) measures cache efficiency, not full scans. UserCommits (D) tracks transaction commits, and RedoLogSpaceUsage (E) relates to redo log activity, neither of which indicate full table scans.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
TableScanRows
Why this is correct
Shows the number of rows scanned in full table scans.
- ✓
FullTableScans
Why this is correct
Directly counts full table scans, indicating potential missing indexes.
- ✗
BufferCacheHitRatio
Why it's wrong here
This metric shows cache hit ratio, not full table scans.
- ✗
UserCommits
Why it's wrong here
Commit count is unrelated to table scans.
- ✗
RedoLogSpaceUsage
Why it's wrong here
This metric is about redo log, not table scans.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.