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

>>>>>>>>UGC NET Computer Science Paper 2 December 2015

• A

pn  • B

p  • C

(2n-1)p+1  • D

(p+1)n  • Option : D
• Explanation :
(a) What is the maximum number of cells possible in the base cuboid? pn.
This is the maximum number of distinct tuples that you can form with p distinct values per dimensions.
(b) What is the minimum number of cells possible in the base cuboid? p.
You need at least p tuples to contain p distinct values per dimension. In this case no tuple shares any value on any dimension.
(c) What is the minimum number of cells possible in the data cube, C? (2n-1)×p+1.
The minimum number of cells is when each cuboid contains only p cells, except for the apex, which contains a single cell.
(d) What is the maximum number of cells possible (including both base cells and aggregate cells) in the data cube, C? (p+1)n.
The argument is similar to that of part (a), but now we have p+1 because in addition to the p distinct values of each dimension we can also choose ∗.

• A

0.01%  • B

0.02%  • C

0.04%  • D

0.05%  • Option : B
• Explanation :
The computation is based on the simplified Bayes’ formula.
P{B|A} = (P{A|B}·P{B) / P{A}.
P{M|S} = probability that a person had meningitis, conditioned by the existence of stiff neck.
P{S|M} = probability that a person complains about stiff neck, conditioned by the existence of meningitis. = 50%=1/2
P{S} = proportion of people who complain about stiff neck. = 1/20
P{M} = proportion of people who had meningitis. = 1/50,000
Then:
P{M|S} = (P{S|M}·P{M}) / P{S} =( 1 / 2 x 1 / 50,000 ) / 1 / 20 = 0.0002 = 0.02%

• A

OLTP  • B

OLAP  • C

Data System  • D

Market System  • Option : B
• Explanation :
• OLAP(Online application program) system is market oriented and is used for data analysis by knowledge workers including Managers, Executives and Analysts.
• OLTP (online transaction processing) is a class of software programs capable of supporting transaction-oriented applications on the Internet.
• Data system is a term used to refer to an organized collection of symbols and processes that may be used to operate on such symbols
• A market system is the network of buyers, sellers and other actors that come together to trade in a given product or service
• So, option (B) is correct.

• A

The Top - Down View  • B

Data Warehouse View  • C

Datasource View  • D

Business Query View  • Option : A
• Explanation :
• The Top down view allows selection of the relevant information necessary for the data warehouse.
• Data Warehouse View contains fact tables and dimension tables
• Datasource View it shows the the information which was gathered, stored and managed by operational system
• Business Query View It shows the view of date in warehouse from end user point of view.
• So, option (A) is correct.

• A

h (k, i) = (h1(k) + h2(k) + i) mod m  • B

h (k, i) = (h1(k) + h2(k) - i) mod m  • C

h (k, i) = (h1(k) + i * h2(k)) mod m  • D

(D) h(k, i)=(h1(k)-ih2(k))mod m  • Option : C
• Explanation :
h(k, i) = (h1(k) + i * h2(k)) mod m is used in double hashing is of the form. Rest other option does not used in double hashing. So, option (C) is correct.