Oracle Company Solved question papers

Any buddy, please provide me the Oracle Company Solved question papers……….

Yes sure, here I am uploading a document file that contains the Oracle Company Solved question papers. There are descriptive types of the questions available. This is the content of attachment:

Question 1

Which of the following mathematical operator fits in the place of ? in 4 ? 12 - 24 / 8 + 4 = 49.

a) + b) - c) x d) /

Answer : c) x

How can you place 12 coins in 6 lines such that each line should contains 4 coins?

Difference between Vector and ArrayList?
What is controller in your project?
How will u authentication a user?
Some servlet calls JSP and in JSP will initialize a servlet this way
Servlet1 s=new Servlet1();
s.doPost(request,response);
and this in turn calls a jsp and this JSP calls another Servlet what will be the output?
Any 2 errors and exceptions?
Difference between SAX and DOM?
Have u ever used . How to include an xslt in another xslt ?
How will u get connection in ur project?
Which loads driver classloader or JVM?
Difference between Statement and PreparedStatement?
ResultSet points to which location by default?
What is ResultSetMetaData?
Types of Drivers in JDBC?
Difference between 3rd and 4th type java?
What is class?what is object?
What is object ? what is instance? What is the difference between object and instance?
What is encapsulation?
What is polymorphism? Types of polymorphism ? how will u achieve all types of polymorphism?
What is the difference between vector and Array?
What is the difference between HashTable and HashMap?
Are servlets and JSP's threadsafe ? how can u make them threadsafe?
What is multithreading? What Is synchronized?
How can u stop a thread?
Is stop()=sleep()
How to kill a thread?
Describe the design of ur project as MVC ? Methodologies? Flow of ur project?
How will u make transactions with creditcard? Ie will u deduct money from the card
Immediately after making transaction?
How will u insert and delete with a single java connection when u have referential integrity?
What is serialization? Any methods in serialization? What is externalization?
How will u achieve threads?
How will u set priorities of threads?


These r all the basic questions generally u will face at the round which is easy to get through.

Coming to the second round where u have to thorough with ur current project and interviewer will go deep into the concepts that u r using in ur project...

some of them which i remembered..

How to implement connection pooling by ourself?
Will service all doget , dopost or the reverse?
How can u implement cocoon on ur own?
How can u implement hashmap if u r not having it in java?
What is the difference between static binding and dynamic binding?

below r u some questions generally we will face at the interview...

What is synchronization? Why is it used? What are its disadvantages?

How will u enforce synchronization?
How will u declare a synchronized block? What does this represent in the
Declaration of synchronized block?

Can u assign an instance of a class which implements an interface to an interface type?

What is servlet chaining?

Describe the life cycle of servlet starting from the request from a browser to the response it get?

If service method is used then doGet() and doPost() stand for what?

If we can access a sevlet through both GET and POST methods then which methods will u declare in
The sevlet class?

What is dynamic binding?Can u explain with an example?

Can u read all elements from an array?

If aaaa is an array then why aaaa.length why not aaaa.length()?

Is array an object?

Class A{

Public void meth(){
}
}

class B extends A{
Public void meth(){

}
public static void main(String args[]){
A a=new A();
a.meth();//which method will this call
}
}

if u want to call a method of class B then how can u achieve this?

What is static variable? What is static method?
Can u call a static method on a class object,can u access
Static variables through class objects?

What is the diffrenence between AWT and Swing?

How will u add a button to a frame?

Cant we add a component directly to a frame? Why?

What are the different types of panes available?
What are the uses of different types of panes?

What is a layered pane?

What is event delegation model?describe it with an example?

