R4RIN – MCQs, Mock Tests | MongoDB MongoDB Mcq Question Set 14

______ specifies a geometry in GeoJSON format to geospatial query operators.

1. $sphere
2. $geoin
3. $geometry
4. All of the mentioned

✅ Correct Answer: 3

Point out the correct statement.

1. Both 2dsphere and 2d geospatial indexes support $geoWithin
2. $geoWithin does not require a geospatial index
3. The $geoWithin operator does not return sorted results
4. none of the mentioned

✅ Correct Answer: 2

_____ returns geospatial objects in proximity to a point on a sphere. Requires a geospatial index.

1. $near
2. $nearsphere
3. $geoIntersect
4. None of the mentioned

✅ Correct Answer: 2

____ specifies a minimum distance to limit the results of $near and $nearSphere queries.

1. $center
2. $maxDistance
3. $minDistance
4. All of the Mentioned

✅ Correct Answer: 3

The _________ operator specifies a circle for a $geoWithin query.

1. $within
2. $gwithin
3. $center
4. All of the Mentioned

✅ Correct Answer: 3

____ index must exist on a field holding coordinates before using any of the geospatial query operators.

1. Unique
2. Geospatial
3. Temporal
4. All of the Mentioned

✅ Correct Answer: 2

When creating a text index on multiple fields, you can specify the individual fields or you can use wildcard specifier ______

1. ($*)
2. (**$**)
3. ($**)
4. none of the mentioned

✅ Correct Answer: 3

Point out the wrong statement.

1. In order to drop a text index, use the index name
2. The default language associated with the indexed data determines the rules to parse word roots and ignore stop words
3. To allow for text search on all fields with string content, use the wildcard specifier ($$$) to index all fields that contain string content
4. none of the mentioned

✅ Correct Answer: 3

The default language for the indexed data is ______

1. chinese
2. english
3. spanish
4. None of the mentioned

✅ Correct Answer: 2

If a collection contains documents or embedded documents that are in different languages, include a field named _______ in the documents.

1. operator
2. lang
3. language
4. All of the mentioned

✅ Correct Answer: 2

Point out the correct statement.

1. After 2.4, you can terminate both background index builds and foreground index builds
2. The specified language in the document overrides the default language for the text index
3. The text index, like other indexes, should not fall within the index name length limit
4. None of the mentioned

✅ Correct Answer: 2

To use a field with a name other than language, include the ________ option when creating the index.

1. language_over
2. language_override
3. langoverride
4. None of the mentioned

✅ Correct Answer: 2

The default name for the index consists of each indexed field name concatenated with _______

1. _char
2. _textc
3. _text
4. All of the Mentioned

✅ Correct Answer: 3

To avoid creating an index with a name that exceeds the index name length limit, you can pass the _____ option to the db.collection.createIndex() method.

1. name
2. lang
3. number
4. All of the Mentioned

✅ Correct Answer: 1

The default weight is ____ for the indexed fields.

1. 1
2. 2
3. 3
4. 4

✅ Correct Answer: 1

For a ______ index, the weight of an indexed field denotes the significance of the field relative to the other indexed fields in terms of the score.

1. unique
2. natural
3. text
4. All of the Mentioned

✅ Correct Answer: 2

_____ operations that use an index often have better performance than those that do not use an index.

1. Select
2. Update
3. Delete
4. Sort

✅ Correct Answer: 4

Point out the wrong statement.

1. The query scans the index and the collection
2. An index supports a query when the index contains all the fields scanned by the query
3. Creating indexes that support queries results in greatly increased query performance
4. None of the mentioned

✅ Correct Answer: 1

A prefix of a _______ index is a subset that consists of one or more keys at the start of the index key pattern.

1. unique
2. primary
3. compound
4. None of the mentioned

✅ Correct Answer: 2

Sort operations that do not use an index will abort when they use _______ megabytes of memory.

1. 16
2. 32
3. 64
4. All of the Mentioned

✅ Correct Answer: 2

Point out the correct statement.

1. If you only ever query on a single key in a given collection, then you need to create just multikey index for that collection
2. 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
3. The choice between creating compound indexes that support your queries or relying on index intersection is independent of specifics of your system
4. None of the mentioned

✅ Correct Answer: 2

An index can support sort operations on a non-prefix subset of the index key pattern using _________ condition.

1. predicate
2. selection
3. equality
4. None of the mentioned

✅ Correct Answer: 3

______ method provides a wrapper around the totalIndexSize output of the collStats (i.e. db.collection.stats()) operation.

1. db.collection.totalallIndexSize()
2. db.collection.totalIndexSizeAll()
3. db.collection.totalIndexSize()
4. All of the Mentioned

✅ Correct Answer: 3

Indexes do not have to fit entirely into ______ in all cases.

1. ROM
2. RAM
3. Secondary Storage
4. None of the mentioned

✅ Correct Answer: 1

____ is the ability of a query to narrow results using the index.

