Drop Database Drop Collection

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 […]

Read More

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 : […]

Read More

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 […]

Read More

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.  

Read More

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 […]

Read More

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

Read More

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 […]

Read More

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 […]

Read More

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. […]

Read More

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 […]

Read More