Oracle Arithmetic paper 2014

Posted on :26-02-2016

Oracle Placement Paper - 2014:-

Q1. How many mashes are there in 1 square meter of wire gauge if each mesh is 8mm long and 5mm wide?

(A) 2500

(B) 25000

(C) 250

(D) 250000

Q2. A man spends half of his salary on household expenses, 1/4th for rent, 1/5th for travel expenses, the man deposits the rest in a bank. If his monthly deposits in the bank amount 50, what is his monthly salary?

(A) Rs. 500

(B) Rs.1500

(C) Rs.1000

(D) Rs. 900

Q3. Two trains move in the same direction at 50 kmph and 32 kmph respectively. A man in the slower train observes the 15 seconds elapse before the faster train completely passes by him. What is the length of faster train?

(A) 100m

(B) 75m

(C) 120m

(D) 50m

Q4. x% of y is y% of ?

(A) x/y

(B) 2y

(C) x

(D) cannot be determined

Q5. In simple interest, what sum amounts of Rs.1120/- in 4 years and Rs.1200/- in 5 years?

(A) Rs. 500

(B) Rs. 600

(C) Rs. 800

(D) Rs. 900

Q6. The price of sugar increases by 20%, by what % should a housewife reduce the consumption of sugar so that expenditure on sugar can be same as before?

(A) 15%

(B) 16.66%

(C) 12%

(D) 9%

Q7. A certain number of men can finish a piece of work in 10 days. If however there were 10 men less it will take 10 days more for the work to be finished. How many men were there originally?

(A) 110 men

(B) 130 men

(C) 100 men

(D) none of these

Q8. If a sum of money compound annually amounts of thrice itself in 3 years. In how many years will it become 9 times itself?

(A) 6

(B) 8

(C) 10

(D) 12

Q9. In how many ways can 21 books on English and 19 books on Hindi be placed in a row on a shelf so that two books on Hindi may not be together?

(A) 3990

(B) 1540

(C) 1995

Q10. Two pipes A and B can fill a cistern in 37 minutes and 45 minutes respectively. Both pipes are opened. The cistern will be filled in just half an hour, if the B is turned off after:

(A) 5 min.

(B) 9 min.

(C) 10 min.

(D) 15 min.

Q11. In one hour, a boat goes 11 km/hr along the stream and 5 km/hr against the stream. The speed of the boat in still water (in km/hr) is:

(A) 3 km/hr

(B) 5 km/hr

(C) 8 km/hr

(D) 9 km/hr

Q12. A man was engaged on a job for 30 days on the condition that he would get a wage of Rs. 10 for the day he works, but he have to pay a fine of Rs. 2 for each day of his absence. If he gets Rs. 216 at the end, he was absent for work for ….. days.

(A) 7 days

(B) 8 days

(C) 9 days

(D) 12 days

Q13. A man can row 5 kmph in still water. If the river is running at 1kmph, it takes him 75 minutes to row to a place and back. How far is the place?

(A) 3 km

(B) 2.5 km

(C) 4 km

(D) 5 km

Q14. If one-seventh of a number exceeds its eleventh part by 100 then the number is......

(A) 770

(B) 1100

(C) 1825

(D) 1925

Q15. Sam purchased 20 dozens of toys at the rate of Rs. 375 per dozen. He sold each one of them at the rate of Rs. 33. What was his percentage profit?

(A) 3.5

(B) 4.5

(C) 5.6

(D) 6.5

Q16. Two numbers A and B are such that the sum of 5% of A and 4% of B is two-third of the sum of 6% of A and 8% of B. Find the ratio of A:B.

(A) 2:3

(B) 1:1

(C) 3:4

(D) 4:3

Q17. Out of 7 consonants and 4 vowels, how many words of 3 consonants and 2 vowels can be formed?

(A) 210

(B) 1050

(C) 25200

(D) 21400

Q18. A train speeds past a pole in 15 seconds and a platform 100 m long in 25 seconds. Its length is:

(A) 50 m

(B) 150 m

(C) 200 m

(D) Data inadequate

Direction for Questions 19 - 23:

Pick out the most effective word(s) from the given words to fill in the blank to make the sentence meaningfully complete.

Q19. Natwarlal ...... them all for a ride by producing false documents

(A) took

(B) cheated

(C) kept

(D) let

Q20. In hot weather I like lying in the ...... of a tree

(A) shade

(B) shelter

(C) protection

(D) shadow

Q21. It being an ...... issue, it is not correct to introduce questions of morality in to the debate.

(A) moral

(B) immoral

(C) amoral

(D) irrelevant

Q22. Health is too important to be ......

(A) discarded

(B) despised

(C) detested

(D) neglected

Q23. True brevity ...... in saying only what needs to be said.

(A) consists

(B) depicts

(C) portrays

(D) resides

Directions (24-25):

In the following the questions choose the word which best expresses the meaning of the given word.

Q24. SHALLOW

(A) Artificial

(B) Superficial

(C) Foolish

(D) Worthless

Q25. NEUTRA

(A) Unbiased

(B) Non-aligned

(C) Undecided

(D) Indifferent

Directions (26-30):

Each question consist of two words which have a certain relationship to each other followed by four pairs of related words, Select the pair which has the same relationship.

Q26. AFTER: BEFORE

(A) first: second

(B) present: past

(C) contemporary: historic

(D) successor: predecessor

