grapecity

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



www.sureshkumar.net

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?





www.sureshkumar.net

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.

3. 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



4. 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 relationshjips

d. at least 2 many-to-many relationships



5. 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. ther must be atleast 1 foreign key on tha same table.





www.sureshkumar.net



6.

7. 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



8. which of the following is only used with a foreign key constraint ?

a . primary key constraint

b. the refereces clause

c. a check constraint



9. 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



10.

11. 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



12.

13.

14,. Which is not allowed in a trigger

a. update

b. select into

c. while

d. begin



15.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++







www.sureshkumar.net

1. when shud apointer 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 shud u use a const reference paprameter ??

a. whenever the data type might be many bytes

b. whenever the data type might be many bytes, the fn. Changes the papramter 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 papramter within its

body, & u DO want these changes to alter the actual argument

d. whenevr 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;