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
Answer: B
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+
Answer: D
33. In a heap, every element is …………… of all the elements in the subtree.
(A) maximum
(B) minimum
(C) sum
(D) product
Answer: A
34. If (rear==maxsize-1) rear=0; else rear=rear+1; is required in:
(A) circular queue
(B) linear queue
(C) stack
(D) deque
Answer: D
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
(B) ADSL
(C) SONET
(D) None of the above
Answer: A
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
Answer: A
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
Answer: C
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
Answer: D
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)
Answer: D
40. Which of the following OS treats hardware as a file system?
(A) UNIX
(B) DOS
(C) Windows NT
(D) None of the above
Answer: A
0 Comments