11.
Which of the following cannot be passed to a
function in C++?

(1) Constant

(2) Structure

(3) Array

(4) Header file

Answer: 4

12.
Which one of the following is correct for
overloaded functions in C++?

(1) Compiler sets up a separate function for
every definition of function.

(2) Compiler does not set up a separate
function for every definition of function.

(3) Overloaded functions cannot handle different
types of objects.

(4) Overloaded functions cannot have same
number of arguments.

Answer: 1

13.
Which of the following storage classes have
global visibility in C/C++?

(1) Auto

(2) Extern

(3) Static

(4) Register

Answer: 2

14.
Which of the following operators cannot be
overloaded in C/C++?

(1) Bitwise right shift assignment

(2) Address of

(3) Indirection

(4) Structure reference

Answer: 4

15.
If X is a binary number which is power of 2,
then the value of

X&(X-1) is:

(1) 11....11

(2) 00.....00

(3) 100.....0

(4) 000.....1

Answer: 2

16.
An attribute A of datatype varchar(20) has
value 'Ram' and the attribute B of datatype char(20) has value 'Sita' in
oracle. The attribute A has .......... memory spaces and B has ..........
memory spaces.

(1) 20, 20

(2) 3, 20

(3) 3, 4

(4) 20, 4

Answer: 2

17.
Integrity constraints ensure that changes
made to the database by authorized users do not result into loss of data
consistency. Which of the following statement(s) is (are) true w.r.t. the
examples of integrity constraints?

(A) An instructor Id. No. cannot be null,
provided Instructor Id. No. being primary key.

(B) No two citizens have same Adhar-Id.

(C) Budget of a company must be zero.

(1) (A), (B) and (C) are true.

(2) (A) false, (B) and (C) are true.

(3) (A) and (B) are true; (C) false.

(4) (A), (B) and (C) are false.

Answer: 3

18.
Let M and N be two entities in an E-R diagram
with simple single vale attributes. R

_{1}and R_{2}are two relationship between M and N, whereas
R

_{1}is one-to-many and R_{2}is many-to-many.
The minimum number of tables required to
represent M, N, R

_{1}and R_{2}in the relational model are ..........
(1) 4

(2) 6

(3) 7

(4) 3

Answer: 4

19.
Consider a schema R(MNPQ) and functional
dependencies M→N, P→Q. Then the decomposition of R into R

_{1}(MN) and R_{2}(PQ) is .............
(1) Dependency preserving but not lossless
join.

(2) Dependency preserving and lossless join

(3) Lossless join but not dependency
preserving

(4) Neither dependency preserving nor
lossless join.

Answer: 1

20.
The order of a leaf node in a B+ tree is the
maximum number of children it can have. Suppose that block size is 1 kilobytes,
the child pointer takes 7 bytes long and search field value takes 14 bytes
long. The order of the leaf node is ............

(1) 16

(2) 63

(3) 64

(4) 65

Answer: Marks to all

## 2 Comments

Question 15 answer 3

ReplyDeleteQuestion 20 answer 3

ReplyDelete