Oracle placement papers 2010:
1..void main()
{
int i;
clrscr();
for(i=1;i<6;++i)
switch(i)
{
case 1:
case 2: printf("%d,",i++);break;
case 3: continue;
case 4: printf("%d,",i);
}
printf("%d",i);
getch();
}
Ans: 1,4,6
2.Which of the storage class(es) becomes the global variables for the entire Program
(A) Extern
(B) Static
(C) Auto
(D) Register
Ans: A
3. What is the output of the program
void main()
{
char s[]="oracle is the best";
char t[40];
char *ss,*tt;
while(*tt++=*ss++);
printf("%s",t);
getch();
}
// A. oracle is the best
// B. Core dump
// c. Error Message
// D. Goes into infinite loop
Ans: B. core dump (Garbage value)
4. What is the output of the program
void main()
{
int j[10]={9,7,5,3,1,2,4,6,9};
int i=1;
clrscr();
for(;i<9;i++)
printf("%d ",--j[i++]);
getch();
}
// A. 6,2,1,5
// B. 6,2,1,5,7
// c. Error Message
// D. core dump
Ans: A. 6,2,1,5
5. Which clause u use to exclude the rows before grouping them?
A. Group By
B. Having
C. Where
D. Minus
6. Which of the following statements is not true about views?
A. you can create a index on views
B. Views do not have permanent data
C. Views can be based on one or more tables
D. Views can be dropped without dropping
tables
7. What should be the value of a, in the polynomials x2 11x + a and x2 14x + 2a, so that these two polynomials have common factors. a) 24 b)1 c)-1 d)1/2
8. a right angled triangle, the square of the hypotenuse is twice the product of the other two sides. Then one of the acute angles of the triangle is
a) 450 b) 300 c) 600 d) 150
9.. In class of 10 students, the teacher writes a number on the board. The first student tells that the number is divisible by 1, the second student tells that the number is divisible by 2, the third by 3, the forth by 4 and so on till 10. If the statement of one of the students in wrong then what is the least number possible.
10. The data dictionary view to see the list of constraints enabled on a table is
a. user_tables
b. user_table_constraints
c. user_constraints
d. There is no dictionary view available for the same
11. Identify the pseudocolumns
a. rowid
b. sysdate
c. rowval
d. dual
12. if "a" is an array of 5*5 dimension, a[2][4] is same as
a. **(a+2+4)
b. *(a+2) + *(a+4)
c. **(a+2)+4
d. *(*a+2)+4)
13. what is the output of ..
#include
void main()
{
char buffer[10]={"Genesis"};
printf("%d",&buffer[4]-(buffer));
}
a. 3
b. 4
c. 0
d. illegal pointer subtraction
14. identify the relationship between the many employees
working
in a dept..
a. one to one
b. one to many
c. many to one
d. many to many
15.there was a table given and it was asked which normal form does it follows..
16. the process of including some controlled redundancy for the sake of performance is known as
a. normalization
b. Cartesian product
c. Denormalization
d. None
17. A certain number of men can finish a piece of work in 10 days. If however there were 10 men less it will take 10 days more for the work to be finished. How many men were there originally?
(A) 110 men
(B) 130 men
(C) 100 men
(D) none of these
18. In simple interest what sum amounts of Rs.1120/- in 4 years and Rs.1200/- in 5 years ?
(A) Rs. 500
(B) Rs. 600
(C) Rs. 800
(D) Rs. 900
19. Assuming today is Monday, 10 July 2000, what is returned by this statement:
SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
(A) 10-JUL-00
(B) 12-JUL-00
(C) 11-JUL-00
(D) 17-JUL-00
20.Which character is used to continue a statement in SQL*Plus?
(A) *
(B) /
(C) -
(D) @