#1
| |||
| |||
Previous year Oracle solved Aptitude Question Papers |
#2
| |||
| |||
Re: Previous year Oracle solved Aptitude Question Papers
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
__________________ Answered By StudyChaCha Member Last edited by Vinodt; March 31st, 2014 at 04:40 PM. |
Our Latest Videos |
Sponsored Links |
#4
| |||
| |||
Re: Previous year Oracle solved Aptitude Question Papers
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.
__________________ Answered By StudyChaCha Member |