Which of the following returns a substring of a string?(a) $subs(b) $substring(c) $substr(d) None of the mentionedThis question was addressed to me at a job interview.Origin of the question is Pipeline and Sharded Collections in section Aggregation Concepts and Aggregation Mechanics of MongoDB

Which of the following returns a substring of a string?(a) $subs(b) $s

1.	Which of the following returns a substring of a string?(a) $subs(b) $substring(c) $substr(d) None of the mentionedThis question was addressed to me at a job interview.Origin of the question is Pipeline and Sharded Collections in section Aggregation Concepts and Aggregation Mechanics of MongoDB
Answer» Right option is (c) $substr For explanation: $substr accepts three expressions as arguments: the first ARGUMENT must resolve to a STRING, and the SECOND and third arguments must resolve to INTEGERS.

Discussion

No Comment Found

Related InterviewSolutions

____________ works similar to HAVING clause in SQL.(a) $setcon(b) $group(c) $match(d) None of the mentionedThe question was asked during an online interview.I would like to ask this question from SQL to Aggregation Mapping Chart topic in chapter Aggregation Concepts and Aggregation Mechanics of MongoDB
_______ groups documents by some specified expression and outputs to the next stage a document for each distinct grouping.(a) $setcon(b) $group(c) $match(d) None of the mentionedThis question was addressed to me in a national level competition.Origin of the question is SQL to Aggregation Mapping Chart in section Aggregation Concepts and Aggregation Mechanics of MongoDB
Which of the following provides similar functionality to join?(a) $unwindelem(b) $unwind(c) $unwin(d) None of the mentionedThe question was posed to me by my school teacher while I was bunking the class.The doubt is from SQL to Aggregation Mapping Chart in chapter Aggregation Concepts and Aggregation Mechanics of MongoDB
Which of the following is used to retrieve like SELECT clause in SQL?(a) $reduce(b) $select(c) $project(d) None of the mentionedThe question was asked in an online interview.This is a very interesting question from SQL to Aggregation Mapping Chart in section Aggregation Concepts and Aggregation Mechanics of MongoDB
________ limits the number of documents in result set.(a) $project(b) $geo(c) $limit(d) None of the mentionedThe question was asked during a job interview.I need to ask this question from SQL to Aggregation Mapping Chart in portion Aggregation Concepts and Aggregation Mechanics of MongoDB
Point out the wrong statement.(a) CURRENT references the start of the field path being processed in the aggregation pipeline stage(b) All stages start with CURRENT the same as ROOT(c) DESCENDING is one of the allowed results of a $let expression(d) None of the mentionedI have been asked this question by my school principal while I was bunking the class.Origin of the question is SQL to Aggregation Mapping Chart topic in portion Aggregation Concepts and Aggregation Mechanics of MongoDB
Which of the operator is similar to order by clause in RDBMS?(a) $sort(b) $match(c) $sortby(d) None of the mentionedI had been asked this question in an interview.Origin of the question is SQL to Aggregation Mapping Chart in section Aggregation Concepts and Aggregation Mechanics of MongoDB
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.(a) 1(b) 0(c) null(d) none of the mentionedI had been asked this question in an interview for internship.My doubt is from Pipeline Operators topic in division Aggregation Concepts and Aggregation Mechanics of MongoDB
Point out the wrong statement.(a) Variables can hold any BSON type data(b) Aggregation expressions can use both user-defined and system variables(c) To access the value of the variable, use a string with the variable name prefixed with double dollar signs ($$)(d) None of the mentionedThis question was posed to me in my homework.I would like to ask this question from SQL to Aggregation Mapping Chart topic in portion Aggregation Concepts and Aggregation Mechanics of MongoDB
__________ references the root document, i.e. the top-level document, currently being processed in the aggregation pipeline stage.(a) CURRENT(b) ROOT(c) PRUNE(d) All of the mentionedThe question was asked in class test.Origin of the question is SQL to Aggregation Mapping Chart topic in division Aggregation Concepts and Aggregation Mechanics of MongoDB

Which of the following returns a substring of a string?(a) $subs(b) $substring(c) $substr(d) None of the mentionedThis question was addressed to me at a job interview.Origin of the question is Pipeline and Sharded Collections in section Aggregation Concepts and Aggregation Mechanics of MongoDB

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment