Previous year Oracle solved Aptitude Question Papers

Here I am looking for the previous year solved Aptitude Question Papers of Oracle, can you please provide me the same??

Yeah sure, here I am sharing the Aptitude Question Papers of Oracle with you

1. Two words are given by
Word 1: 83263641
Word 2: 3715468 ( don't remember the order of the numbers.)
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

2. starts with T. The letter E occurs in word one only. The questions were,
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.

3. There was a table with data related to net sales, gross profit, etc and some questions were asked related to it. Very easy

4. 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)

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

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

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

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

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

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

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

13. 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 in which the sentences are to be placed so that they convey a meaningful message.

14. A passage with two paragraphs is given. Then two questions are asked based on it. Could not remember it.

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

16. 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)));

17. When there is a failure in fetching the rows from a cursor
a. %isopen
b. %notfound
c. %found
d. %rowcount

18. Select 'oracle' from dual where null = null;
a. oracle
b. null
c. error out
d. no rows selected

19. here is a question of 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?

20. Which of the following operator is not used in Outer Join?
a. =
b. !=
c. AND
d. OR

21. PL/SQL uses which of the following
a. Early Binding
b. Late binding
c. No Binding
d. Deferred Binging

22. Following is a database trigger, CREATE OR REPLACE TRIGGER delete_row ON DELETE
not remember the complete question.

23. If table contains 100 rows and it is truncated, how many rows get updated
a. 0
b. 1
c. 100
d. No rows updated

24. There are some questions on Basic SELECT STATEMENTS

25. Some questions on Triggers, Procedures

26. VARRAYS/Nesting of Table: 1 question is there

27. NLS_DATE_FORMAT: 1 question

28. The size of the float data type in C language is

29. he size of the float data type in C language is
What is the output of the following C program.
Main()
{
printf("%c,abcdefgh[4]);
}

30. What is the o/p of the following C-program.
Main()
{
char str[7]=strings;
printf("%s,str);
}

31. main()
{
file *fp;
fp=fopen("xyz,r);
}
What does fp point to?

32. What is the maximum no. of arguments that can be given in a command line in C.

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

34. What is the size of integer variable in JAVA?

35. A programs reads "The man and the boyrn from a file using fgets() and stores it in str[]. Then the string stored in str is
a) "The man and the boyrn

ORACLE (Aptitude) BIT Mesra 2003

Directions for questions 1-3:Each question consists of six statements
followed by 3 statements put together in a specific order .Choose the option
where the third statement is a conclusion drawn from the previous 2
statements.

1) A. Final Year students would like a good career.

B. All final year students are eligible as candidates for MBA entrance
exam.
C.Final Year students are entitled to work towards a good career.
D.Some of those who are candidates for an MBA entrance exam are final
year students
E.All those eligible as candidates for an MBA exam are eligible for a
good career
F.All those who would like a good career are entitled to it.

1. AEF 2. EBC 3.BCF 4.CDF

2) A. All bright people acknowledge brains in others
B. Some knowledgeable men are bright
C. Some knowledgeable men do not acknowledge brains in others
D.Some knowledgeable men are persons who are bright
E.Some knowledgeable men are not bright
F.All bright people do not necessarily acknowledge brains in others

1. ABE 2. ACF 3.ADE 4. ACE

3) A.Some thoughts lack clarity
B.Anything unclear is not worth writing about
C.Some thoughts are worth writing about
D.All thoughts lack clarity
E.Some thoughts are clear
F. No thought is worth is writing about

1. ABF 2.BCD 3.BEF 4.BDF

Directions for questions 4 to 6:Arrange the sentences A,B,C,D in a logical
sequence to form a coherent paragraph.

4) A. How do you set your mental co-ordinates vis a vis the external
variables if every-
thing changes so fast ?
B. Modern life is about managing the prices and consequences of changes
C. That is creating a problem
D. The pace of the changing process seems to be getting quicker overtime

1. ABDC 2.DCAB 3.BDCA 4.BCDA

5) A. Infact trying to calculate an element of chance
B. The rather fanciful idea of Lady Luck favouring her own can be traced
back to
Pagan times when lucky gamblers were thought to be the beloved of
the goddess of
Good fortune
C.Risks were taken in order to gain her approval ,and one of these risks
was trying to
Guess what would happen -for example ,which way a leaf would fall
,which way a
Frog would jump
D.She was seen as being capricious and prone ,occasionally ,to mockery

1. BCAD 2.BDCA 3.BADC 4.BDAC

6) A.It is because Japanese companies do not have to pay the consultancies'
inflated fees
the argument goes ,that companies have more money to devote to
'real' investment
and because they are not tempted to follow the latest management
fashions that they
can develop a coherent ,long term strategy.
B.The average salary man,relaxing after a ten hour day over yakitori
and sake ,hardly
Spends his time talking about Drucker -san and Peter-san .
C.It might seem far fetched to argue that Japan's post war growth has
anything to do
With management theory.
D.Critics of management theory happily point out that thirty years after
arriving ,
Western consultancies are still to make ends meet ,and that Japan
has few business
Schools ,none of them very prestigious.

