MongoDB interview questions part 35

MongoDB interview questions part 35

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 ?

Correct Answer is : $last

Similar Interview Questions

    Search for latest jobs

    Icon
    Icon