Q. Which of the following is used to retrieve like SELECT clause in SQL?

View solution

Q. ________ limits the number of documents in result set.

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following provides similar functionality to join?

View solution

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

View solution

Q. Point out the wrong statement.

View solution

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

View solution

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

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. Which of the following is syntax for calculating minimum value?

View solution

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

View solution

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

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 ignores non numeric values?

View solution

Q. Point out the wrong statement.

View solution

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

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. ___________ returns either the non-null result of the first expression.

View solution

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

View solution

Q. __________ returns the date as a formatted string.

View solution