Drop collection from database in mongoDB db.collection.drop() is used to drop a collection from the database. Syntax: db.collection.drop() use TEST show collections <——— check the available collections into your database TEST. db.student.drop() <——– Check and verify the student collection has been drop from TEST Database. Drop Database in mongoDB db.dropDatabase() command […]
Monthly Archives: July 2018
CRUD Operations
CRUD operations create, read, update, and delete documents as same like in RDBMS (Select and DMLs). Firstly knows how to create database in mongoDB MongoDB use DATABASE_NAME is used to create database. The command will create a new database if it doesn’t exist, otherwise it will return the existing database. Execute simple command : […]
Terminology with MongoDB
Database Database is a physical container for collections. Each database gets its own set of files on the file system. A single MongoDB server typically has multiple databases. Collection A grouping of MongoDB documents. A collection is the equivalent of an RDBMS table. A collection exists within a single database. Collections do not enforce a […]
MongoDB Installation
MongoDB Provide two types of software. Community Edition : Its For freeware no mongo support available on this. Enterprise Edition : Its License Based. For More Detail about Installation and Packages and Environment Support : Click Here For any query regarding MongoDB installation/Upgrade feel free contact to Oracle-Help Team.
Advantage of mongodb as compare to SQL database
The MongoDB data bases on the JSON (Java Script Object Notation) format. JSON allows for the transfer of data between web applications and servers using a human readable format. Before JSON, XML was used for this. JSON is defined in MongoDB’s BSON (Binary JSON). The binary format of BSON provides reliability and greater efficiency when […]
Overview of MongoDB Collection and Documnets
MongoDB works on concept of collection and document. RDBMS MongoDB Database Database Table Collection Tuple/Row Document column Field Table Join Embedded Documents Primary Key Primary Key (Default key _id provided by mongodb itself) Database Server and Client Mysqld/Oracle mongod mysql/sqlplus mongo
What is MongoDB ?
MongoDB is open source database system. It’s a document database with the scalability and flexibility that you want with the querying and indexing that you need. Its support to Dyanmic schema, using a map-reduce, GeoSpatial support the main feature. MongoDB stores data in flexible, JSON-like documents, meaning fields can vary from document to document and […]
New feature in Oracle 11g database to kill session
Now we can kill session after finishing existing transaction to be finished. Means in previous release there was no scope to finish on going transaction. Instead of “alter system kill session” here we can use “alter system disconnect session”. Using syntax “POST_TRANSACTION” we can kill session for active transaction has to be completed first and […]
Feature Enable In Oracle
Note: Just illustration for fun It in fact violates the license. This is only study purpose. All Features are enable in EE (Enterprise Edition). Actually some features not enabled, if you are using Oracle SE (Standard Edition). Follow the point to see the feature is enable or not in (SE) . In my case 1. […]
Oracle Exadata X5 Administration (1Z0-070)
Hi Readers Finally, I’ve successfully passed 1Z0-070, Oracle Exadata X5 Administration. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 90 questions related to Exadata X5 and X6. To earn this certification you need to get 60% marks. This was the result of the journey: Oracle Certified Expert, Oracle […]