Follow Us :

PREVIOUS YEAR SOLVED PAPERS - JULY 2016 Paper 2

Avatto > > UGC NET COMPUTER SCIENCE > > PREVIOUS YEAR SOLVED PAPERS > > JULY 2016 Paper 2

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

18. In a relational database model, NULL values can be used for all but which one of the following ?

Cancel reply
Cancel reply

19. Consider the following two commands C1 and C2 on the relation R from an SQL database :
C1 : drop table R;
C2 : delete from R;
Which of the following statements is TRUE ?
I. Both C1 and C2 delete the schema for R.
II. C2 retains relation R, but deletes all tuples in R.
III. C1 deletes not only all tuples of R, but also the schema for R.

Cancel reply
Cancel reply

20. Consider the following database table having A, B, C and D as its four attributes and four possible candidate keys (I, II, III and IV) for this table : I : {B} II : {B, C} III : {A, D} IV : {C, D} If different symbols stand for different values in the table (e.g., d1 is definitely not equal to d2), then which of the above could not be the candidate key for the database table ?

ABCD
a1b1c1d1
a2b3c3d1
a1b1c1d2

Cancel reply
Cancel reply
Related Quiz.
JULY 2016 Paper 2