Sample Paper
1) The order of an internal node in a B+ tree index is the maximum number of children it can have. Suppose that a child pointer takes 6 bytes, the search field value takes 14 bytes, and the block size is 512 bytes. What is the order of the internal node?
Options
A) 24 B) 25
C) 26 D) 27
Correct Answer C
2) The Boolean function x, y, + xy + x, y
Options
A) x, + y, B) x + y
C) x + y, D) x, + y
Correct Answer D
3) In an MxN matrix such that all non-zero entries are covered in a rows and b columns. Then the maximum number of non-zero entries, such that no two are on the same row or column, is
Options
A) £ a + b B) £ max {a, b}
C) £ min {M-a, N-b} D) £ min {a, b}
Correct Answer A
4) The relation scheme Student Performance (name, courseNo, rollNo, grade) has the following functional dependencies:
name, courseNo ® grade
rollNo, courseNo ® grade
name ® rollNo
rollNo ® name
The highest normal form of this relation scheme is
Correct Answer A
5) The minimum number of page frames that must be allocated to a running process in a virtual memory environment is determined by
Options
A) the instruction set architecture B) page size
C) physical memory size D) number of processes in memory
Correct Answer D
For Download More Sample Papers
Click here