BirlaSoft 2006 placement paper

[sridhar]

BirlaSoft 2006 placement paper

Birla Soft 2006 placement paper

1. Select a,b,c,d from vtable where b>2 and c<4

Assuming you will execute the above query often ,changing only the values in the where clause ,what could you do to improve efficiency ?

Create a database stored procedure with parameters to execute this statement

Create an index on columns a&b

Create a temporary table that contains the data and use triggers to maintain it

Create a trigger that executes this statement and execute the trigger

2. Modern RDBMS’s perfom the following the following functionc except ______________.

Force column values in one table to match any of the values in a column of another table

Automatically replicate data on another server

Automatically create new indexes based on query history

Prevent unauthorized users from accessing data at the firls level

3. Which is not the characteristics of a view ?

Consumes Disk space for data

Multiple tables

Multiple rows

Updateable

4. RDBMS triggers are typically bound to a _____________and one or more _____________

Table, SQL statement types

SQL statement type, user

Column, rows

User, tables

5. What relationship is resolved by an “intersecting” or “associative” entity ?

Recursive

Mandatory one to one

Many to Many

One to One

6. With every use of memory allocation function should be used to release allocated memory which is no longer needed ?

dropmem()

dealloc()

release()

free()

7. Make a copy of file “upper” in the directory two levels up .

jump –2 upper

cp upper ../..

cp upper –2/

None of the above

Set2

some of the questions

1. class Word

{

public:

Word(const char*,int = 0);

};

Referring to the sample code above what is the minimum number of arguments required to call the constructor ?

a) 0

b) 1

c) 2

d) 3

2. Which one of the following represents a correct and safe declaration of NULL ?

a) typedef((void *)0) NULL;

b) typedef NULL(char *)0;

c) #define NULL((void *0)

d) #define NULL((char*)0)

3. #include

Referring to the sample code above ,which of the following could you use to make the standars

I/O Stream classes accessible without requiring the scope resolution operator ?

a) using namespace std::iostream

b) using namespace std;

c) using namespace iostream ;

d) using iostream;



4. Which one of the following statements allocates enough space to hold an array of 10 integers

that are initialized to 0 ?

a) int *ptr = (int *) calloc(10,sizeof(int));

b) int *ptr = (int *) alloc( 10*sizeof(int));

c) int *ptr = (int *) malloc( 10*sizeof(int));

d) int *ptr = (int *)calloc(10*sizeof(int));

5. What function will read a specified number of elements from a file ?

a) fread()

b) readfile()

c) fileread()

d) gets()

6. What is the largest value an integer can hold in a Standard C compiler ?

a) 32767

b) 65536

c) 2147483647

d) INT_MAX

7. With every use of memory allocation function should be used to release allocated memory

which is no longer needed ?

a) dropmem()

b) dealloc()

c) release()

d) free()

8. int a=1;
int ab=4;

int main()

{

int b=3,a=2;

printf("%i*/%i*/%*/i",a,b,ab);

}

Aptitude section

1. A Question like A is engg. B is doctor C is artist etc then few condition related to them you have give answer to 4 or 5 qs on these conditions.

2. Same as above with different data and conditions. suggest you must go for these questions coz in 3 or

4 mins you can answer 7 or 8 qs

3. About 4 to 5 questions on arranging 4 sentences to form a paragraph.

4. If father is three times as old as son. 5 years ago he was 4 times age of his son what is son age.