NO.108 There is a gamers collection in your database with the following document structure:
{ _id: 1, level: 15, is_active: true }, { _id: 2, level: 14, is_active: true }, { _id: 3, level: 7, is_active: false }
How do you update the value of the level field to 20 for a player with an id = 2?
Expected result:
{ _id: 1, level: 15, is_active: true }, { _id: 2, level: 20, is_active: true }, { _id: 3, level: 7, is_active: false }

NO.109 Select true statements about capped collections.

NO.110 Suppose you have a movies collection with the following document structure: { _id: ObjectId(“573a1390f29313caabcd60e4”), title: ‘The Immigrant’, fullplot: “Charlie is on his way to the USA. He wins in a card game, puts the money in Edna’s bag (she and her sick mother have been robbed of everything). When he retrieves a little for himself he is accused of being a thief. Edna clears his name. Later, broke, Charlie finds a coin and goes into a restaurant.” } You want to sort result set by a relevance score computed by MongoDB in text search query and extract only three documents with the highest score. Which query do you need to use?

NO.111 Suppose you have a books collection with title field. Which of the following queries will return all books with a title ending in ‘ian’?

NO.112 What is the built-in database called local in MongoDB for?

NO.113 We have a movies collection with the following document structure: { _id: ObjectId(“573a1390f29313caabcd6223”), genres: [ ‘Comedy’, ‘Drama’, ‘Family’ ], title: ‘The Poor Little Rich Girl’, released: ISODate(“1917-03-05T00:00:00.000Z”), year: 1917, imdb: { rating: 6.9, votes: 884, id: 8443 } } We need to use Aggregation Framework to fetch all movies from this collection where ‘Drama’ is not in genres list and the minimum ‘imdb.votes’ is at least 100. Additionally, in the projection stage, we want to leave only the following fields: -> title -> genres -> imdb.votes We also want to sort the result set by decreasing imdb votes and limit the number of documents retuned to 5. Example output: [ { imdb: { votes: 1294646 }, genres: [ ‘Action’, ‘Mystery’, ‘Sci-Fi’ ], title: ‘Inception’ }, { imdb: { votes: 1109724 }, genres: [ ‘Adventure’, ‘Fantasy’ ], title: ‘The Lord of the Rings: The Fellowship of the Ring’ }, { imdb: { votes: 1081144 }, genres: [ ‘Adventure’, ‘Fantasy’ ], title: ‘The Lord of the Rings: The Return of the King’ }, { imdb: { votes: 1080566 }, genres: [ ‘Action’, ‘Sci-Fi’ ], title: ‘The Matrix’ }, { imdb: { votes: 1004805 }, genres: [ ‘Action’, ‘Thriller’ ], title: ‘The Dark Knight Rises’ } ] Which pipeline should you use?

NO.114 Why is MongoDB using BSON instead of JSON to store data? Select all that apply.

NO.115 You have the following index in a movies collection: { “title”: 1, “imdb.rating”: -1, “imdb.votes”: -1, “type”: 1 } Can the following query use the given index for both filtering and sorting?
db.movies.find( { “title”: { “$lt”: “M” } } ).sort( { “imdb.votes”: -1 } )

NO.116 You have the following index in a products collection: { product_category: 1, product_name: 1, origin_country: -1 } Which of the following queries can use this index? Check all that apply.

NO.117 Select all true statements regarding to replica sets in MongoDB.

NO.118 We have the following schema for a movies collection: { _id: ObjectId, title: String, genres: Array, languages: Array, year: 32-bit integer } And the following index on the movies collection: { title: 1 } Which of the following queries will use the given index to perform the sorting stage?

NO.119 What is data modeling in MongoDB world?

NO.120 Select all default configurations for mongod.

NO.121 Select all true statements regarding to transactions in MongoDB.

NO.122 In your database there is a collection named trips with the following document structure: { ‘_id’: ObjectId(“572bb8222b288919b68abf6d”), ‘trip_duration’: 858, ‘start_station id’: 532, ‘end_station_id’: 401, ‘bike_id’: 17057, ‘start_station_location’: { type: ‘Point’, coordinates: [ -73.960876, 40.710451 ] }, ‘end_station_location’: { type: ‘Point’, coordinates: [ -73.98997825, 40.72019576 ] }, ‘start_time’: ISODate(“2016-01-01T00:09:31.000Z”), ‘stop_time’: ISODate(“2016-01-01T00:23:49.000Z”) } How can you extract all trips from this collection ended at stations that are to the west of the -73.5 longitude coordinate?

NO.123 Given a movies collection where each document has the following structure: { _id: ObjectId(“573a1390f29313caabcd60e4”), genres: [ ‘Short’, ‘Comedy’, ‘Drama’ ], title: ‘The Immigrant’, year: 1917, imdb: { rating: 7.8, votes: 4680, id: 8133 }, countries: [ ‘USA’ ] } Which of the following queries will find all Comedy movies that were made in 2000? (select 2)

NO.124 What can you deduce from the explain() method?
For example:
db.collection.find().explain()

NO.125 How to shutdown the server? (Mongo shell)

NO.126 Select all true statements about data modeling in MongoDB.

NO.127 Suppose you have a companies collection in your database. Only the following documents are stored in this collection:
{ _id: ObjectId(“52cdef7c4bab8bd675297da4”), name: ‘Powerset’, category_code: ‘search’, founded_year: 2006 }, { _id: ObjectId(“52cdef7c4bab8bd675297da5”), name: ‘Technorati’, category_code: ‘advertising’, founded_year: 2002 }, { _id: ObjectId(“52cdef7c4bab8bd675297da7”), name: ‘AddThis’, category_code: ‘advertising’, founded_year: 2004 }, { _id: ObjectId(“52cdef7c4bab8bd675297da8”), name: ‘OpenX’, category_code: ‘advertising’, founded_year: 2008 }, { _id: ObjectId(“52cdef7c4bab8bd675297daa”), name: ‘Sparter’, category_code: ‘games_video’, founded_year: 2007 }, { _id: ObjectId(“52cdef7c4bab8bd675297dac”), name: ‘Veoh’, category_code: ‘games_video’, founded_year: 2004 }, { _id: ObjectId(“52cdef7c4bab8bd675297dae”), name: ‘Thoof’, category_code: ‘web’, founded_year: 2006 }
How many documents will be deleted when executing the following query?
db.companies.deleteMany( { “category_code”: “advertising” } )