Oracle Placement Paper |   50026

Oracle Placement Paper

 

Oracle Technical and HR Interview Questions and answers

 

1. Computer science knowledge: 30 Minutes 30 Questions

2.English: 25 Minutes 25 Questions

3.Reasoning: 35Minutes 35 Questions

Oracle Computer science Knowledge Qquestions

Computer science knowledge: 30 Minutes 30 Questions

 

1. The first Unix operating system, as it was in development stage, was written in the

            A.  C language           

            B.  B language

            C.  assembly language            

            D.  none of these

Ans-B

 

2. In a disk, each block of data is written into

            A.  one sector

            B.  two sectors

            C.  three sectors         

            D.  two or more sectors

Ans-D

 

3. Windows is

            A.  an operating system         

            B.  an operating environment

            C.  a character user interface

            D.  none of these

Ans-B

 

4. which of the following is a service not supported by the operating system?

            A. protection  

            B. accounting

            C. compilation            

            D. I/O operation

Ans-C

 

5. The processor which performs arithmetical and logical operations is called

            A.  control      

            B.  Alu

            C.  register      

            D.  cache memory

Ans-B

 

6. What is a node class?

 

7. How is it possible to insert different type of elements in stack?

 

8. Evaluate the following prefix expression " ++ 26 + - 1324"

 

9. Write the programs for Linked List (Insertion and Deletion) operations

 

10. What does abstract data type means?

 

11. Metadata enables database designers and users to do all of the following except:

A.        sample data.

B.        understand what data exist.

C.        what the fine distinctions are between similar data items.

D.        what the data mean.

Ans-A

 

12. In a 1:N relationship, the foreign key is placed in:

A.        either table without specifying parent and child tables.

B.        the parent table.

C.        the child table.

D.        either the parent table or the child table.

Ans-C

 

13. Which of the following conditions should exist if you want to convert a relationship to an associative entity?

A.        Some of the relationships for the participating entities are "many".

B.        The resulting associative entity has an independent meaning.

C.        The resulting associative entity has no attributes.

D.        All of the above

Ans-B

 

14. Which is not a relevant feature of CASE tools?

A.        The ability to help draw data models using entity-relationship notations

B.        The ability to generate code

C.        An information repository

D.        Access to a DB via the Internet

Ans-D

 

15. Backward recovery is which of the following?

A.        Where the before-images are applied to the database

B.        Where the after-images are applied to the database

C.        Where the after-images and before-images are applied to the database

D.        Switching to an existing copy of the database

Ans-A

 

16. Prove that running time T(n) = n3 + 20n + 1 is O(n4) by Big O notation

 

17. Prove that running time T(n) = n3 + 20n + 1 is not O(n2)

 

18. Which of the following applies to a class rather than an object?

A.        Query 

B.        Update

C.        Scope 

D.        Constructor

Ans-C

 

19. The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?

A.        Overlapping rule

B.        Disjoint rule

C.        Total specialization rule

D.        Partial specialization rule

Ans-D

 

20. The benefits of object-oriented modeling are which of the following?

A.        The ability to tackle more challenging problems

B.        Reusability of analysis, design, and programming results

C.        Improved communication between users, analysts, etc.

D.        All of the above.

Ans-D

 

21. An object can have which of the following multiplicities?

A.        Zero

B.        One

C.        More than one

D.        All of the above.

Ans-D

 

22.When a business rule involves three or more graphical symbols, you can show the constraint as a note and attach the note to each of the symbols by a dashed line.

A.        True     B.        False

Ans-A

 

23. Decide the Big-O complexity of the given question

def sum_of_divisors(n)

  result = 0

  i      = 1

  while i < n

    if n % i == 0

      result += i

    end

    i += 1

  end

  return result

end

 

24. Using ODL, you can define which of the following?

A.        Attribute

B.        Structure

C.        Operation

D.        All of the above.

Ans-D

 

25. hich of the following is an ordered collection of elements of the same type?

A.        Set      

B.        Bag

C.        List     

D.        Dictionary

Ans-B

 

26. To run a compiled Java program, the machine must have what loaded and running?

A.        Java virtual machine

B.        Java compiler

C.        Java bytecode

D.        A Web browser

Ans-A

 

27. A relation is considered a:

A.        Column.

B.        one-dimensional table.

C.        two-dimensional table.

D.        three-dimensional table.

Ans-C

 

28. A tuple is a(n):

A.        column of a table.

B.        two dimensional table.

C.        row of a table.

D.        key of a table.

Ans-C

 

29. For some relations, changing the data can have undesirable consequences called:

A.        referential integrity constraints.

B.        modification anomalies.

C.        normal forms.

D.        transitive dependencies.

Ans-B

 

30. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

A.        Supertype entity

B.        Subtype entity

C.        Archetype entity

D.        Instance entity

