UGC NET COMPUTER SCIENCE SOLVED MODEL PAPER FOR JUNE 2014
1. What is the
difference between normalized data and denormalised data.
Normalised data
means it has many tables and few columns per table.
Denormalised data
means it has few tables, many columns per table.
2. Analysis of
large database to retrieve information is called as
OLAP
(On-Line Analytical Processing).
3.
What is meant by deferred update.
It
is the process in which all the log files entries are made first but the actual
updates are done later.
4.
What is a recursive foreign key.
It
is a key which references its own relation.
