IBPS Recruitment Guide

Your Banking Exam Preparation Guide 2016 - 2017

DBMS Questions for IBPS Bank Exam

DATABASE MANAGEMENT SYSTEM (DBMS) | DBMS Questions for IBPS Bank Exam with Notes

DBMS Definition – A Database management system is a collection of related data of a database. DBMS system is creating for a specific purpose of data. Which database we use in DBMS software it can be of any complexity and any size.

What is Database management system?

DBMS is a collection of many programs, which is use for manage data, functions of system software. We can say that DBMS concept is system software for managing and creating databases. With the help of database management system users easily maintain data.

DBMS basics are very useful for multiple users they can easily generate the database, manipulating and controlled information in the proper way.
DBMS manages some important things- the database engine, the database which allows data to be modified and database schema.
Examples of DBMS –
MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase and IBM DB2, etc.

Types of Database management system

Different types of DBMS are as follows:-

  1. Hierarchical database
  2. Network database
  3. Relational database
  4. Object – oriented database

1. Hierarchical Database
In the hierarchical database, one data is subordinate of another data which represents a relationship between parent and child.
2. Network database
Network database poses a relationship between many to many data of the database. It is a structure in a form of the graph.
3. Relational database
It is also called RDBMS. RDBMS shows three relations between relationship, domain and attributes. In RDBMS, we used rows and columns for database structure.
4. Object – oriented database
The object-oriented database consists two object elements a piece of data and instructions. But they are costly for develop.

Advantages of database

A) In DBMS ADVANTAGE, we can Easily store data and manage at overhead level.
B) DBMS provide access programs with end users and application.
C) DBMS using same data while managing database data integrity.
D) Data security level performance is in an excellent manner.
E) In DBMS simple access to (API) application programming interface.
F) Robust data easily and integrity of capabilities.

Disadvantages of DBMS

A) The complexity of the functionality makes a complex piece of software.
B) The size of complexity makes many of software which occupy many megabytes.
C) Sometimes its performance is very typical to create.
D) The cost of DBMS is higher for structured.

Functions of Database Management System

Database management system essential concepts are based on features of DBMS.

  • In DBMS hardware using for keeping files and manage. DBMS include many machines for designed to support system of the database.
  • DBMS include many data dictionaries for management which are use for storing data and transformation.
  • Data security management is also a function. Which is use for many of data integrity?
  • Database management system functions provide multiple users to access and control.
  • Database management tool provides data recovery and backup safety.
  • Database management system importance is a must for management software data in a computer.

List of DBMS Software

Here are some important database technologies which are use for managing database tool list of database management system are as follows-

  1. IBM DB2
  5. SAP Sybase ASE
  6. MySQL
  8. FileMaker
  9. Microsoft Access
  10. Informix

Share this article with your friends. If you want to say something we love comments. Tell us anything about DBMS, which is not included in this article or any suggestion or query. Check other related study material of banking exams.

Latest Bank Exam Updates
Bank PO Exam Updates Bank Exam SyllabusGK for Bank Exam
Bank Clerk Exam UpdatesBank Exam PatternBank Tips – Tricks
Bank SO Exam UpdatesBank Preparation BooksBank Exam Results
RRB Exam UpdatesApply Online for Bank ExamIBPS Negative Marking
Bank Exam UpdatesBank Question PapersParticipating Banks
IBPS Exam DatesBank Study MaterialBank Admit Card


Add a Comment
  1. 121,16,49,169,256 I want this solution sir

  2. Sir please send more practice questions of IT officer and please say the analysis of previous years of proffesional knowledge such as easy,hard basics how many questions etc.
    My mail id is venkatasuryatejadarisa8@gmail.com

  3. sir please send a previous year ibps exam paper to my mail id

  4. sir…. please send the previous years question paper of ibps p.o. exam at sonali.shambhavi@gmail.com…..thank you for this post of database management system

  5. pls send me previous year itofficer question papers

  6. please send study materials for professoinal knowledge for SO TO mail id mounika045208@gmail.com

  7. plz send me previous question papers.

  8. please send it officer previous year question papers to my mail id. arunvelamannoor@gmail.com

  9. Sir plz send me previous year solved question paper of ibps it officer exam.

  10. sir/mam please send the previous year question papers to my maid id

  11. sir please send me the previous solved question paper for it officer

  12. Sir,please send IT officer solved question papers

  13. plz send ibps it officer previous year paper.

  14. Sir,please send IT officer solved question papers

  15. please send it officer previous year question papers to my mail id.

  16. plz send itofficer previous year question papers to my mail id.

  17. Thanks for the post..!

Leave a Reply

Your email address will not be published. Required fields are marked *

IBPS Recruitment Guide © 2014 -2016 All rights reserved. Disclaimer Privacy Sitemap Advertise