December 2015 - Paper 2

31:  

................. system is market oriented and is used for data analysis by knowledge workers including Managers, Executives and Analysts.

A.

OLTP

B.

OLAP

C.

Data System

D.

Market System

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



32:  

.................. allows selection of the relevant information necessary for the data warehouse.

A.

The Top-Down View

B.

Data Warehouse View

C.

Data source View

D.

Business Query View

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



33:  

The hash function used in double hashing is of the form:

A.

h(k, i)=(h 1 (k)+h 2 (k)+i)mod m

B.

h(k, i)=(h 1 (k)+h 2 (k)-i)mod m

C.

h(k, i)=(h 1 (k)+ih 2 (k))mod m

D.

h(k, i)=(h 1 (k)-ih 2 (k))mod m

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



34:  
In the following graph, discovery time stamps and finishing time stamps of Depth First Search (DFS) are shown as x/y where x is discovery time stamp and y is finishing time stamp.
december 2015 cbse ugc net computer science paper
It shows which of the following depth first forest?
A.

{a,b,e} {c,d,f,g,h}

B.

{a,b,e} {c,d,h} {f,g}

C.

{a,b,e} {f,g} {c,d} {h}

D.

{a,b,c,d} {e,f,g} {h}

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



35:  
The number of disk pages access in B-tree search, where h is height, n is the number of keys, and t is the minimum degree, is:
A.

θ(log n  h*t)

B.

θ(log t  n*h)

C.

θ(log h  n)

D.

θ(log t  n)

 
 

Option: D

Explanation :

Click on Discuss to view users comments.

Write your comments here: