1.Is it possible for a member function of a class to activate
another member function of the same class?
a. no
b. yes, but only public member functions.
c. Yes, only private member functions
d. Yes, both public & private member functions can be activated
2. Can 2 classes contain member functions with the same name?
a. no
b. yes, but only if the 2 classes have the same name
c. yes, but only if the main program does not declare both kinds
d. yes, this is always allowed
3.what is the purpose of template functions?
a. to allow a single function to be used with varying types of
arguments
b. to hide the same name of the function from the linker
c. to implement container classe
d. to permit the use of the debugger without the –gstabs flag
4.what kind of functions can access private member variables of a
class
a. friend function of a class
b. private member functions of the class
c. public member functions of the class
e. all of the above
f. none
5. what technique is used to step thro’ items of a container class?
a. copy constructor
b. default constructor
c. iterator (ans)
6. what is the term used to describe the situation when a derived
class provides a function already
provided in the base class ?
a. inheritning
b. overriding
c. abstraction
d. none
7. what r the characteristics of object, in general
a. it has name, properties
b. name, properties, behaviour
c. it can act on receiving a message
d. a &c
e. b&c
8. bundling data members together with the functions is called
a. data hiding
b. encapsulation (ans)
c. data morphism
d. data binding
9.why is OO programming useful?
a. It supports good s/w engg. Practices
b. It promotes thinking abt s/w in a way that models the way we think
& interact naturally
c. Supports code reuse
d. A &b
e. A,b & c
10. suppose tu want 2 develop 2 diff, + operators that calculate &
return an object of the same
class. Which stmt is correct?
a. 1 operator must be a frnd & the other must not
b. 1 operator must be public & the other private
c. operators must have different parameter lists
d. it is not possible 2 have 2 different + operators
11.what is inheritance?
a. a relationship in which the structure & functionality of a class (田hild
) is defined in terms of the
structure & functionality of another(parent)
b. a relationship in which the structure & functionality of a class (菟arent
) is defined in terms of
the structure & functionality of another(田hild )
c. a relationship in which the structure & functionality of a class
make calls 2 functionalty of
another
d. a relationship in which the structure of a class includes 1 or more
instances of another
e. all of above
12. what is relationship betn . a class & its public parent class
a. .is a .
b. 塗as a
c. 妬s implemented as a ・
d. uses a
e. becomes a
13. how does inheritance relate 2 abstraction?
A . a base class is an abstraction of all its derived classes
b. a derived class is an abstraction of all its base classes
d. Base & derived classes are abstractions for each other
e. Inheritance prevents abstration
f. No relationship betn them
14. why can’t compiler 塗ard-code direct calls to virtual functions?
a. b’coz hard –coding the fn. Call wud slow compilation of the program
too much
b. b’coz hard –coding the fn. Call wud slow execution of the program
too much
c. b’coz the correct fn. To call generally isn’t know at compile –time
d. b’coz virtual fns are always at compile-time so no run-time code is
needed at all.
e. Compiler does hard-code direct calls 2 virtual functions.
15. what is accessibility of a protected member of a base class which
is inherited privately?
a. private: b’coz the private inheritance makes everything frm the
base class private in the
derived class (ans)
DBMS
1. Indexing must be applied on fields that are
a. seldom refernced in query
b. containing few unique columns
c. on frequently searched columns
d. changed frequently
2. The relational data model includes several types of data integrity
.which type of data integrity is
ensured by the use of a primary key?
a. entity integrity
b. domain integrity
c. referential integrity
d. relational integrity
3. a student has 3 diff. Teachers . Each of these teachers has several
students. Which type of
relationship in relation model would effective represent this?
a. 3 one-to-many relationships
b. two many-to-one relationships
c. a single many-to –many relationships
d. at least 2 many-to-many relationships
4. which of the following properties are required of a column or
column sets for the column to
function as a primary key?
a. no nulls
b. a clustered index
c. a non-clustered index
d. there must be at least 1 foreign key on the same table.
5. select a.pk, fn, b.zip, c.city from a, b, c wher a.pk=b.pk
tables a,b,&c each contain 100 rows & the primary key for tables a & b
is pk. What is the maxm.
No. of rows that could be returned by query
a. 100
b. 0
c. 100,000
d. 10,000
e. 1,000,000
6. which of the following is only used with a foreign key constraint ?
a . primary key constraint
b. the refereces clause
c. a check constraint
7. which is used to return the no. of rows in a table?
a. sel;ect all count from tablename
b. select count(*) from tablename
c. select numrows from table name
8. when writing sql queries , how do u control the query execution
plan used by the databases
a. query directly against an idex instead of table
b. define a static cursor & specify the 砥sing specific index’ keyword
c. most databases provide propreitory methods to give database hint
d. enclose quey in atransaction & add a statement using the 都et search
keyword
9,. Which is not allowed in a trigger
a. update
b. select into
c. while
d. begin
10.select type, avg(price), min(price) from product group by category
what is wrong??
a. u can’t include multiple aggregates in a select list
b. there is no where clause
c. nothing
C/C++
1. when should a pointer p be a reference parameter?
a. when fn. Changes p, & u want the change to affect actual pointer
argument
b. when fn. Changes p, & u do not want the change to affect actual
pointer argument
c. when fn. Changes *p, & u want the change to affect actual pointer
argument
d. when fn. Changes *p, & u do not want the change to affect actual
pointer argument
e. when pointer points to large object
2. output???
Int y=1;
Int k=2;
Int *p1;
Int *p2;
P1=&y;
P2=&k;
p1=p2;
*p1=3
*p2=4;
printf( %d ,y);
a. 1
b. 2
c. 3
d. 4
3.when should u use a const reference parameter ??
a. whenever the data type might be many bytes
b. whenever the data type might be many bytes, the fn. Changes the
parameter within its
body, & u do not want these changes to alter the actual argument
c. whenever the data type might be many bytes, the fn. Changes the
parameter within its
body, & u DO want these changes to alter the actual argument
d. whenever the data type might be many bytes , & the function does
not change the
parameter within it body
4..6
A is a class & B is a new class derived from A
A a;
B b;
Bb1;
B b2;
4. what c++ syntax is used to declare that a class B is derived from
Class A
a. class A derives B {・};
b. class B: public A {,・..};
5. using the variable , which is legat?
a. a=b;
b. b=a;
c. b1=b2;