Q27. DISTANCE: MILE

(A) liquid: litre

(B) bushel: corn

(C) weight: scale

(D) fame: television

Q28. WAN: COLOUR

(A) corpulent: weight

(B) insipid: flavour

(C) pallid: complexion

(D) enigmatic: puzzle

Q29. INDIGENT: WEALTHY

(A) angry: rich

(B) native: affluent

(C) gauche: graceful

(D) scholarly: erudite

Q30. PORK: PIG

(A) rooster: chicken

(B) mutton: sheep

(C) steer: beef

(D) lobster: crustacean

Q31. S1: While crossing a busy road, we should obey the policeman on duty.

P: We should always cross the road at the zebra crossing.

Q: We must look to the signal lights and cross the road only when the road is clear.

R: If there are no signal lights at the crossing, we should look to the right, then to left and again the right before crossing the road.

S: If the road is not clear we should wait. S6: We should never run while crossing the road. The Proper sequence should be:

(A) PSRQ

(B) PQRS

(C) RQSP

(D) QRPS

Q32. S1: When a satellite is launched, the rocket begins by going slowly upwards through the air.

P: However, the higher it goes, the less air it meets.

Q: As the rocket goes higher, it travels faster.

R: For the atmosphere becomes thinner.

S: As a result there is less friction. S6: Consequently, the rocket still does not become too hot. The Proper sequence should be:

(A) QPRS

(B) QSPR

(C) PQRS

(D) PQSR

Q33. S1: The city is almost a slum and stinks most of time.

P: The slush on the road did not deter them.

Q: The occasional slips and falls were considered a small price to pay for the trip.

R: They were excited, fascinated by the sight of fresh snow on the roads.

S: Even so, it looked beautiful to tourists of various categories. S6: But some visitors came away with the unforgettable sight of young labours scantily clad. The Proper sequence should be:

(A) RQPS

(B) QPRS

(C) RSQP

(D) SPQR

Q34. S1: A father having offered to take the baby out in a perambulator, was tempted by the sunny morning to slip into a pub for a glass of beer.

P: Indignant at her husbands behaviour, she decided to teach him a lesson.

Q: She wheeled away the pram.

R: A little later, his wife came by, where to her horror, she discovered her sleeping baby.

S: Leaving the pram outside, he disappeared inside the bar.

The Proper sequence should be:

(A) SRPQ

(B) RQPS

(C) SPQR

(D) PQSR

Directions (35-37):In the following questions choose the word which is the exact OPPOSITE of the given words

Q35. EMBEZZLE

(A) Misappropriate

(B) Balance

(C) Remunerate

(D) Clear

Q36. EVASIVE

(A) Free

(B) Honest

(C) Liberal

(D) Frank

Q37. GREGARIOUS

(A) Antisocial

(B) Glorious

(C) Horrendous

(D) Similar

Technical Section:-

Q38. What is the use of a make file

(A) Do detect memory leakage

(B) To optimise the code

(C) To link and compile source code to exe

(D) To disassemble the exe to source code

Q39. How many columns are retrieved from this query:

SELECT address1||,||address2||,||address2 Address FROM employee;

(A) 1

(B) 2

(C) 3

(D) 0

Q40. Which character is used to continue a statement in SQL*Plus?

(A) *

(B) /

(C) -

(D) @

Q41. What is the difference between the two declaration?

#include

&

#include stdio.h

(A) No Difference

(B) The 2nd declaration will not compile

(C) First case Compiler looks in all default location and in 2nd case only in the working directory

(D) Depends on the Compiler

Q42. Functions for error trapping are contained in which section of a PL/SQL block?

(A) Header

(B) Declarative

(C) Executable

(D) Exception

Q43. In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is used in the executable section of the PL/SQL block?

(A) NULL

(B) 0

(C) Results in a compilation error

(D) An exception will be raised

Q44. What is the result if two NULL values are compared to each other?

(A) TRUE

(B) FALSE

(C) Undefined

(D) NULL

Q45. In this PL/SQL statement, which of the following lines will produce an error?

(A) cursor CAPITALS is select CITY, STATE

(B) into my_city, my_state

(C) from CITIES

(D) where CAPITAL = Y;

Q46. PL/SQL raises an exception, in which TWO of the following cases:

(A) When a SELECT statement returns one row

(B) When a SELECT statement returns more than one row

(C) When the data types of SELECT clause and INTO clause do not match

(D) When INTO statement is missing in the SELECT statement

Q47. Which command will delete all data from a table and will not write to the rollback segment?

(A) DROP

(B) DELETE

(C) CASCADE

(D) TRUNCATE

Q48. When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

(A) System tablespace

(B) Users tablespace

(C) Default tablespace for the user

(D) Oracle will give an error

Q49. Which Oracle access method is the fastest way for Oracle to retrieve a single row?

(A) Primary key access.

(B) Access via unique index

(C) Table access by ROWID

(D) Full table scan

Q50. Which character function can be used to return a specified portion of a character string?

(A) INSTR

(B) SUBSTRING

(C) SUBSTR

(D) POS

Q51. To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

(A) 8

(B) 3

(C) 4

(D) 5

Q52. Which of the following can be a valid column name?

(A) Column

(B) 1966_Invoices

(C) Catch_#22

(D) #Invoices

Q53. Assuming today is Monday, 10 July 2000, what is returned by this statement:

Follow us

Employers

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.