DBMS MCQs Test 1

This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.

Q. Consider Join of a relation R with a relation S. If R has m tuples and S has n tuples, then maximum and minimum sizes of the Join respectively are
Q. For two union compatible relations R1(A, B) and R2(C, D), what is the result of the operation R1 A=C AB=D R2?
Q. Relations produced from an E-R model will always be in __________.
Q. A primary key, if combined with a foreign key creates __________.

Q. Network models are complicated by physical keys, but the Relation model is __________?
Q. A Relational model which allows non-atomic domains is __________.
Q. Which of the following is not true for the traditional approach to information processing?
Q. The database environment has all the following components except __________.
Q. The way a particular application views the data from the database that the application uses is a __________.

Q. Which of the following is true about Data Manipulation Language(DML)?
Q. The relational model uses some unfamiliar terminology. A tuple is a equivalent to __________.
Q. Database administrator is, in effect, the coordinator between __________ and __________.
Q. A network structure __________.
Q. An advantage of the database approach is __________.
Q. Which of the following hardware components is the most important to the operation of a database management system?