Oracle Technical Section - March 2011(Chennai)

Posted on :25-02-2016
Oracle Placement Paper - March 2011(Chennai):-

Q1. Rita puts 9 pairs of black socks and 8 pairs of white socks in a drawer. She takes 3 socks. What is the probability that we get a pair of black socks?

Q2. 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

a) 450
b) 300
c) 600
d) 150

Q3. 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

Directions for Q 4 - 7:

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.

Q4. What is the age of the father?

ANS: 84

Q5. At what age was he married?

ANS: 33

Q6. What is the age of his son?

ANS: 42

Q7. What is the value of the following series 1/7 + 2/72 + 1/73 +2/74 + 1/75 +?

Q8. 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?

Q9. 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.

Q10. 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?

Directions for Q 11- 15:]

Two words are given by
Word 1: 83263641
Word 2: 3715468
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 two starts with T. The letter E occurs in word one only.

Q11. Which character represents 2?

Q12. Which number represents T?

Q13. Which word represents word 2?

Q14. Which number represents S?

Q15. Which digit represents A?

Q16. 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 then the ratio of the two numbers is 5:9. Find the larger number.

Q17. There are two square rooms. Both are of same height. The second room is 5m 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?

Technical Section:

Q18. If table contains 100 rows and it is truncated, how many rows get updated?

a) 0
b) 1
c) 100
d) No rows updated

Q19. When there is a failure in fetching the rows from a cursorâ€¦

a) is open
c) found
d) row count

Q20. Select oracle from dual where null = null;

a) oracle
b) null
c) error out
d) no rows selected

Q21. When the variables are pushed into the stack, which method is used to retrieve them from it?

a) pop
b) pull
c) remove
d) none of these

Q22. PL/SQL uses which of the following?

a) Early Binding
b) Late binding
c) No Binding
d) Deferred Binding

Q23. Which of the following operator is not used in Outer Join?

a) =
b) !=
c) AND
d) OR

FreshersLive - No.1 Job site in India. Here you can find latest 2018 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.

 ✖