Oracle Campus Selection Guide Part-1

Selection Procedure

Written Test Followed by 4 rounds of Interviews.

WRITTEN TEST

Aptitude Test	:	75 Minutes
Quantitative	:	15 Minutes
Reasoning / Analytical	:	15 Minutes
Verbal English	:	15 Minutes
Technical	:	30 Minutes

Written Test Sections

Computer Science Knowledge (Basic)

Section	Questions	Time
OS Concepts and Data Structures	6	Minutes 6
Big O notations and OOAD Fundamentals	6	Minutes 6
DBMS and CODD's Fundamentals	7	Minutes 7
Total	19	Miinutes 19

Sample Question1

A program uses a queue to visit each of the nodes of a binary tree, starting at its root. After a node is processed its children are added to the the end of the queue. In what order do nodes get processed?

(a)Postorder

(b)Breadth-first

(c)Preorder

(d)Inorder

Sample Question 2

From the following options, select the OOP mechanism, that allows treatment of the derived class members just like the members of their parent class.

(a)Decoupling

(b)Encapsulation

(c)Polymorphism

(d)Abstraction

Sample Question-3

Which one of the following is NOT a referential integrity issue in a relational database where the DEPT column of the EMPLOYEE table is designated as a foreign key into the DEPARTMENT table?

(a) Inserting a new row into EMPLOYEE with a DEPT whose value is not the primary key of any of the rows in DEPARTMENT

(b)Updating the value of DEPT in a row of EMPLOYEE with a value that is not the primary key of any of the rows in DEPARTMENT

(c)Deleting a row of DEPARTMENT

(d)Inserting a new row into DEPARTMENT with a primary key that is not the value of the DEPT column of any row in EMPLOYEE

Question Number-4

A program uses a queue to visit each of the nodes of a binary tree, starting at its root. After a node is processed its children are added to the the end of the queue. In what order do nodes get processed?

(a)Postorder

(b)Breadth-first

(c)Preorder

(d)Inorder

Sample Question-5

From the following options, select a statement that is NOT true about immutable objects.

(a)An object has to be completely mutable or immutable but partial immutability is not very useful in programs

(b)Immutable objects cannot be modified after they are created

(c)You can use immutable objects in multi-threaded programs

(d)You can use a pointer to create a reference copy of an immutable object, instead of creating a copy of the object

Computer Science Knowledge (Advanced)

Section	Questions	Time
OS Concepts and Data Structures	10	Minutes 10
Big O notations and OOAD Fundamentals	10	Minutes 10
DBMS and CODD's Fundamentals	10	Minutes 10
Total	30	Miinutes 30

              

Sample Question1

In (typical) object-oriented programming languages which one of the following can be done by a subclass (derived class) of class C?

1. Remove methods defined in C

2. Define instance variables (data members) not defined in C

3. Remove instance variables (data members) defined in C

(a) 1

(b) 2

(c) 3

(d) All of these.

Sample Question2

Which one of the following is NOT a referential integrity issue in a relational database where the DEPT column of the EMPLOYEE table is designated as a foreign key into the DEPARTMENT table?

(a) EMPLOYEE

(b) DEPT

(c) DEPARTMENT

(d) DEPARTMENT.

Sample Question3

From the following options, select the correct pre-order representation of the following expression.

– 16 – – 14 / – 12 - 2 * 8

(a)-–16--/14–12*28

(b)-–16--/-1412*28

(c)-–16-/–14–12*28

(d)*/--–16-14–1228

Computer Science Knowledge (Expert)

-Please read all instructions very carefully before you begin.

-This is the PAC – Computer Science Knowledge (Expert Level) assessment.

-It is composed of 40 questions used to evaluate your fundamental knowledge and skills in Computer Science Knowledge.

-You will have 40 minutes to complete this assessment. Please note that once you have completed a question you will NOT be able to return to it in order to make changes.

-All questions carry equal points and no points will be deducted for wrong answers.

Assessment Breakdown

Section	Questions	Time
OS Concepts and Data Structures	13	Minutes 13
Big O notations and OOAD Fundamentals	10	Minutes 10
DBMS and CODD's Fundamentals	17	Minutes 17
Total	40	Miinutes 40

Sample Question1

From the following options, select the option that lists the disadvantages of strongly typed OO programming languages.

A: Allows run-time errors

B: Allows late detection of errors

C: Provides less flexibility

D: Provides less optimized code

E: Incurs time penalty for determining type

F: Complicates the definition of collections of heterogeneous objects

           

(a) C and F

(b) A, C and F

(c) D and E

(d) B, D and F

Sample Question2

