Computer Quiz (DBMS) for RRBs/IBPS Exam

Q1. Which of the following is/are the primary feature(s) of DBMS?  
(a) To provide an environment that is congenial to user 
(b) To store the information 
(c) To retrieve information 
(d) All of the above 
(e) None of the above 

Q2. Disadvantage of DBMS is/are:  
(a) Integrity 
(b) Complexity 
(c) Data sharing 
(d) Security 
(e) Recovery 

Q3. A database management system _____
(a) Allows simultaneous access to multiple files 
(b) Can do more than a record management system 
(c) Is a collection of programs for managing data in a single file 
(d) Both (a) and (b) 
(e) None of the above 

Q4. A ______ consists of a collection of interrelated data and a collection of programs to access that data.  
(a) Database 
(b) Schema 
(c) DBMS
(d) DBA
(e) None of these 

Q5. The most popular commercial DBMS is________ .   
(a) Microsoft SOL Server 
(b) Microsoft Access 
(c) MySQL 
(d) Oracle 
(e) None of the above 

Q6. It is better to use files than a DBMS when there is/are – 
(a) Stringent real time requirements 
(b) Complex relationship among data 
(c) Multiple users wish to access the data 
(d) All of the above 
(e) None of the above 

Q7. Redundancy is dangerous as it is a potential threat to data _____________ 
(a) Integrity 
(b) Consistency 
(c) Sufficiency 
(d) Both (a) and (c)
(e) None of these 

Q8. A relationship database consists of a collection of – 
(a) Tables 
(b) Fields 
(c) Records 
(d) Keys 
(e) None of these 

Q9. A ______ in a table represents a relationship among a set of values. 
(a) Column 
(b) Key 
(c) Row 
(d) Entry 
(e) None of these 

Q10. The term ______ is used to refer to a row.   
(a) Attribute 
(b) Tuple 
(c) Field 
(d) Instance 
(e) None of these 

Q11. Which language can be used by a user to request the information from a database?  
(a) Query 
(b) Relational 
(c) Structural 
(d) Complier 
(e) None of these 

Q12. In E-R diagram, derived attribute(s) is/are represented by –
(a) Ellipse 
(b) Dashed ellipse 
(c) Rectangle 
(d) Triangle 
(e) None of these 

Q13. In E-R diagram, generalization is represented by – 
(a) Ellipse 
(b) Dashed ellipse 
(c) Rectangle 
(d) Triangle 
(e) None of these 

Q14. In E-R diagram, relationship is represented by  
(a) Ellipse shaped 
(b) Dashed ellipse shaped 
(c) Rectangle shaped 
(d) Diamond shaped 
(e) None of these 

Q15. Which of the following hardware component is/are the most important for the operation of database management system?
(a) High resolution video display
(b) Printer
(c) High speed, large capacity disk
(d) Plotter
(e) Mouse