Oracle Latest Interview Paper

Oracle Latest Interview Paper

The Oracle Interview consists of two parts. One for Written test Interview and Another one for HR interview.
Written test paper consists of 30 questions. There is No Negative Marking. The examination is 30 minutes in duration.

1.There are six steps that lead from the first to the second floor. No two people can be on the same step
Mr. A is two steps below Mr. C
Mr. B is a step next to Mr. D
Only one step is vacant ( No one standing on that step )
Denote the first step as step1 and second step as step2 etc.

Which of the following is false

i. B&D can be both on odd-numbered steps in one configuration
ii. In a particular configuration A and C must either both an odd numbered steps or both an even-numbered steps
iii. A person E can be on a step next to the vacant step.

(A) i only
(B) ii only
(C) iii only
(D) both i and iii

2. If a boat is moving in upstream with velocity of 14 km/hr and goes downstream with a velocity of 40 km/hr, then what is the speed of the stream ?

(A) 13 km/hr
(B) 26 km/hr
(C) 34 km/hr
(D) none of these

3. Find the value of ( 0.75 * 0.75 * 0.75 - 0.001 ) / ( 0.75 * 0.75 - 0.075 + 0.01)

(A) 0.845
(B) 1.908
(C) 2.312
(D) 0.001

4. A can have a piece of work done in 8 days, B can work three times faster than the A, C can work five times faster than A. How many days will they take to do the work together ?

(A) 3 days
(B) 8/9 days
(C) 4 days
(D) can't say

5. A car travels a certain distance taking 7 hrs in forward journey, during the return journey increased speed 12km/hr takes the times 5 hrs.What is the distance travelled

(A) 210 kms
(B) 30 kms
(C) 20 kms
(D) none of these

6. Find (7x + 4y ) / (x-2y) if x/2y = 3/2 ?

(A) 6
(B) 8
(C) 7
(D) data insufficient

7. If on an item a company gives 25% discount, they earn 25% profit. If they now give 10% discount then what is the profit percentage.

(A) 40%
(B) 55%
(C) 35%
(D) 30%

8. What does the following piece of code do ?
sprintf(retbuf, "%d", n);

(A) Print the Integer value of n
(B) Copy the string representation of the integer variable n into the buffer retbuf
(C) Print the Float value of n.
(D) Print the string representation of the integer variable n.

9. What is wrong with the program
double d;
scanf("%f", &d);

(A) Instead of %f , %lf should be used for formatting
(B) Instead of %f , %d should be used for formatting
(C) Instead of %f , %D should be used for formatting
(D) Instead of %f , %n should be used for formatting

10. What fucntion will read a specified number of elements from a file?

(A) readfile()
(B) fread()
(C) fileread()
(D) getline()

11.
#include
void func()
{
int x = 0;
static int y = 0;
x++; y++;
printf( "%d -- %d\n", x, y );
}
int main()
{
func();
func();
return 0;
}

What will the code above print when it is executed?
(A) 1-- 1
1 – 1
(B) 1 -- 1
1 -- 2
(C) 1 -- 1
2 -- 1
(D) 1 -- 0
1 -- 0


12. What is the output of the following loop:
for(I=0, j=I++; j>I; j++, I++)
{
printf("%d%d", I, j);
}

(A) 0,1
(B) 0,0
(C) Infinite loop
(D) No output


13. Consider the following structure
struct
{
int data;
struct node *prev;
struct node *next;
}node;

NULL ß 5 à 8 à 10 à NULL
ß ß
p q r

What will be the value of r à prev à next à data ?

(A) 10
(B) 8
(C) 5
(D) NULL


14. What is the output :
void main()
{
int a,b=5,c=10;
a = (b-c) > (c-b) ? b : c;
printf("%d",a);
}
(A) 10
(B) 5
(C) 0
(D) Error

15. Which section of a PL/SQL block would most likely contain a RAISE statement?

(A) Header
(B) Declarative
(C) Executable
(D) Exception