Q. __________ returns the day of the year for a date as a number between 1 and 366.

View solution

Q. Which of the following returns year for particular date?

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following returns the hour for a date as a number between 0 and 23?

View solution

Q. __________ returns the date as a formatted string.

View solution

Q. _______ result encompasses instances of undefined values or missing fields.

View solution

Q. ___________ returns either the non-null result of the first expression.

View solution

Q. __________ take as input a single expression, evaluating the expression once for each input document, and maintain their state for the group of documents.

View solution

Q. $sum is an accumulator operator available only in the _______ stage.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following ignores non numeric values?

View solution

Q. When using $first in a $group stage, the $group stage should follow a _______ stage to have the input documents in a defined order.

View solution

Q. Which of the following returns the value that results from applying an expression to the last document?

View solution

Q. __________ returns the highest value from the group of values in documents.

View solution

Q. Which of the following is syntax for calculating minimum value?

View solution

Q. If all documents for the $min operation have null value for the field or are missing the field, the $min operator returns ____ for the minimum value.

View solution

Q. $addToSet returns an array of all _______ values that results from applying an expression to each document.

View solution

Q. __________ references the root document, i.e. the top-level document, currently being processed in the aggregation pipeline stage.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the operator is similar to order by clause in RDBMS?

View solution