DBMS MCQs Test 4

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

Q. Queries to a database __________.
Q. Data integrity control __________.
Q. Information can be transferred between DBMS and __________.
Q. A race condition occurs when __________.

Q. Addresses are considered __________.
Q. A data is often entered in a format such as 81/12/30 because __________.
Q. Which of the following contains complete record of all activity that affected the contents of a database during a certain period of time?
Q. In a Multiuser database, if two users wish to update the same record at the same time, they are prevented from doing so by __________.
Q. A relational database management(RDBM) package manages data in more than one file at once. It organize these files as __________.

Q. The PROJECT command will create a new table that has __________.
Q. A report generator is used to __________.
Q. Let domain set of an attribute consists of signed four digit numbers. What is the percentage of reduction in storage space of this attribute if it is stored as an integer rather than in character form?
Q. Which of the following is correct?
Q. Let R = (A, B, C, D, E, F) be a relational schema with the below mentioned dependencies. Which of the following is a key for R?
C -> F, E -> a, EC -> D, A -> B
Q. Which normal form is considered adequate for normal relationship database design?