# UGC NET Computer Science Questions Paper II December 2008 - Part 4

31.       Aggregation is:
(A) an abstraction through which relationships are treated as lower level entities
(B) an abstraction through which relationships are treated as higher level entities
(C) an abstraction through which relationships are not treated at all as entities
(D) none of the above
32.       Suppose R is a relation schema and F is a set of functional dependencies on R. Further, suppose R1 and R2 form a decomposition of R. Then the decomposition is a lossless join decomposition of R provided that:
(A) R1∩R2→R1 is in F+
(B) R1∩R2→R2 is in F+
(C) both R1∩R2→R1 and R1∩R2→R2 functional dependencies are in F+
(D) at least one from R1∩R2→R1 and R1∩R2→R2 is in F+
33.       In a heap, every element is …………… of all the elements in the subtree.
(A) maximum
(B) minimum
(C) sum
(D) product
34.       If (rear==maxsize-1) rear=0; else rear=rear+1; is required in:
(A) circular queue
(B) linear queue
(C) stack
(D) deque
Explanation:
A double-ended queue (dequeue, often abbreviated to deque) is an abstract data type that generalizes a queue, for which elements can be added to or removed from either the front (head) or back (tail). It is also often called a head-tail linked list.
35.       A high performance switching and multiplexing technology that utilizes fixed length packets to carry different types of traffic is:
(A) ATM
(C) SONET
(D) None of the above

36.       A conventional LAN bridge specifies only the functions of OSI:
(A) layers 1 and 2
(B) layers 1 through 3
(C) all layers
(D) none of the above
37.       An assembly program contains:
(A) imperative and declarative statements
(B) imperative and assembler directives
(C) imperative and declarative statements as well as assembler directives
(D) declarative statements and assembler directives
38.       In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of register?
(A) absolute mode
(B) immediate mode
(C) indirect mode
(D) index mode
39.       Which of the following are Assembler Directives?
(i) EQU
(ii) ORIGIN
(iii) START
(iv) END
(A) (ii), (iii) and (iv)
(B) (i), (iii) and (iv)
(C) (iii) and (iv)
(D) (i), (ii), (iii) and (iv)