C100DBA CRUD Operations Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  .sort({age: 1})

  Why it's wrong here

  Passing 1 to the sort object specifies ascending order. This would sort documents from youngest to oldest, which is the exact opposite of the requested requirement. It is a common mistake to mix up 1 and -1 when defining sort order in MongoDB queries.

• ✓

  .sort({age: -1})

  Why this is correct

  In MongoDB, -1 represents descending order and 1 represents ascending order. {age: -1} correctly sorts the documents by the 'age' field from highest to lowest. This is the correct way to retrieve documents in reverse chronological or numerical order based on any chosen field.

• ✗

  .orderBy({age: 'desc'})

  Why it's wrong here

  .orderBy() is not a MongoDB method. This syntax is common in some ORMs and SQL-based frameworks but does not exist in the MongoDB shell or standard drivers. Using it will throw an error, as the cursor object does not possess an orderBy function for sorting query results.

• ✗

  .order({age: 'desc'})

  Why it's wrong here

  .order() is also an invalid method in MongoDB. Sorting is exclusively handled by the .sort() cursor modifier. Developers must adhere to the specified syntax of .sort({field: 1/-1}) to correctly organize their data, as using non-existent methods will always result in a runtime failure of the application code.