Explore topic-wise InterviewSolutions in Current Affairs.

• use admin

• use test

• Change Streams

• Search in a MongoDb Database: 

db.comments.find({lang:'Python'})

• Showing All Collections in a Database: 

db.getCollectionNames()

• Listing a Collection’s Records: 

db.collectionname.find()

• Listing Records with Matching Values of Specific Fields: 

db. collectionname.find({"field2": "secondmatching value"})

• Multiple Matching Values:

db. collectionname.find({"field2": "second matching value", "field3": "thirdmatchingvalue"})

• Finding a Single Record:

db. collectionname.findOne({"field2": "content"})

MongoDB is one of the world’s most popular document databases. It has some powerful capabilities like full-text search, data aggregation etc. One should have a solid knowledge of what MongoDB is. In this document, we’ve covered the basics of MongoDB, its features, and some of the important cheat sheets. We’ve also explored the common database operations of MongoDB. Now, it’s time for you to head out and try what we’ve covered here and more.

• Technical Interview Questions


• Coding Interview Questions


• Interview Resources


• DSA- Programming


• Mock Interview


• MongoDB Vs MySQL

• 
  Drop: db.docx.drop()    // removes the collection and its index definitions
  


• Create Collection:

• 
  Other Collection Functions
  
  
  • In order to create a statistical structure and to copy a pointer into a user-specified memory location, use: db.docx.stats() 
    
  
  
  • The total amount of storage in bytes allocated to the document for document storage can be known by using: db.docx.storageSize()
    
  
  
  • To report the total size used by the indexes in a collection document, use: db.docx.totalIndexSize()
    
  
  
  • The total size in bytes of the data in the collection plus the size of every index can be known by using: db.docx.totalSize()
    
  
  
  
  

• 
  List Indexes: It can be done by using: db.docx.getIndexes()
  


• Create Index

• 
  Drop Index: db.docx.dropIndex("name_3")
  


• 
  Hide/Unhide Indexes
  • To Hide: db.docx.hideIndex("name_3")
    
  
  


• To Unhide: db.docx.unhideIndex("name_3")
  


• 
  Creating a compound index: db.docx.ensureIndex({name : 3, operator : 1, class : 0})
  


• 
  Dropping a compound index: db.docx.dropIndex({name : 3, operator : 1, class : 0})
  

The MongoDB shell provides the following method to update row:

To update multiple document, use:

db.docx.update({"category": "Information"}, {$set: {"category": 'Sports'}})

A document stored in the database can be changed using one of several update methods: updateOne, updateMany, and replaceOne. 

updateOne and updateMany take a filter document as their first parameter and a modifier document, which describes changes to make, as the second parameter. 

Command: db.docx.updateOne({"_id": 2}, {$set: {"title": 'revised title'}})

To limit the number of rows, use:

db.docx.find().limit(5).pretty()

To count number of rows, use:

db.docx.find().count()

The MongoDB shell provides the following methods to sort rows:

To delete a row, use: 

db.docx.remove({ title: 'Post six' })

deleteOne and deleteMany can be used for this purpose. Both of these methods take a filter document as their first parameter.

db.docx.deleteOne({"_id" : 6})

To find a row, use- 

db.docx.findOne({ category: 'Science' })

The MongoDB shell provides the following methods to find documents using operators:

The MongoDB shell provides the following methods to find documents:

The MongoDB shell provides the following methods to insert multiple rows:

The MongoDB shell provides the following methods to insert rows:

The MongoDB shell provides the following methods to insert documents into a collection:

db.dropDatabase()

 use acme

db

show dbs