You can combine the ________ constraint with the sparse index to filter these null values from the unique index and avoid the error.(a) Hashed(b) Unique(c) Sparse(d) CompoundI had been asked this question in a job interview.My query is from Index Properties in chapter Index/Indexing Concepts of MongoDB

You can combine the ________ constraint with the sparse index to filte

1.	You can combine the ________ constraint with the sparse index to filter these null values from the unique index and avoid the error.(a) Hashed(b) Unique(c) Sparse(d) CompoundI had been asked this question in a job interview.My query is from Index Properties in chapter Index/Indexing Concepts of MongoDB
Answer» Correct option is (c) Sparse To EXPLAIN I would say: If a document does not have a value for the INDEXED field in a unique index, the index will STORE a NULL value for this document.

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