DBMS MCQs Test 3

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

Q. If a field size is too small for the longest piece of data to be entered, then __________.
Q. Which of the following is(are) logical database structure?
Q. Which of the following is not a Relational data model of DBMS?
Q. Given relations r(w, x) and s(y, z), the result of the below query is guaranteed to be the same as r, provided :
SELECT DISTINCT w, x from r, s;

Q. The employee salary should not be greater than Rs. 2000. This is __________?
Q. Manager's salary details are hidden from the employees. This is __________?
Q. Trigger is a __________.
Q. With regards to the expressive power of the formal Relational Query Languages, which of the following is true for Relational Algebra?
Q. If Adjacency Relation of vertices in a graph is represented in a table Adj(x, y), then which of the following queries cannot be expressed by a relational algebra expression of constant length?

Q. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
Q. Updating a database means __________.
Q. Which of the following is a Data Dictionary software package?
Q. Which of the following statement is true for a Logical Schema
Q. Subschema can be used to __________.
Q. A data dictionary is a special file that contains __________.