UGC NET COMPUTER SCIENCE SOLVED PAPERS 2014-16 - UGC NET Computer Science Paper 2 December 2015

19. Data which improves the performance and accessibility of the database are called:

  • Option : A
  • Explanation : Data which improves the performance and accessibility of the database are called indexes because index is a type of any data which improves the lookup table. Simply we can say that an index is a pointer to data in a table which increases the accessibility in a book or databases, we can easily access any information with the help of index. Option (A) is correct
Cancel reply
Cancel reply

20. A relation R = {A, B, C, D, E, F,G} is given with following set of functional dependencies: F = {AD → E, BE → F, B → C, AF → G} Which of the following is a candidate key ?

  • Option : D
  • Explanation : [AD]+ = ADE. [BE]+ = BCEF. [B]+ = BC. [AF]+ = AFG. Nothing drives all the attributes, but if We add B in first key i.e. [ADB] then it will give all the attribute [ADB]+ = ABCDEFG. So, option (D) is correct.
Cancel reply
Cancel reply