DBMS Questions for IBPS Bank Exam - In this article, we provided the study material of DBMS for the IBPS exam.You can answer the question based on topic. Candidate those who are preparing for the IBPS Exam (Clerk, PO, SO) and others can use these tricks. Candidate can do download in PDF format.
What is DBMS(डेटाबेस प्रबंधन प्रणाली)
DBMS(डेटाबेस प्रबंधन प्रणाली) :A database is a planned collection of data. It is the collection of schemes, tables, queries, reports, views, and other objects. The data are classically organized to model aspects of reality in a way that supports processes requiring information, such as modeling the availability of rooms in hotels in a way that supports finding a hotel with vacancies.
Data –It is any input which has been processed. It can be in numeric, alphabetic or alphanumeric form.
Database –It is simply a location where all the data are collected and stored in an organized manner.
Management system – In government officers, there are peons who are responsible for keeping the files in the right place, bringing required files to the senior officers, putting it back again after updating the files etc., this is nothing but the system of file management in the office.
Simply DBMS is a software,
(i) which helps a user in creating a collection of records and information and storing them on the computer in a systematic way (database),
(ii) it also helps in organizing, sorting and retrieval of the records/information from the database, when required by the user, to help the user in decision making (management system).
Types of Database management system
Different types of DBMS are as follows:-
- Hierarchical database
- Network database
- Relational database
- Object – oriented database
Applications of DBMS
There are some applications or areas of DBMS:-
Banking: Banks uses database for all details of customer accounts, loans and other transactions.
Airlines: Airlines uses online database for reservation, arrival and departure of the planes, schedule information etc.
Education: Schools, colleges and universities use database for course details, registration, examination details, result etc.
Credit card transactions: It is used to keep track of purchases on credit cards to generate statements.
Telecommunications: Telecommunication department uses database to store information about telephone numbers, details of calls, generating bills etc.
E-commerce: It uses online databases for buying and selling of products, online transaction processing, internet marketing etc.
Finance: It uses database for storing information such as sales, stocks, bonds etc.
Sales: it uses databases for storing product details, transaction and customer details.
Human resources: Organizations use databases for storing information about employees, salaries, tax, salary checks etc.
Benefits of DBMS
- Faster storage and retrieval time.
- Accessing data is easy and fast
- Data integrity (credibility of the data) and security.
- Backups and recovery are possible only in digital world.
Limitations of DBMS
- The difficulty of the functionality makes a complex piece of software.
- Size of difficulty makes many of software which inhabits many MBs.
- Sometimes its performance is very typical to create.
- The cost of DBMS is higher for structured.
Functions of DBMS
There are some functions of DBMS are as follows :-
- Data Dictionary Management.
- Data Storage Management.
- Data Transformation and Presentation.
- Security Management.
- Multi user Access Control.
- Backup and Recovery Management.
- Data Integrity Management.
- Database Access Languages and Application Programming Interfaces .
- Database Communication interfaces.
List of DBMS Software
Here are some important databases tools which are used for handling database tool list of database management system are as follows-
- IBM DB2
- ORACLE RDBMS
- MICROSOFT SQL SERVER
- SAP Sybase ASE
- Microsoft Access