UGC-NET | UGC NET CS 2016 July – II | Question 17

Which of the following statement(s) is/are FALSE in the context of Relational DBMS ?
I. Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data in the database.
II. E-R diagrams are useful to logically model concepts.
III. An update anomaly is when it is not possible to store information unless some other, unrelated information is stored as well.
IV. SQL is a procedural language.
(A) I and IV only
(B) III and IV only
(C) I, II and III only
(D) II, III and IV only


Answer: (D)

Explanation:

• Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data in the database.Correct
• E-R diagrams are useful to logically model concepts.Inorrect
• An update anomaly is when it is not possible to store information unless some other, unrelated information is stored as well.Inorrect
• SQL is a procedural language.Inorrect

So, option (D) is correct.


Quiz of this Question