UGC NET COMPUTER SCIENCE SOLVED PAPERS 2014-16 - UGC NET Computer Science Paper 2 JULY 2016

16. In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:

  • Option : C
  • Explanation :
  • In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as Entity Interity
  • Referential integrity states that table relationships must always be consistent.
  • Multi-valued dependencyis a full constraint between two sets of attributes in a relation
  • Functional dependency is a relationship that exists when one attribute uniquely determines another attribute.
  • So, option (C) is correct.
Cancel reply
Cancel reply

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.

  • Option : 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.
Cancel reply
Cancel reply