Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Comparison expressions return a boolean except for ________ which returns a number.
Correct Answer is : $cmp
2. Point out the correct statement :
Correct Answer is : $gte returns true if the first value is greater than or equal to the second
3. Point out the wrong statement :
Correct Answer is : Arithmetic expressions does not support date arithmetic
4. _______ adds numbers to return the sum, or adds numbers and a date to return a new date.
Correct Answer is : $add
5. ________ subtracts two dates to return the difference in milliseconds
Correct Answer is : $rem
6. $dayOfMonth returns the day of the month for a date as a number between :
Correct Answer is : 1 and 31
7. Point out the wrong statement :
Correct Answer is : $millis returns the milliseconds of a date as a number between 0 and 1000
8. __________ returns the day of the year for a date as a number between 1 and 366
Correct Answer is : $dayOfYear
9. Which of the following returns year for particular date ?
Correct Answer is : $year
10. Point out the wrong statement :
Correct Answer is : $cond accepts either two expressions in an ordered list or three named parameters
11. Which of the following returns the hour for a date as a number between 0 and 23 ?
Correct Answer is : $hour
12. __________ returns the date as a formatted string.
Correct Answer is : $dateToString
13. _______ result encompasses instances of undefined values or missing fields.
Correct Answer is : Null
14. __________ take as input a single expression, evaluating the expression once for each input document, and maintain their state for the group of documents.
Correct Answer is : Accumulators
15. $sum is an accumulator operator available only in the _______ stage
Correct Answer is : $group
16. Point out the wrong statement :
Correct Answer is : $avg ignores numeric values
17. Which of the following ignores non numeric values ?
Correct Answer is : $sum
18. When using $first in a $group stage, the $group stage should follow a _______ stage to have the input documents in a defined order.
Correct Answer is : $sort
19. Point out the wrong statement :
Correct Answer is : $first is not meaningful when documents are in a defined order
20. Which of the following returns the value that results from applying an expression to the last document ?