Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening

Post by answerhappygod »

Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)

A. too many buffer busy waits
B. very low buffer cache-hit ratio
C. very high buffer cache-hit ratio
D. many waits on the db file scattered read event
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”