Sort operations that do not use an index will abort when they use _______ megabytes of memory.(a) 16(b) 32(c) 64(d) All of the mentionedI had been asked this question by my college professor while I was bunking the class.This question is from Indexing Strategies topic in division Index/Indexing Concepts of MongoDB

Sort operations that do not use an index will abort when they use ____

1.	Sort operations that do not use an index will abort when they use _______ megabytes of memory.(a) 16(b) 32(c) 64(d) All of the mentionedI had been asked this question by my college professor while I was bunking the class.This question is from Indexing Strategies topic in division Index/Indexing Concepts of MongoDB
Answer» The CORRECT CHOICE is (b) 32 The EXPLANATION is: If the query planner cannot OBTAIN the SORT order from an index, it will sort the results in memory.

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