Oracle- Placement -Paper Latest

December 31, 2007

Oracle Latest Fresher Placement Sample Question Question Paper 3

Oracle Paper

The test was of 1 hour 30 ques. g apti and 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……and
rest

ORACLE Latest Fresher Engineer Placement Sample Question Paper 3

15
logical,statement interpretation,arrangement,tense
correction……and
like
that……
i am enclosing here the 2 C questions :
1. given a square matrix which consists only of 1 and 0……find
which
rows,which cols and 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 and
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 and declaration.
9. find the error?
fun()
{int i=10;
if(i400)
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
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 and 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