MCQOPTIONS
Saved Bookmarks
This section includes 9 Mcqs, each offering curated multiple-choice questions to sharpen your Mongodb knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
________ is the ability of a query to narrow results using the index. |
| A. | Causality |
| B. | Cardinality |
| C. | Selectivity |
| D. | All of the mentioned |
| Answer» C. Selectivity | |
| 2. |
Indexes do not have to fit entirely into ______ in all cases. |
| A. | ROM |
| B. | RAM |
| C. | Secondary Storage |
| D. | None of the mentioned |
| Answer» B. RAM | |
| 3. |
INDEXES_DO_NOT_HAVE_TO_FIT_ENTIRELY_INTO________IN_ALL_CASES.?$ |
| A. | ROM |
| B. | RAM |
| C. | Secondary Storage |
| D. | None of the mentioned |
| Answer» B. RAM | |
| 4. |
_________is_the_ability_of_a_query_to_narrow_results_using_the_index.$ |
| A. | Causality |
| B. | Cardinality |
| C. | Selectivity |
| D. | All of the mentioned |
| Answer» C. Selectivity | |
| 5. |
__________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation. |
| A. | db.collection.totalallIndexSize() |
| B. | db.collection.totalIndexSizeAll() |
| C. | db.collection.totalIndexSize() |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 6. |
An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition. |
| A. | predicate |
| B. | selection |
| C. | equality |
| D. | none of the mentioned |
| Answer» D. none of the mentioned | |
| 7. |
Sort operations that do not use an index will abort when they use _______ megabytes of memory. |
| A. | 16 |
| B. | 32 |
| C. | 64 |
| D. | All of the mentioned |
| Answer» C. 64 | |
| 8. |
A prefix of a _______ index is a subset that consists of one or more keys at the start of the index key pattern. |
| A. | unique |
| B. | primary |
| C. | compound |
| D. | none of the mentioned |
| Answer» C. compound | |
| 9. |
_________ operations that use an index often have better performance than those that do not use an index. |
| A. | Select |
| B. | Update |
| C. | Delete |
| D. | Sort |
| Answer» E. | |