MENU
If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?
Suggested Answer: B
Get Premium C100DBA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
MI
Mireya
11 months ago
Sounds like a trick question to me!
JU
Junita
12 months ago
I agree, it has to be B.
CA
Carmelina
12 months ago
Wait, how can totalKeysExamined be 30000 with 0 docs?
WA
Walton
12 months ago
Definitely B, using an index here!
ST
Stephaine
1 year ago
The query returned 0 documents.
GE
Geraldine
1 year ago
I feel like option C makes sense since if no documents were examined, then it likely returned zero results.
GA
Gayla
1 year ago
I'm not entirely sure, but I think if totalDocsExamined is 0, it means the query didn't return any documents at all.
DO
Dolores
1 year ago
I remember something about totalKeysExamined being high while totalDocsExamined is zero indicating an index was used.
MO
Mozell
1 year ago
I practiced a similar question where a high number of keys examined meant the query was efficient, but I can't recall the exact details.
BR
Brendan
1 year ago
Ah, I know this one! The property setting to automatically increase the deployment version is "Increment Deployment Version". I'm confident that's the right answer.
SA
Sarina
1 year ago
Hmm, I'm a little unsure on this one. I know there are different types of financial analysis, but I can't quite remember the specific term for comparing year-over-year changes. I'll have to think this through carefully.
TI
Tiffiny
1 year ago
Hmm, I'm a bit unsure about this one. I know measures of central tendency have to do with describing the typical or average value in a data set, but I'm not totally clear on the differences between the options. I'll have to think this through carefully.