1. CADB 2. CBDA 3. DBAC 4. DBCA



Directions for questions 7 to 9 :Each question consists of a sentence ,part
of which is underlined .Choose the option that best replaces the underlined
part

7) Nearly everyone know that exercise has numerous health benefits for
people of all ag-
es and physical conditions .

1. Nearly everyone know that exercise has numerous .
2. Nearly everyone knows that exercise has numerous
3. Everyone nearly knows that exercise having numerous
4. Everyone nearly have know that exercise has numerous

8) The researchers hope to study a large patient group to investigate the
effect further and
finding out how long the effects last

1. finding out
2. to find out
3. for finding
4. to finding

9) Having failed to work out a viable marriage with the BSP twice in the
past ,another
hasty alliance shouldn't have been entered into by the BJP

1. another hasty alliance shouldn't have been entered into by the BJP
2. a hasty alliance should have been avoided by the BJP

3. the BJP's entering into hasty alliance shouldn't have been done by them.
4. the BJP should not have entered into a hasty alliance

Directions for questions 10 to 12: Choose the word that is least related to
the question word.

10) Mighty
1. puny 2. colossal 3.prodigious
4.towering

11) Ordeal
1. tribulation 2. copious 3. .affliction
4.torment

12) Pen
1. enclosure 2.corral 3. coop 5.nib



Direction for questions 13 to 15:Read of the following short passages and
answer the question that follows

13) The Mahauti tribe that inhabited the Himayalan region had a personal
relationship with their deities .This gave support and protection to the
tribe most of whom were hunters ; the support might otherwise be lacking
.The absence of each support left tye individual weak and vulnerable .So
,important was this spititual relation that when the tribes lost their
beliefs in the spirit ,their culture disintegrated.

The passage suggests that a primary motivation for members of hunting
cultures to seek firm bonds with the spirit world was the

1. ambition to be better at huntung than others
2. wish to secure an afterlife
3. need for cpmfort in times of sorrow
4. desire to obtain and maintain skill and strength

14) Cosmetologists trying to make ultimate hair care product have found that
when the did not treat hair with a quaternary compound,on combing ,the
combing force remained high This happened even when the electrostatic charge
was substantially reduced by high humidity.

It can be inferred from the above that ,the cosmetologist did which of the
following to reduce the electrostatic charge generated when hair not treated
with a quaternary compound was combed ?

1. decreased the combing speed
2. increased humidity
3. tangled the hair
4. dried the hair.

15) No thorough consideration of the metropolis can overlook either its
social organization or its governmental institutions .The informal means of
social control that once regulated communal affairs of settlement have given
way to the more formal methods of modern society .As metropolitan grew more
complex governmental organizations have evolved as instruments of control
and direction

Which of the followinf situations in a city is most clearly an example of
the developments described in the passage ?

1. City officials no longer control the allocation of water rights :instead
state governments distribute water rights
2. Delinquent children are not verbally chastised by community elders
:instead ,they are brought before a court of law
3. The local government has retained its autonomy thereby preventing central
governments from providing solutions for population problem
4. Community cohesion has decreased ,leading to a sense of isolation on the
part of city residents.

Questions 16 and 17 are based on the following

a/b = (a+b)/(a-b)
a*b = (a+b)(a-b)
a@b = a/b - b/a (implies subtracting the smaller of the two from the other
one )
a#b = a/b + b/a

16) Find (((a@b) + (a#b)) * 1)/ 1, where a=5.91 and b= 17.73

1. 35 2. 18/17 3.17/18
4.None of these

17) State which of the following is/are true
I. 7@(a*b) is undefined if a = b
II. [(a/b)/1 * [(b/a)/1. = (a@b) x (a#b)

1.I only 2. II only 3. Both I and II
4. Neither I or II



18) What is the maximum area that can be enclosed by a wire 44cm long ?

1. 77 2. 154 3. 308 4.None of
these

19) If A(2,3) ,B(-2,-3) and C(1,2) are three vertices of a triangle ,which
among the following is the largest angle ?

1. ABC 2. BCA 3. CAB 4. All three angles
are equal
20) f(x) = 2(x*x) +1 when x<0
= -2x when x>=0
What is f(f(f(2))) ?

1. 66 2. -33 3. 33
4. None of these

21) One sells 30 kg rice with cost Rs.22.87/kg at 20% profit and 50kg rice
with cost price Rs 20.92/kg at 30% profit .What is the total percentage
profit ?

1. 26.25% 2. 24.72% 3. 26.5% 4. 28%

22) Ravi buys 100 5% shares of face value Rs.100 at Rs.15000 .If he sells
them off after a year at Rs 155 a share ,what is his yield ?

1. 8.33% 2. 6.67% 3. 5% 4. 3.33%

23) Amit and Meghna went to New York for a 63 day holiday .Each day ,Amit
spent as many as hundred dollar bills as the remaining number of days in the
trip (excluding the current day ) ,and Meghna spent as many as hundred
dollar bills as the number of days already spent (including current day).
How much per day would they have spent together during the holiday ?

1. $12,600 2. $10000 3. $6300 4. $5000

