Also Included DBMS questions which will help u land the job and ace the interview
Log37
1: ——- = ? ( Log67 )
1 + Log32
2: log(a-b) = log a - log b; then a = ?
(b/(b2+1));
3: 3 black 7 white balls. prob of drawing 2 white balls ? (7/15)
4: In a lock of 4 rings there r five characters how
many unsuccessful attempts can be made ? (624)..
5: sqrt(6+sqrt(6+sqrt (6 + ..))))) = ? 3
6: a solution is prepared by mixing two solution with sprit 20% & 60%..In
what ration they should be mixed to get the 50% sprit in resultant solution.
(1:3)
7: X2 - (A-3)X +(A+3) = 0
for what value of A the sum of square of roots will be least ? (A=2);
8: ‘a’ number of persons work daily ‘b’ hours to produce ‘c’ items. If ‘d’ persons walks away from the group what will be the number of hours to produce ‘c’ items. ? (ab/(a-d))
9: - 13 Passage
14 - 18 venn diagram.
19-22 picking based (VERBAL);
23-25 picking odd once out (words )
26: m = ax , n = ay mxny = a2(x+y) find 1/x + 1/y? (1)
27 xy - 2y - 6 =0;
x 2 x >2 ..
y is always postive.
28
The diameter of circle can be determined from
1.area.
2.circumference.
Ans either of them.
29: sum of 2 no. is 7 & product s 10 fnd larger number.
PAPER 2
The test was of 1 hour 30 ques. g apti & 30 of
technical.......some
ques. of g apti were very lengthy so don,t end up in solving
them.....time was less......some 15 ques. from arithmetic......&
rest
15
logical,statement interpretation,arrangement,tense
correction......&
like
that......
i am enclosing here the 2 C questions :
1. given a square matrix which consists only of 1 & 0......find
which
rows,which cols & which diagonals consist entirely of 1,s.
2. given an array of integers find all possible combinations of
the
numbers whose sum equal to 90.....
ans : knapsack problem (in data structures - aho ullman)
Note : for them solution was not the criteria.......but the
approach
was important......the solution should be generalised &
optimized........optimization was given the top priority........
here is the techincal paper :
plz try to solve them urself by trying on comp.
1. const int MAX=10;
main()
{enum a {a,b,MAX};
print MAX;
}
2. enum object is a const which can only be assigned a value at
initialization or a variable which can be assigned any value in
the
middle of
the program?
3. void *p;
what operation cannot be performed on p?
ans : arithmetic operation unless it is properly typecasted
4. char **p="Hello";
print p,*p,**p
5. main()
{char str[]="Geneius";
print (str);
}
print(char *s)
{if(*s)
print(++s);
printf("%c",*s);
}
6. what does the function fcloseall() does ?
7. main()
{printf("Genius %d",fun(123));
}
fun(int n)
{return (printf("%d",n));
}
8. difference between definition & declaration.
9. find the error?
fun()
{int i=10;
if(i<10) a="9,b=" c="3,d;" d="(b-c)<(c-a)" 1="?" i="4;" i="i/4);" cols="?" id="KonaLink2" target="_top" class="kLink" style="text-decoration: underline ! important; position: static;" href="http://www.yuvajobs.com/oracle-paper.asp?page=3&order=id#">data modelling
a. customer b. student c. office d. speed
20. can a database table exist without a primary key ?
21. whether higher normal forms better than lower forms as far
redundancy is concerned ?
22. file is at which level
ans. conceptual level
23. what is a foreign key
There are 2 round of written test
One is Technical
The Technical Test has 30 qns to be answered in 30
mins
This is Just a MODEL
Questions will be asked on C, C++, Oracle, RDBMS ,
Java & data structures
C
--
1. The expression 1= 30*1000+2768; evaluates to A)
32768 B) -32768 C) 113040 D) 0
2. Which is wrong
A) mess=123.56; B) con=,T,*,A,; C) this=,T"*20; D)
3+a=b
3) What is the output of Ptograms
Main()
{ int a=500,b,c;
if(a>400)
b=300; c=2--; printf("\n%d%d",b,c);}
4) Identify the error in
Main()
{char c1=,a,,c2=,Z,;
if (c1==,a,or c2==,z,) printf("welcome");}
5) What will the following program print
Main()
{inti; for(i=0;i<=10;i++); printf("%d\n",i);} 6) What will be the values of x,y,& z Main() { int x=10,y,a, y=--X; z=x--; printf(%d%d%d\n",x,y,z); } 7) What will be the output of Main() { int i; int marks[]={100,90,75,90,80}; for (i=0,i<4;i++) i="&arr[1];" j="&arr[5];" deptno="10;">
4) How would you declare a PL/SQL table of records to
holdthe rows selectd from the EMP table ?
5) Which statement about Implicit cursor is true ?
a) Implicit cursors are declared implicitly only from
DML
b) Implicit cursors are dclared implicitly for all the
DML & SELECT statements
c) Programmers needs to close all implicit cursors
before the end of PL/SQL programs
d) Programmers can declare Implicit cursors by using
cursor type in declaraion section
6) Evaluate this PL/SQL Block
Declare
V_Result number(2)
BEGIN
DELETE
FROM EMPLOYEES
WHERE department id (20,30,80);
V_result:=SQL%ROWTYPE;
COMMIT;
END;
/
What will be the value of v_result if no rows are
selected
a) 0 b) 1 c) TRUE d) NULL
7) Which two conditions in a PL/SQL block cause an
exception error to occur ? ( Choose 2 )
a) Select statement does not return a row
b) select stmt returns more than one row
c) select statement contaains a group by clause
d) seelct statenent donot have where clause
e) data type in the select list are inconsistent whith
data types in the into clause
DBMS/ RDBMS
-----------
1)You are requested to use the HIERARCHIAL DATABSE
model for the Human Resource DBMS System . Since your
entity relationship model for the system reveal that
most of the entities have many-o-many relationships
between them, you do not approve TOm,s
request.Referring to the above scenario,what is the
REASON behind your decision ?
<>
2) Which one of the following mechanisms in aRDBMS
ensure
a) 1 Constraints b) Locking c) Views d) Indexes
3) How does a data base stor information that is
related to the location of its tables
a) 1 by relationships
b) By normalisation
c) By a data dictionary
d) by data banking
e) By entity modeling
4) Two tables A & B would be given
You are asked to mintain a relationship between Table
A & B. Referring to the gien table, which field will
you choose as the primary key for Table A
<>
5) You have been asked to remove all aggregate
functions from your SQL statements refering to the
scenario above. WHich one of the following do you need
to remove ?
a) 1 SUM b) COUNT c) AVG d) MAX e) ROUND
Data structures
---------------
1) What will be the output of the gien program
int m,n=10,top=0,stack[11],item ,current;
main()
{
puts ("enter number of elements <11 top="1;top<=" m="top;m">0;--m)
printf("%d\n",stack[m]);
}
2)Questions on BINARY TRESS & LINKED LISTS
( 4 or 5 options would be given )
3) What are the THREE MODES OF traversal of a BINARY
TREE?
Log37
1: ——- = ? ( Log67 )
1 + Log32
2: log(a-b) = log a - log b; then a = ?
(b/(b2+1));
3: 3 black 7 white balls. prob of drawing 2 white balls ? (7/15)
4: In a lock of 4 rings there r five characters how
many unsuccessful attempts can be made ? (624)..
5: sqrt(6+sqrt(6+sqrt (6 + ..))))) = ? 3
6: a solution is prepared by mixing two solution with sprit 20% & 60%..In
what ration they should be mixed to get the 50% sprit in resultant solution.
(1:3)
7: X2 - (A-3)X +(A+3) = 0
for what value of A the sum of square of roots will be least ? (A=2);
8: ‘a’ number of persons work daily ‘b’ hours to produce ‘c’ items. If ‘d’ persons walks away from the group what will be the number of hours to produce ‘c’ items. ? (ab/(a-d))
9: - 13 Passage
14 - 18 venn diagram.
19-22 picking based (VERBAL);
23-25 picking odd once out (words )
26: m = ax , n = ay mxny = a2(x+y) find 1/x + 1/y? (1)
27 xy - 2y - 6 =0;
x 2 x >2 ..
y is always postive.
28
The diameter of circle can be determined from
1.area.
2.circumference.
Ans either of them.
29: sum of 2 no. is 7 & product s 10 fnd larger number.
PAPER 2
The test was of 1 hour 30 ques. g apti & 30 of
technical.......some
ques. of g apti were very lengthy so don,t end up in solving
them.....time was less......some 15 ques. from arithmetic......&
rest
15
logical,statement interpretation,arrangement,tense
correction......&
like
that......
i am enclosing here the 2 C questions :
1. given a square matrix which consists only of 1 & 0......find
which
rows,which cols & which diagonals consist entirely of 1,s.
2. given an array of integers find all possible combinations of
the
numbers whose sum equal to 90.....
ans : knapsack problem (in data structures - aho ullman)
Note : for them solution was not the criteria.......but the
approach
was important......the solution should be generalised &
optimized........optimization was given the top priority........
here is the techincal paper :
plz try to solve them urself by trying on comp.
1. const int MAX=10;
main()
{enum a {a,b,MAX};
print MAX;
}
2. enum object is a const which can only be assigned a value at
initialization or a variable which can be assigned any value in
the
middle of
the program?
3. void *p;
what operation cannot be performed on p?
ans : arithmetic operation unless it is properly typecasted
4. char **p="Hello";
print p,*p,**p
5. main()
{char str[]="Geneius";
print (str);
}
print(char *s)
{if(*s)
print(++s);
printf("%c",*s);
}
6. what does the function fcloseall() does ?
7. main()
{printf("Genius %d",fun(123));
}
fun(int n)
{return (printf("%d",n));
}
8. difference between definition & declaration.
9. find the error?
fun()
{int i=10;
if(i<10) a="9,b=" c="3,d;" d="(b-c)<(c-a)" 1="?" i="4;" i="i/4);" cols="?" id="KonaLink2" target="_top" class="kLink" style="text-decoration: underline ! important; position: static;" href="http://www.yuvajobs.com/oracle-paper.asp?page=3&order=id#">data modelling
a. customer b. student c. office d. speed
20. can a database table exist without a primary key ?
21. whether higher normal forms better than lower forms as far
redundancy is concerned ?
22. file is at which level
ans. conceptual level
23. what is a foreign key
There are 2 round of written test
One is Technical
The Technical Test has 30 qns to be answered in 30
mins
This is Just a MODEL
Questions will be asked on C, C++, Oracle, RDBMS ,
Java & data structures
C
--
1. The expression 1= 30*1000+2768; evaluates to A)
32768 B) -32768 C) 113040 D) 0
2. Which is wrong
A) mess=123.56; B) con=,T,*,A,; C) this=,T"*20; D)
3+a=b
3) What is the output of Ptograms
Main()
{ int a=500,b,c;
if(a>400)
b=300; c=2--; printf("\n%d%d",b,c);}
4) Identify the error in
Main()
{char c1=,a,,c2=,Z,;
if (c1==,a,or c2==,z,) printf("welcome");}
5) What will the following program print
Main()
{inti; for(i=0;i<=10;i++); printf("%d\n",i);} 6) What will be the values of x,y,& z Main() { int x=10,y,a, y=--X; z=x--; printf(%d%d%d\n",x,y,z); } 7) What will be the output of Main() { int i; int marks[]={100,90,75,90,80}; for (i=0,i<4;i++) i="&arr[1];" j="&arr[5];" deptno="10;">
4) How would you declare a PL/SQL table of records to
holdthe rows selectd from the EMP table ?
5) Which statement about Implicit cursor is true ?
a) Implicit cursors are declared implicitly only from
DML
b) Implicit cursors are dclared implicitly for all the
DML & SELECT statements
c) Programmers needs to close all implicit cursors
before the end of PL/SQL programs
d) Programmers can declare Implicit cursors by using
cursor type in declaraion section
6) Evaluate this PL/SQL Block
Declare
V_Result number(2)
BEGIN
DELETE
FROM EMPLOYEES
WHERE department id (20,30,80);
V_result:=SQL%ROWTYPE;
COMMIT;
END;
/
What will be the value of v_result if no rows are
selected
a) 0 b) 1 c) TRUE d) NULL
7) Which two conditions in a PL/SQL block cause an
exception error to occur ? ( Choose 2 )
a) Select statement does not return a row
b) select stmt returns more than one row
c) select statement contaains a group by clause
d) seelct statenent donot have where clause
e) data type in the select list are inconsistent whith
data types in the into clause
DBMS/ RDBMS
-----------
1)You are requested to use the HIERARCHIAL DATABSE
model for the Human Resource DBMS System . Since your
entity relationship model for the system reveal that
most of the entities have many-o-many relationships
between them, you do not approve TOm,s
request.Referring to the above scenario,what is the
REASON behind your decision ?
<>
2) Which one of the following mechanisms in aRDBMS
ensure
a) 1 Constraints b) Locking c) Views d) Indexes
3) How does a data base stor information that is
related to the location of its tables
a) 1 by relationships
b) By normalisation
c) By a data dictionary
d) by data banking
e) By entity modeling
4) Two tables A & B would be given
You are asked to mintain a relationship between Table
A & B. Referring to the gien table, which field will
you choose as the primary key for Table A
<>
5) You have been asked to remove all aggregate
functions from your SQL statements refering to the
scenario above. WHich one of the following do you need
to remove ?
a) 1 SUM b) COUNT c) AVG d) MAX e) ROUND
Data structures
---------------
1) What will be the output of the gien program
int m,n=10,top=0,stack[11],item ,current;
main()
{
puts ("enter number of elements <11 top="1;top<=" m="top;m">0;--m)
printf("%d\n",stack[m]);
}
2)Questions on BINARY TRESS & LINKED LISTS
( 4 or 5 options would be given )
3) What are the THREE MODES OF traversal of a BINARY
TREE?
Comments
Post a Comment