Which one of the following is NOT a referential integrity issue in a relational database where the DEPT column of the EMPLOYEE table is designated as a foreign key into the DEPARTMENT table?

(a) Inserting a new row into EMPLOYEE with a DEPT whose value is not the primary key of any of the rows in DEPARTMENT

(b) Updating the value of DEPT in a row of EMPLOYEE with a value that is not the primary key of any of the rows in DEPARTMENT

(c) Inserting a new row into DEPARTMENT with a primary key that is not the value of the DEPT column of any row in EMPLOYEE

(d) Deleting a row of DEPARTMENT

Sample Question3

A binary search tree is defined as follows.

-Each node has a key, a value, a (possibly null) left child, and a (possibly null) right child.

-An ordering is defined on the keys to be stored in the tree.

-For a given node nd, the keys of all the nodes in its left subtree are “before” nd’s key, and the keys of all the nodes in its right subtree are “after” nd’s key.

-The depth of the root node is defined to be 0; the depth of any other node is 1 more than the depth of its parent.

-How would the next() function of a binary search tree’s iterator be defined, assuming no changes are made to the tree while the iterator is active?

Note: next() should return the value at each node in order of the corresponding keys; also, assume for each answer that the iterator has been appropriately initialized before the first call to next().

1. using a queue:

       nd = q.remove()

       q.add(nd.leftChild)

       a.qdd(nd.rightChild)

       return nd.value

2. using a stack:

       nd = stk.remove()

       stk.add(nd.leftChild)

       stk.add(nd.rightChild)

       return nd.value

3. using a stack:

       nd = stk.remove()

       nxt = nd.getRight()

       while (null != nxt) { stk.push(nxt); nxt = nxt.getLeft(); }

       return nd.value

           

(a) 1 is correct

(b) 2 is correct

(c) 3 is correct

(d) None of these

Written English (Basic)

-Please read all instructions very carefully before you begin.

-This is the PAC – Written English Assessment (Basic level).

-It is composed of 25 questions divided into 4 sections used to evaluate your English language communication skills.

-You will have 25 minutes to complete this assessment. Please note that once you have completed a question you will NOT be able to return to it in order to make changes.

-All questions carry equal points and no points will be deducted for wrong answers.

Assessment Breakdown

Section	Questions	Time
Sentence Structure	10	Minutes 5
Grammatical Usage	5	Minutes 5
Written Expression	5	Minutes  7
Reading Comprehension	5	Minutes 8
Total	25	Miinutes 25

Section Instructions

-This is the Grammatical Usage section. It is designed to test your ability to understand the proper usage of basic parts of speech and words used in the English language.

You will be presented with 5 questions asking you to either identify a grammatical error or choose the word or phrase that correctly completes a statement.

-An example of this kind of question is given below. There would be a sentence given with a missing word (blank). You are required to select the right word that completes the sentence.

Example:

The people __________ I met on holiday in France knew my boss.

A) where

B) those

C) whom (correct)

D) what

You will have 5 minutes to complete the 5 questions in this section.

Sample Question1

A monkey wearing a cap__________ on a tree when it was raining heavily.

(a) is sitting

(b) are sitting

(c) was sitting

(d) were sitting

Section Instructions

-This is the Reading Comprehension section. It is designed to test your ability to understand the English language in its written form as well as draw logical conclusions based on the information presented in a general reading passage.

-This section has 1 reading passage and 5 questions pertaining to the passage that you must answer. You will have 8 minutes to complete this section.

Sample Question :

Please carefully read the following:

Astronomy

Astronomy is the scientific study of celestial objects, such as stars, planets, comets and galaxies as well as phenomena that originate outside the Earth’s atmosphere, such as cosmic background radiation. It is concerned with the evolution, physics, chemistry, meteorology and motion of celestial objects as well as the formation and development of the universe.

Astronomical artifacts found from earlier periods indicate that astronomy is one of the oldest sciences. In fact, astronomers of early civilizations performed methodical observations of the night sky. Before tools such as the telescope were invented, early study of the stars had to be conducted using the bare eye from the only vantage points available, namely tall buildings, trees and high ground.

As civilizations in different parts of the world developed, they began to construct astronomical observatories and explore ideas on the nature of the universe. Most of the work of early astronomers actually consisted of mapping the positions of the stars and planets, a science now referred to as astrometry. From these observations, they formed early theories about the motions of the planets and the nature of the sun, moon and Earth.

Although early stargazers established the foundation for astronomy as we know it today, it was not until the invention of the telescope that it developed into a modern science. Historically, astronomy has included disciplines as diverse as astrometry, celestial navigation, observational astronomy, the making of calendars and even astrology, but now the profession is often considered to be synonymous with astrophysics.