Public void Methos(){
Int I;

Int a[]=new int[10];
S.O.P(i);

For(int k=0;k S.O.P(a[ k]);
}
What will be the output of this method

What is the difference between getActionCommand()
And getSource() on event object?

If u have a table with columns empid,empname,salary,
Write a query to get maximum 5 salary drawing employees?

What is a tier? What is the difference between tier and system or computer?

What do u mean by portability?

What do u mean by platform independence?

Completely view of MVC and n tier architecture and differences?

What is the difference between JradioButton and Jradiobuttongroup.

If u add 2 Jradiobuttons to a panel and check the first one and then the second one
Then which one will be selected

What are the methods of authorization in jsp or servlets?

What is webapplication?

What are the various methods of declaring a TLD in a taglib directive in jsp?

What is TLD?

Implicit objects of jsp are available in destroy() method or not?

What is translation unit in jsp?

What is context in webapplication?

What are multiple and single processor servers? How session is handled
When the server is multi processor server?

If server crashes the threads will continue running or will they stop?
what happens to the sevlet?

Explain MVC pattern by taking any one component ex JtextField or Jbutton?

What is GridBagLayout?

If we want to change the entire path of the server ,where should we touch in a application server?

If we have 3 jsp's as model.jsp, controller.jsp, view.jsp then will it be a MVC architecture?

What is a classloader?

What is dynamic typing, static typing ?

Is java dynamic typed language?

What are the types of sevlet containers?

What is web.xml?

What is pooling of sevlets?

If we have two abstract classes A,B then can we extend both the classes in a single class?

What are the different types of thread priorities?

What is SAX?

What is the difference between SAX and DOM?

What is the difference between RequestDispatcher.forward(request req,response res)
And response.sencRedirect("url");?

What are implicit objects in jsp?

Why cocoon ?why not struts?what is cocoon?

How are u implementing session in ur application?

What is serialization? What are the methods in implementing serialization?

If u have a single table in database how to normalize it?

Is servlet thread safe ? life cycle of JSp?

What is the difference between checked exception an runtime exception?

Interrupt() method throws which exception?

Why jsp is used if we have sevlets>

Difference between a String and Stirng Buffer?

How to increment the capacity of a StringBuffer?

If String S="x";
S+"y";
Then what is S?

How can u set the priorities of thread ? What are the priorities available?

Difference between Vector and ArrayList other than Synchronization?

Which JDBC dirver are u using?

What are the drivers available?

What do u mean by precompiled statement? What is the difference between
Statement and PreparedStatement?

Difference between HashMap and HashTable?

What is context?

Difference between application server and webserver ?

Can we have a try without catch and with a finally?
What is the use of having finally?

If there is try{
Return x;
}finally{
S.O.P("Yes");
}

then finally will execute or not

what is the superclass of an exception?

Is sevlet threadsafe?

What is synchronization?

Sleep() throws which exception?

This is the oracle paper

Technical section:

its very easy any one can answer 25 qns without preperation. some are
1. how compiler treats variables of recursive functions
2. what is orthogonal matrix?
3. given two tables and asked 2 qns on those table ,
one is on join and another is on NOT IN
4. given some qns on pointers( pretty easy)
5. given five qns on data structures like , lifo, fifo
6. qtn on primary key
7. how NULL in sql is treated?
8. given a doubly linked list and asked r->left->right->data
ans: r->data
9:explain const char *ptr and char *const ptr
remaining i didn`t remember

Aptiude

15 quant apti from rs agrval
15 verbal apti,
in this 4 are odd word out
and 4 are sentese ordering when jumbled senteses given
and 4 are reasoning

For complete question paper download the attachment given below:
(Oracle Company Solved question papers)

Attached Files Available for Download

Oracle Company Solved question papers.zip (20.9 KB, 38 views)

__________________
Answered By StudyChaCha Member

Will you please share with me the Oracle company placement previous year solved question papers as it is very urgent for me?

As you want to get the Oracle company placement previous year solved question papers so here is the information of the same for 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

1) Rohan and Rohit are twin brothers, but they do not look ......
A.unique B.different
C.likely D.alike
Ans.D

2) ...... of old paintings is a job for experts.
A.Resurrection B.Retrieval
C.Restoration D.Resumption
Ans.C

3) He is a person of sound character and ...... disposition.
A.beneficent B.morous
C.amiable D.amicable
Ans.C

4) In high school many of us never realised the importance that grammar would ...... in later life.
A.figure B.portray
C.play D.exercise

Ans.C

5) On account of the dearth of grass on the arid plains the cattle became ......
A.flippant B.jubilant
C.agitated D.emaciated
Ans.D

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.
6) LIGHT:BLIND
A.speech:dumb B.language:deaf
C.tongue:sound D.voice:vibration
Ans.A

7) CORPOREAL:SPIRITUAL
A.mesalateau B.moron:savant
C.foreigner:immigrant D.pedagogue:teacher
Ans.B

8) SYMPHONY:COMPOSER
A.Leonardo:music B.Frescoainter
C.coloursallet D.art:appreciation
Ans.B

In questions below, each passage consist of six sentences. The first and sixth sentence are given in the begining. The middle four sentences in each have been removed and jumbled up. These are labelled as P, Q, R and S. Find out the proper order for the four sentences.

9)
S1: The Hound of Baskervilles was feared by the people of the area.
P : Some people spoke of seeing a huge, shadowy form a Hound at midnight on the moor.
Q : But they spoke of it in tones of horror.
R : Nobody had actually seen the hound.
S : This shadowy form did not reveal any details about the animal.
S6: The Hound of Baskervilles remains an unsolved mystery.
The Proper sequence should be:
A.SPQR B.SPRQ
C.PSRQ D.PQRS
Ans.D

10)
S1: A gentleman who lived alone always had two plates placed on the table at dinner time.
P : One day just as he sat down to dine, the cat rushed in to the room.
Q : One plate was for himself and other was for his cat.
R : she drooped a mouse into her own plate and another into her master plate.
S : He used to give the cat a piece of meat from his own plate.
S6: In this way the cat showed her gratitude to her master.
The Proper sequence should be:
A.QSPR B.PSRQ
C.QRSP D.RPQS
Ans.A

11)
S1: Ants eat worms, centipedes and spiders.
P : They are usually much quicker than the ant itself.
Q : Nevertheless, these animals do not make easy game for ants.
R : Besides, they have an extraordinary number of ways of escaping.
S : They also eat larvae and insect adults such as flies, moths and spring tails.
S6: Some jump, and some give out a pungent repellent substance. The Proper sequence should be:
A.SQPR B.SPRQ
C.SQRP D.SRQP
Ans.A

12) In a class composed of x girls and y boys what part of the class is composed of girls
A. y/(x + y)
B. x/xy
C. x/(x + y)
D. y/xy
Ans.C

13)What is the maximum number of half-pint bottles of cream that can be filled with a 4-gallon can of cream(2 pt.=1 qt. and 4 qt.=1 gal)
A. 16
B. 24
C. 30
D. 64
Ans.D

14)If the operation,^ is defined by the equation x ^ y = 2x + y,what is the value of a in 2 ^ a = a ^ 3
A.0 B.1 C.-1 D.4
Ans.B

15)A coffee shop blends 2 kinds of coffee,putting in 2 parts of a 33p. a gm. grade to 1 part of a 24p. a gm.If the mixture is changed to 1 part of the 33p. a gm. to 2 parts of the less expensive grade,how much will the shop save in blending 100 gms.
A.Rs.90 B.Rs.1.00 C.Rs.3.00 D.Rs.8.00
Ans.C

16)There are 200 questions on a 3 hr examination.Among these questions are 50 mathematics problems.It is suggested that twice as much time be spent on each maths problem as for each other question.How many minutes should be spent on mathematics problems
A.36 B.72 C.60 D.100
Ans.B

17)In a group of 15,7 have studied Latin, 8 have studied Greek, and 3 have not studied either.How many of these studied both Latin and Greek
A.0 B.3 C.4 D.5

Ans.B

18)If 13 = 13w/(1-w) ,then (2w)2 =
A.1/4 B.1/2 C.1 D.2
Ans.C

19)If a and b are positive integers and (a-b)/3.5 = 4/7, then
(A) b < a (B) b > a (C) b = a (D) b >= a
Ans. A

20)In june a baseball team that played 60 games had won 30% of its game played. After a phenomenal winning streak this team raised its average to 50% .How many games must the team have won in a row to attain this average?
A. 12 B. 20 C. 24 D. 30
Ans. C

21)M men agree to purchase a gift for Rs. D. If three men drop out how much more will each have to contribute towards the purchase of the gift/
A. D/(M-3) B. MD/3 C. M/(D-3) D. 3D/(M2-3M)
Ans. D

23) A company contracts to paint 3 houses. Mr.Brown can paint a house in 6 days while Mr.Black would take 8 days and Mr.Blue 12 days. After 8 days Mr.Brown goes on vacation and Mr. Black begins to work for a period of 6 days. How many days will it take Mr.Blue to complete the contract?
A. 7 B. 8 C. 11 D. 12
Ans.C

24) If 2x-y=4 then 6x-3y=?
(a)15 (b)12 (c)18 (d)10
Ans. (b)

25)If x=y=2z and xyz=256 then what is the value of x?
(a)12 (b)8 (c)16 (d)6
Ans. (b)

26) (1/10)18 - (1/10)20 = ?
(a) 99/1020 (b) 99/10 (c) 0.9 (d) none of these
Ans. (a)

27) 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)


28) 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)

29) 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)

30)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)

__________________
Answered By StudyChaCha Member