DBMS Questions Computer Awareness for Bank Exams

By Unknown - Tuesday, September 16, 2014 - No Comments

In SBI and IBPS Bank Exams computer related questions are asked to test the applicants knowledge on computer skills. Nowadays in computer awareness section of online bank exams, question on data base management systems are being asked. Knowledge on computer is very crucial for any competitive exams and to work on any government and private organizations it means that using of computer plays a important role in each and every organization.

Main aim of asking this type of Computer awareness questions is, in banking to access the account details like withdrawing, depositing and transferring funds the software used is data base management system. Candidates applied for SBI Clerk and PO Posts should know the computer basics and improve their computer skills on Computer Awareness.Hence in your online computer awareness test questions related to DBMS concepts will be asked. DBMS material for bank exams is designed to help for bank aspirants. Candidates should read and understand the all basic concepts of computers then only they can attend the Computer Awareness questions asked in SBI and other bank exams.

DBMS Materials provided by us will cover all topics asked in your online bank exams. . In computers DBMS means data base management system questions are asked. Keep visiting our site for more materials on data base management systems.The given Computer Awareness DBMS material consists of basic fundamental of Database management system. Materials on general awareness and computer awareness are also provided here to make your preparation easy.Here we are providing DBMS Material and in this material we cover all the DBMS topics for SBI and IBPS Bank exams. Go through our banking materials and online tests for your better performance .Applicants can study all the topics and practice more number of questions and model papers of DBMS.All the Best

Data Base Management Systems :

Data: Data is nothing but collection of information

Meta Data: The data which describes the characteristics and properties of other data is called Meta data. Simply we can say that Meta data is nothing but data about data.

Data Base: Collection of a related data with an implicit meaning is called as Data Base

Example: If you want to store details of a person i.e. Name, Phone Number, Address and Place. You will store it in a hard drive or in a software such as MS Word or MS Excel called as data base.

We can also consider a page as a data base as it is the collection of related data at one place.

So this collection of related data together at one place is called Data Base.

This information stored is accessed by application program by sending some queries.

Data Base Management System (DBMS): DBMS is a software used for maintaining and implementing the data base.

Applications of DBMS:

Banking
TeleCommunications
Credit Card Transactions
Airlines
Finance
Sales
Human Resources
Manufacturing

Data Base + DBMS = Data Base System

There are three types of actors for maintaining this data base

Data Base Administrator: Responsible for maintaining the resources

Data Base Designer: Identifies the data in data base

End User: Responsible for querying, updating and generating the reports

Advantages of DBMS:

Redundancy will be decreased
Multiple users can access at same time
Restricting Unauthorized Access
Providing Backup and Recovery

Data Base Management System (DBMS) Languages:

DDL (Data Definition Language)
DML (Data Manipulation Language)
SDL (Storage Definition Language)
VDL (View Definition Language)

Data Abstraction: An abstract view of the hidden data details of how data is stored and maintained is given in architecture in three levels or layers.

Levels of Data Abstraction: