Point out the correct statement.(a) If you only ever query on a single key in a given collection, then you need to create just multikey index for that collection(b) If you sometimes query on only one key and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index(c) The choice between creating compound indexes that support your queries or relying on index intersection is independent of specifics of your system(d) None of the mentionedI had been asked this question in an internship interview.My enquiry is from Indexing Strategies topic in division Index/Indexing Concepts of MongoDB

Point out the correct statement.(a) If you only ever query on a single

1.	Point out the correct statement.(a) If you only ever query on a single key in a given collection, then you need to create just multikey index for that collection(b) If you sometimes query on only one key and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index(c) The choice between creating compound indexes that support your queries or relying on index intersection is independent of specifics of your system(d) None of the mentionedI had been asked this question in an internship interview.My enquiry is from Indexing Strategies topic in division Index/Indexing Concepts of MongoDB
Answer» The CORRECT answer is (B) If you sometimes query on only ONE KEY and at other times query on that key combined with a second key, then creating a compound index is more efficient than creating a single-key index For EXPLANATION: MongoDB will use the compound index for both queries.

Discussion

No Comment Found

Related InterviewSolutions

_________ specifies a polygon for a geospatial $geoWithin query on legacy coordinate pairs.(a) $rect(b) $polygon(c) $poly(d) All of the mentionedThis question was posed to me in final exam.Asked question is from Indexing Methods in chapter Index/Indexing Concepts of MongoDB
Only the ______ geospatial index supports the $polygon operator.(a) 1dsphere(b) 2d(c) 3d(d) None of the mentionedThe question was posed to me during an internship interview.The above asked question is from Indexing Methods in chapter Index/Indexing Concepts of MongoDB
Applications can use _________ without having a geospatial index.(a) $center(b) $centre(c) $radii(d) $centersphereI have been asked this question in an international level competition.This key question is from Indexing Methods topic in portion Index/Indexing Concepts of MongoDB
Point out the correct statement.(a) Applications can use $center without having a geospatial index(b) Before 3.0, a geospatial index must exist on a field holding coordinates before using any of the geospatial query operators(c) To use $centerSphere, specify an array that contains grid coordinates of the circle’s center point(d) None of the mentionedI got this question during an interview.Origin of the question is Indexing Methods topic in portion Index/Indexing Concepts of MongoDB
When used with the $box operator, _________ returns documents based on grid coordinates and does not query for GeoJSON shapes.(a) $geoNear(b) $geoWithin(c) $geoRear(d) All of the mentionedThe question was posed to me by my college director while I was bunking the class.The doubt is from Indexing Methods topic in portion Index/Indexing Concepts of MongoDB
_________ defines a circle for a geospatial query that uses spherical geometry.(a) $center(b) $centre(c) $radii(d) $centersphereThis question was posed to me during an online interview.My query is from Indexing Methods topic in portion Index/Indexing Concepts of MongoDB
Point out the wrong statement.(a) The query scans the index and not the collection(b) If overall selectivity is high, and if MongoDB must read a number of documents to return results, then some queries may perform faster without indexes(c) A better strategy, depending on your queries, would be to create a compound index that includes the high-selectivity field and another field(d) None of the mentionedI got this question in my homework.This question is from Indexing Methods in chapter Index/Indexing Concepts of MongoDB
__________ query calculates distances using flat (planar) geometry.(a) $center(b) $centre(c) $radii(d) SortI have been asked this question in an interview for internship.This is a very interesting question from Indexing Methods in chapter Index/Indexing Concepts of MongoDB
Indexes do not have to fit entirely into ______ in all cases.(a) ROM(b) RAM(c) Secondary Storage(d) None of the mentionedThe question was asked in semester exam.Enquiry is from Indexing Strategies in chapter Index/Indexing Concepts of MongoDB
__________ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.(a) db.collection.totalallIndexSize()(b) db.collection.totalIndexSizeAll()(c) db.collection.totalIndexSize()(d) all of the mentionedI got this question in homework.Asked question is from Indexing Strategies in section Index/Indexing Concepts of MongoDB

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment