UGC NET COMPUTER SCIENCE SOLVED PAPERS 2014-16 - UGC NET Computer Science Paper 3 July 2016

6. In _____ method, the word is written to the block in both the cache and main memory, in parallel.

  • Option : A
  • Explanation :
    In write through method, the word is written to the block in both the cache and main memory, in parallel and in write back method the word is written to the block in cache but actual update into the corresponding location in main memory only at specified intervals or under certain conditions. In Write Protected cache policy word cannot be modified or deleted. In direct mapping block M of main memory maps into block M modulo n of the cache, where n is the total number of blocks in cache. So, option (A) is correct.
Cancel reply
Cancel reply

7. Which of the following statements concerning Object-Oriented databases is FALSE?

  • Option : C
  • Explanation :
  • Objects in an object-oriented database contain not only data but also methods for processing the data.Correct
  • Object-oriented databases store computational instructions in the same place as the data.Correct
  • Object-oriented databases are more adapt at handling structured (analytical) data than relational databases.Incorrect
  • Object-oriented databases store more types of data than relational databases and access that data faster.Correct
  • So, option (C) is correct.
Cancel reply
Cancel reply

10. Which of the following statements is TRUE?
D1 : The decomposition of the schema R(A, B, C) into R1(A, B) and R2 (A, C) is always lossless.
D2 : The decomposition of the schema R(A, B, C, D, E) having
AD → B,
C → DE,
B → AE and
AE → C,
into R1 (A, B, D) and R2 (A, C, D, E) is lossless.

  • Option : D
  • Explanation :
    only D2 is True because AD is key and present in both the tables. D1 is not always true because FD’s not given and if we take B->A and C->Athen it is lossy decomposition because no common attributes contain key from one of the table.
Cancel reply
Cancel reply