Technicalsymposium.com - New Updates Alerts-Subscribe


Our Telegram Channel - Join Us


Our Free Email Alerts - Join Us



Important Note:Login & Check Your
Email Inbox and Activate Confirmation Link

Our Whatsapp Group - Join Us



Download Free Placement Materials with Answers





Free Placement Papers PDF





1. Indexing must be applied on fields that are

a. seldom referenced 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 relationships 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. there must be at least 1 foreign key on the same table.

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 references clause c. a check constraint

9. which is used to return the no. of rows in a table?

a. select all count from table name b. select count(*) from table name c. select num rows from table name

11. when writing sql queries, how do u control the query execution plan used by the databases

a. query directly against an index instead of table b. define a static cursor & specify the "using specific index" keyword c. most databases provide proprietary methods to give database hint d. enclose quey in a transaction & add a statement using the "set search" keyword

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

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

a. whenever the data type might be many byteshttp://Friends

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

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 legal?

a. a=b;

b. b=a;

c. b1=b2;

d. both a & b are legal but not c;

e. both a & c are legal but not b;

f. both b & c are legal, but not a;

6. suppose there are 2 fns. F has an argument of type A and g has an argument of type B. Which is correct?

a. both f(a) & g(a) are legal fn. Calls b. f(a) is legal, but g(a) is not legal c. f(a) is not legal, g(a) is legal d. neither f(a) nor g(a) is legal fn call

7. template

void foo(Item x);

which is right way to call with integer argument I?

a. foo(i); b. foo (i); c. foo(i);

d. foo( i); e. foo( i);



Source: Contents are provided by Technicalsymposium Google Group Members.
Disclaimer: All the above contents are provided by technicalsymposium.com Google Group members.
Further, this content is not intended to be used for commercial purpose. Technicalsymposium.com is not liable/responsible for any copyright issues.

Technicalsymposium.com-All Quick Links & Study Notes PDF- Free Download