Oracle Placement Question Paper
The whole technical paper shown here contains 30 Questions of SQL + PL/SQL and the TIME allocated is 30 minutes
After 15 minutes of completion of the test, an Oracle representative declared the names of the passing candidates and politely apologised to others.
Then there is another programming test. After this is the round of Interviews.
Aptitude section of Oracle
1.Two words are given by
Word 1: 836641
Word 2: 371548 ( the order of the numbers is not like the one there)
Each character is represented by a digit and each digit represents a character. It is given that T and R occur four times. S and A occur two times. E, P, O and M occur one time each. The word starts with T. The letter E occurs in word one only. The following questions are asked:
a). Which number represents T.
b). Which number represents S.
c). Which character represents 2.
d). Which digit represents A.
e). Which word represents word 2.
2.There was a table with data related to net sales, gross profit, etc. and some questions were asked related to it. Quite easy
3.A man spent 1/6th of his life in child hood, 1/12th of his life as youngster and 1/7th of his life as a bachelor. After five years of his marriage a son was born to him. The son died four years before the father died and at the time of his death his age was half the total age of his father.
The questions were,
a. What is the age of the father. (84)
b. At what age was he married.(33)
c. What is the age of his son.(42)
4.Rita puts 9 pairs of black socks and 8 pairs of white socks in a drawer. She takes 3 pairs of socks. What is the probability that she will get a pair of black socks.
Probability can be found as – probability of finding one pair + Probability of finding two pairs + probability of finding three pairs of socks. (here it means the probability of finding atleast one pair of socks)
5.What is the value of the following series 1/7 + 2/72 + 1/73 +2/74 + 1/75 + ??
6.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
Mathematics / Maths probability question with solution / answer
7. What is the sum of all the four digit numbers formed using the digits 0, 1, 2 and 3. None of the two digits should be repeated.
Solution: The numbers are 18. (the numbers would be 24 if in the place of zero there was some other non zero number)
8. In 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?
Four options are provided.
9.There are two square rooms. Both are of same height. The second room is 5 meter longer than the first room. The rate for papering the walls is 10 paisa per square meter. The total cost for papering the rooms is Rs 60 and Rs 80. What is the height of the rooms.
10.There are two numbers in the ratio 8:9. if the smaller of the two numbers is increased by 12 and the larger number is reduced by 19 thee the ratio of the two numbers is 5:9. Find the larger number.
Solution of the mathematical / maths problem
Smaller number be s, larger number be l
s/l = 8/9
s+12/l-19 = 5/9
Solve the two equations to find out the values of s and l
11.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.
Solution is available for this problem! Its quite simple though it seems difficult. Keep watching for more solutions to the problems here or post a problem and we will tell the solution)
Just by analysing the problem, we find that a number is always divisible by 1. And the number is 360 actually. Leave 7. The product of 10 and 9 will be divisible by 1 to 10 numbers except 8 and 7. So 90 is divisible by 1 to 10 except 8 and 7. 360 is divisible by 1 to 10 except 7. Its the least number.
12.The first and the last sentences of a set of sentences are given. The middle four sentences are in jumbled form we have to select the order of the sentences so that they form a meaningful message.
13. A passage with two paragraphs is given. Then two questions are asked based on it.
14.A stamp collector arranges his stamps during his free time. When he arranges his stamps in pairs, there is one stamp left. It is the same when he arranges the stamps in groups of 3, 4, 5 and 6. Now, how many stamps will he be left with when he arranges them in groups of 8.
Technical
15.Delete from table tempv where rowid in (select rowid from tempv where rowid in (((select min(rowid) from tempv where … count(*) > 1))) union(select rowid from tempv where rowid in (((select min(rowid) from tempv where … count(*) > 1)));
16.When there is a failure in fetching the rows from a cursor…
a. %isopen
b. %notfound
c. %found
d. %rowcount
17.Select ‘oracle’ from dual where null = null;
a. oracle
b. null
c. error out
d. no rows selected
18. A question about Package body and Package Specification, they have provided the code for that describing the scenario of movie_tickets_sold and asked the programmer to insert a block of code, where that code block to be inserted? In Package body? or in Package Specification?
19.Which of the following operator is not used in Outer Join?
a. =
b. !=
c. AND
d. OR
20.PL/SQL uses
a. Early Binding
b. Late binding
c. No Binding
d. Deferred Binging
21.Its a database trigger, CREATE OR REPLACE TRIGGER delete_row ON DELETE
22.If table contains 100 rows and it is truncated, how many rows get updated
a. 0
b. 1
c. 100
d. No rows updated
Some questions are asked on basic select statements…
Some are there on Triggers, Procedures
VARRAYS/Nesting of Table: 1 question is there
NLS_DATE_FORMAT: 1 question
Some c language questions:
1.The size of the float data type in C language is ?
2.The size of the float data type in C language is ?
What is the output of the following C program.
Main()
{
printf(?%c?,?abcdefgh?[4]);
}
3. Question: What is the output of the following C-program.
Main()
{
char str[7]=?strings?;
printf(?%s?,str);
}
4.main()
{
file *fp;
fp=fopen(?xyz?,?r?);
}
What does fp point to?
5. How many arguments can be given in a command line in C.
6.When the variables are pushed into the stack, how do we retrieve them from the stack?
a) pop b) pull c) remove d) none of these.
7.What is the size of integer variable in JAVA?
8.A programs reads ?The man and the boy\r\n? from a file using fgets() and stores it in str[]. Then the string stored in str is
a) ?The man and the boy\r\n\0?
b) ?The man and the boy\r\0?
c) ?The man and the boy\n\0?
d) ?The man and the boy\0?
After this written exam, there is another written test exam which has algorithms and coding related questions. Two questions from them are:
1.The first one was the conversion of a given expression into its postfix form and then to evaluate it.
2.The question was to have a circularly linked link-list of integers 1 to n. I we give k as an input then we have to output(print) 1, k, 1+2k, 1+3k ? till n and we have to delete these numbers. When we give then next k we have to continue the same process starting with 2. The linked needs to be maintained
See More Latest Oracle Placement Question Papers for campus placements in India and walkin interviews for freshers. See 2007 and 2008 placement paper aptitude, technical, database, programming, dbms, reasoning questions only on LatestExams.com