In the 20th century, the field of professional astronomy split into two branches: observational and theoretical. The two fields complement each other, with theoretical astronomy seeking to explain the observational results, and observations being used to confirm theoretical results. Observational astronomy is focused on acquiring and analyzing data, mainly using the basic principles of physics. This branch includes the study of diverse elements, such as radio, optical and x-ray astronomy.

Theoretical astronomy is oriented towards the development of computer or analytical models to describe astronomical objects and phenomena. Topics studied by theoretical astronomers include: stellar dynamics and evolution, galaxy formation, large-scale structure of matter in the Universe, origin of cosmic rays, general relativity and physical cosmology.

Based on the passage, astrometry refers to:

(a) The way the Earth’s moon affects the ocean tides

(b) Creating calendars based on the positioning of celestial bodies

(c) The evolution of the universe

(d) The philosophical theories of the universe

(e) The mapping of the positions of the stars and planets

Section Instructions

-This is the Sentence Structure section. It is designed to test your ability to use proper grammar and form logical ideas in the English language.

-You will be given a sentence with one or more blanks along with four potential answer options. Based on the context of the sentence, you must identify the best answer option to fill in the blank.

-You will have 5 minutes to complete the 10 questions in this section.

Example:

Jen needed to _ one more math class in order to _ her secondary school degree.

A. took…finish

B. take…complete

C. taked…finished

D. takes…completes

Sample Question :

They went for a picnic in the__________ even though the clouds looked __________ and the forecast called for rain.

           

(a) park . . . ominous

(b) green . . . menacing

(c) promenade . . . suggestive

(d) rivulet . . . auspicious

Section Instructions

-This is the Written Expression section. It is designed to test your ability to logically and clearly organize ideas using the English language.

-For each question you will be given four relevant sentences that you must arrange into a paragraph that makes sense.

-You will have 7 minutes to complete the 5 questions in this section.

Example:

What is the correct order of the following sentences?

A) Social networking profiles are fascinating exercises on the construction of self-identity.

B) They have control over what profile photos they put up and what information they make available to others.

C) Through a social networking profile, users articulate how they see themselves through their online profiles.

D) In general, people use photos that reveal something about their personalities.

ACBD (Correct)

ABCD

CABD

CBDA

Sample Question :

What is the correct order of the following sentences?

A) I’ve thought about calling him Black Beauty because of his features.

B) It seems like you like it too, so I think we should make that his name.

C) I think it would be a very good name.

D) He really is a beautiful horse, and he has such a sweet, good tempered face.

           

(a) DACB

(b) DABC

(c) ABCD

(d) ADCB

Software Engineering Aptitude

Assessment Breakdown

Section	Questions	Time
Math Reasoning	10	Minutes 10
IT Reasoning	10	Minutes 10
Attention to Detail	10	Minutes  5
Logic Diagramming	5	Minutes 10
Total	35	Miinutes 35

Section Instructions

This is the IT Reasoning section. It is designed to test your understanding of the principles of logic.

You will be presented with a variety of questions that you must solve using principles of logic.

You will have 10 minutes to complete the 10 questions in this section.

Sample Question1

The selling price is 'x%’ more than the cost price. Then the cost price is less than the selling price by __________.

(a) (100+x)/100 %

(b) 100x/(100+x) %

(c) (100+x)/100x %

(d) x/(100+x) %

Section Instructions

This is the Attention to Detail section. It is designed to test your ability to adhere to detail within a large volume of information.

For the following ten questions you will be presented with one table of information as well as a line of information from that table. Using the table, identify if the line of information presented is correct or not.

You will have 5 minutes to complete the 10 questions in this section.

Sample Question:

Based on the data in the following table, answer the question below it.

The correct details for the customer “Arceo, Erin” are __________.

(a) 5426574506693440 02-19-1980

(b) 5426574560693440 02-19-1980

(c) 5426574560963440 02-19-1980

(d) 5426574560693340 02-19-1980

Section Instructions

This is the Logic Diagramming section. It is designed to test your ability to follow a workflow in a logical manner.

For the following five questions you will be presented with one diagram depicting a workflow. Refer to the diagram in order to answer each of the questions.

You will have 10 minutes to complete the 5 questions in this section.

Sample Question:

?

Section Instructions

This is the Math Reasoning section. It is designed to test your ability to understand and implement mathematical principles within concrete circumstances.

Use the information presented in each question to solve the problem.

You will have 10 minutes to complete the 10 questions in this section.

Sample Question:

How many two digit numbers are there which are divisible either by 7 or by 3 ?

           

(a) 47

(b) 36

(c) 39

(d) 43