1. Causality
2. Cardinality
3. Selectivity
4. All of the Mentioned

✅ Correct Answer: 2

______ query calculates distances using flat (planar) geometry.

1. $center
2. $centre
3. $radii
4. Sort

✅ Correct Answer: 1

Point out the wrong statement.

1. The query scans the index and not the collection
2. 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
3. A better strategy, depending on your queries, would be to create a compound index that includes the high-selectivity field and another field
4. none of the mentioned

✅ Correct Answer: 2

______ defines a circle for a geospatial query that uses spherical geometry.

1. $center
2. $centre
3. $radii
4. $centersphere

✅ Correct Answer: 4

When used with the $box operator, _________ returns documents based on grid coordinates and does not query for GeoJSON shapes.

1. $geoNear
2. $geoWithin
3. $geoRear
4. All of the Mentioned

✅ Correct Answer: 2

Point out the correct statement.

1. Applications can use $center without having a geospatial index
2. Before 3.0, a geospatial index must exist on a field holding coordinates before using any of the geospatial query operators
3. To use $centerSphere, specify an array that contains grid coordinates of the circle’s center point
4. None of the mentioned

✅ Correct Answer: 1

Applications can use _________ without having a geospatial index.

1. $center
2. $centre
3. $radii
4. $centersphere

✅ Correct Answer: 4

_____ specifies a polygon for a geospatial $geoWithin query on legacy coordinate pairs.

1. $rect
2. $polygon
3. $poly
4. All of the Mentioned

✅ Correct Answer: 2

Only the ______ geospatial index supports the $polygon operator.

1. 1dsphere
2. 2d
3. 3d
4. None of the mentioned

✅ Correct Answer: 2

_____ returns a document only once for a geospatial query even if the document matches the query multiple times.

1. $uniqueDocs
2. $unique
3. $Docs
4. All of the Mentioned

✅ Correct Answer: 1

A _______ set is a group of mongod instances that host the same data set.

1. copy
2. sorted
3. radii
4. replica

✅ Correct Answer: 4

Point out the wrong statement.

1. Replication provides redundancy and increases data availability
2. Replication allows you to recover from hardware failure and service interruptions
3. With multiple copies of data on different database servers, replication protects a database from the loss of a single server
4. None of the mentioned

✅ Correct Answer: 4

All other instances, secondaries, apply operations from the _________ so that they have the same data set.

1. center
2. secondary
3. primary
4. none of the mentioned

✅ Correct Answer: 3

A replica set can have only ________ primary.

1. One
2. Two
3. Three
4. All of the Mentioned

✅ Correct Answer: 1

Point out the wrong statement.

1. In all cases, you can use replication to increase read capacity
2. Clients have the ability to send read and write operations to different servers
3. You can also maintain copies in different data centers to increase the locality and availability of data for distributed applications
4. None of the mentioned

✅ Correct Answer: 1

To support replication, the primary records all changes to its data sets in its _______

1. oplog
2. adlog
3. log
4. None of the mentioned

✅ Correct Answer: 1

You may add an extra mongod instance to a replica set as an ____

1. arbiter
2. replicator
3. additor
4. All of the mentioned

✅ Correct Answer: 1

An arbiter will always be an arbiter whereas a primary may step down and become a secondary and a _________ may become the primary during an election.

1. center
2. secondary
3. primary
4. None of the mentioned

✅ Correct Answer: 2

When a primary does not communicate with the other members of the set for more than ____ seconds, the replica set will attempt to select another member to become the new primary.

1. 10
2. 20
3. 30
4. None of the mentioned

✅ Correct Answer: 1

When a replica set has one and only one primary, reads from that primary provide ______ consistency.

1. strict
2. partial
3. weak
4. All of the Mentioned

✅ Correct Answer: 1

How many types of members exist in replica set?

1. 1
2. 2
3. 3
4. 4

✅ Correct Answer: 2

Point out the wrong statement.

1. Replication provides scalability and increases data redundancy
2. A replica set in MongoDB is a group of mongod processes that provide redundancy and high availability
3. You can also maintain an arbiter as part of a replica set
4. none of the mentioned

✅ Correct Answer: 1

Which of the member receives all write operations?

1. center
2. secondary
3. primary
4. None of the mentioned

✅ Correct Answer: 3

____ replicate operations from the primary to maintain an identical data set.

1. center
2. secondary
3. primary
4. None of the mentioned

✅ Correct Answer: 2

Point out the wrong statement.

1. The minimum requirements for a replica set are: A primary, a secondary, and an arbiter
2. The primary is the only member in the replica set that receives write operations
3. Most deployments, however, will keep three members that store data: A primary and two secondary members
4. None of the mentioned

✅ Correct Answer: 4

____ play a role in the elections that select a primary if the current primary is unavailable.

1. Arbiters
2. Replicators
3. Loggers
4. None of the mentioned

✅ Correct Answer: 1