Ans-C

 

English: 25 Minutes 25 Questions

 

1. Correct the sentence

The Diary of Anne Frank “SHOWED A YOUNG GIRL’S COURAGE” during two years of hiding.

    A. Has shown a young girl’s courage

    B. Did show a young girls courage

    C. Shows a young girl’s courage

   D. Showed a young girl’s courage

   E. Showed a young girl’s courage

 

2.   Correct the sentence grammatically.

 To “NO ONES SURPRISE”, Joe didn’t have his homework ready.

A. No ones surprise

 B. No one’s surprise

C. Noones surprise

D. No ones’ surprise

E. No-ones surprise

 

3. In the question below a sentence broken into five or six parts. Join these parts to make a meaningful sentence. The correct order of parts is the answer.

1. was              2. and              3. Suresh         4. kind             5. loving           

A.        31425 

B.        54213

C.        34251 

D.        15243

E.         12345

Ans-A

 

4. In the question below a sentence broken into five or six parts. Join these parts to make a meaningful sentence. The correct order of parts is the answer.

1. tea               2. have             3. That             4. some            5. before           

A.        43251 

B.        24315

C.        24153 

D.        52431

E.         41325

Ans-C

 

5. In questions below, a part of the sentence is italicised and underlined. Below are given alternatives to the italicised part which may improve the sentence. Choose the correct alternative

    After it was repaired it “ran perfect” again.

 A. Ran perfectly

B. Would run perfectly

C. Ran perfect

D. Could of run perfect

E. Could run perfect

 

6. In questions below, a part of the sentence is italicised and underlined. Below are given alternatives to the italicised part which may improve the sentence. Choose the correct alternative

    The fact that boxing is known to cause head injuries and brain damage “SHOULD LEAD US TO INFORM” the public and push for a ban on boxing.

A. Should lead us to inform

B. Could lead us to inform

C. Should of led us to inform

D. Should have led us to inform,

E. Will lead us to inform

7. The passage consists of six sentences. The first and sixth sentence is given in the beginning. 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.

S1:       For some time in his youth Abraham Lincoln was manager for a shop.

P :        Then a chance Customer would come.

Q :       Young Lincoln way of keeping shop was entirely unlike anyone else's

R :       Lincoln would jump up and attend to his needs and then revert to his reading.

S :        He used to lie full length on the counter of the shop eagerly reading a book.

S6:       Never before had Lincoln had so much time for reading as had then.

The Proper sequence should be:

A.        SRQP 

B.        QSPR

C.        SQRP 

D.        QPSR

Ans-B

 

8. The passage consists of six sentences. The first and sixth sentence is given in the beginning. 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.

S1:       Smoke oozed up between the planks.

P :        Passengers were told to be ready to quit the ship.

Q :       The rising gale fanned the smouldering fire.

R :       Everyone now knew there was fire on board.

S :        Flames broke out here and there.

S6:       Most people bore the shock bravely.

The Proper sequence should be:

A.        SRQP 

B.        QPSR

C.        RSPQ 

D.        QSRP

Ans-A

 

9. In questions below, a part of the sentence is italicised and underlined. Below are given alternatives to the italicised part which may improve the sentence. Choose the correct alternative

    In August my parents “WILL BE MARRIED” for twenty-five years.

A. Shall have been married for twenty-five years.

B. Will have been married for twenty-five years.

C. Will have married for twenty-five years.

D. Will be married for twenty five years.

E. Will be married for twenty-five years.

 

10. Pick out the best one which can complete incomplete stem correctly and meaningfully.

Even if it rains I shall come means ......

A.        if I come it will not rain

B.        if it rains I shall not come

C.        I will certainly come whether it rains or not

D.        whenever there is rain I shall come

E.         I am less likely to come if it rains

Ans-C

 

11. Choose the word which best expresses the meaning of the given word.

LAUD

A.        Lord   

B.        Eulogy

C.        Praise  

D.        Extolled

Ans-C

 

12. Choose the word which is the exact OPPOSITE of the given words

NIGGARDLY

A.        Frugal 

B.        Thrifty

C.        Stingy 

D.        Generous

Ans-D

 

13. Choose the one which best expresses the given sentence in Passive/Active voice.

I remember my sister taking me to the museum.

A.        I remember I was taken to the museum by my sister.

B.        I remember being taken to the museum by my sister.

C.        I remember myself being taken to the museum by my sister.

D.        I remember taken to the museum by my sister.

Ans-B

 

14. Choose the one which best expresses the given sentence in Indirect/Direct speech

I told him that he was not working hard.

A.        I said to him, "You are not working hard."

B.        I told to him, "You are not working hard."

C.        I said, "You are not working hard."

D.        I said to him, "He is not working hard."

Ans-A

 

15. Choose the one which best expresses the given senten

feedback