24) Bacteria reproduce in such a manner that every hour their number
doubles In a controlled experiment that started with a certain number of
bacteria in a jar at 12noon on Tuesday ,30 million were found at 12noon on
Wednesday .At what time were there 15 million bacteria ?

1. Midnight ,Tuesday
2. 6a.m on Wednesday
3. 10 a.m Wednesday
4. None of these

25) Take a number 'x' and follow these steps :
1. Find the sum of its digit
2. If the sum has only one digit , STOP
3. Else , go back to step 1 with the new number.
If x = 1684 ,what is the end result ?

1. 19 2. 10 3. 1
4. None of these

26) A number consisting of five digits 5,6,7,8 and 9 each coming once but
not necessarily in that order is taken ,and an algorithm specified in the
previous question is run on it .How many different end results are possible
?

1. One 2.Three 3.Five
4. Nine

Directions for questions 27 and 28 :Each question is followed by two
statements A and B. Mark
1. If statement A alone is sufficient to answer the question
2. If statement B alone is sufficient to answer the question
3. If both statements A and B are required to answer the question
4. If neither A or B are sufficient to answer the question

27) What is the height of the tower ?
A. A man standing at a distance of 1km from the bottom of the tower
makes an angle
300 degrees with the top of the tower .
B. An insect starts from the bottom of the tower and reaches the top in
25sec.

28) Distance between A and B is
A. A and B two points on the circumference of the circle with center O and
radius 5.2 cm
B. Angle AOB = 450

Additional instructions for questions 29 and 30:

For any activity , X, year Ao dominates year Bo if organized retail business
in activity X in year Ao is greater than organized retails business in
activity X is year Bo .For any two activities in the organized retail
business ,A and B ,year Xo dominates year Yo if
a. The organized retail business in activity A ,in the year Xo is greater
than equal to the organized retail business activity A in the year Yo: and
b. The organized retail business in activity B ,in the year Yo is less than
or equal to the organized retail business in activity B in the year Xo.

29) For the organized retail business activity in children's clothing ,which
one of the following is true ?

1. 1994-95 dominates 1995-96
2. 1995-96 dominates 1994-95
3. 1997-98 dominates 1996-97
4. 1998-99 dominates 1997-98

30) For the organized retail business activity in children 's clothing and
footwear ,which of the following is true ?

1. 1995-96 dominates 1994-95
2. 1994-95 dominates 1995-96
3. 1996-97 dominates 1995-96
4. None of these

Attached Files Available for Download

Previous year Oracle solved Aptitude Question Papers.doc (56.0 KB, 84 views)

Will you please provide here solved aptitude question paper of Oracle placement examination as I am looking for the same?

As you want I am here giving you solved aptitude question paper of Oracle placement examination.

Solved aptitude question paper:

1.If 2x-y=4 then 6x-3y=?

(a)15

(b)12

(c)18

(d)10

Ans. (b)

2.If x=y=2z and xyz=256 then what is the value of x?

(a)12

(b)8

(c)16

(d)6

Ans. (b)

3. (1/10)18 - (1/10)20 = ?

(a) 99/1020

(b) 99/10

(c) 0.9

(d) none of these

Ans. (a)

4.Pipe A can fill in 20 minutes and Pipe B in 30 mins and Pipe C can empty the same in 40 mins.If all of them work together, find the time taken to fill the tank

(a) 17 1/7 mins

(b) 20 mins

(c) 8 mins

(d) none of these

Ans. (a)

5. Thirty men take 20 days to complete a job working 9 hours a day.How many hour a day should 40 men work to complete the job?

(a) 8 hrs

(b) 7 1/2 hrs

(c) 7 hrs

(d) 9 hrs

Ans. (b)

6. Find the smallest number in a GP whose sum is 38 and product 1728

(a) 12

(b) 20

(c) 8

(d) none of these

Ans. (c)

7. A boat travels 20 kms upstream in 6 hrs and 18 kms downstream in 4 hrs.Find the speed of the boat in still water and the speed of the water current?

(a) 1/2 kmph

(b) 7/12 kmph

(c) 5 kmph

(d) none of these

Ans. (b)

8. A goat is tied to one corner of a square plot of side 12m by a rope 7m long.Find the area it can graze?

(a) 38.5 sq.m

(b) 155 sq.m

(c) 144 sq.m

(d) 19.25 sq.m

Ans. (a)

9. Mr. Shah decided to walk down the escalator of a tube station. He found that if he walks down 26 steps, he requires 30 seconds to reach the bottom. However, if he steps down 34 stairs he would only require 18 seconds to get to the bottom. If the time is measured from the moment the top step begins to descend to the time he steps of the last step at the bottom, find out the height of the stair way in steps?

Ans.46 steps.


10. The average age of 10 members of a committee is the same as it was4 years ago, because an old member has been replaced by a young member. Find how much younger is the new member ?

Ans.40 years.

Here is the attachment.

Attached Files Available for Download

Oracle Solved Aptitude Question Paper.doc (88.5 KB, 50 views)

__________________
Answered By StudyChaCha Member