Partner Sites
Oracle placement paper
Computer Science Knowledge(30 questions)
1. What is the main component of operating system
2. You are the administrator of your company's network. You are configuring the security policy for a group of users in the finance organizational unit (OU). You need to configure a group policy so that future changes to group policy will be applied within 15 minutes to any computers that are log on to the network. What should you do?
A. Enable the background refresh settings to use the default group policy refresh date
B. Enable the asynchronous group policy application settings
C. Enable and configure the group policy refresh interval for domain controller
D. Enable and configure the group policy refresh interval for computers
E. None of above
Ans-D
3. The Memory Buffer Register (MBR)
A. is a hardware memory device which denotes the location of the current instruction being executed.
B. is a group of electrical circuits (hardware),that performs the intent of instructions fetched from memory.
C. contains the address of the memory location that is to be read from or stored into.
D. contains a copy of the designated memory location specified by the MAR after a "read" or the new contents of the memory prior to a "write".
E. None of the above
Ans-D
4. Page stealing
A. is a sign of an efficient system
B. is taking page frames from other working sets
C. should be the tuning goal
D. is taking larger disk spaces for pages paged out
E. None of the above
Ans-B
5. What are the different process states in an operating system?
6. If you are using C language to implement the heterogeneous linked list, what pointer type will you use?
Ans-Void Pointer
7. What is the major data structures used in RDBMS,
Ans-Array
8. What is the major data structures used in Network data model & Hierarchical data model.
Ans-Graph,Trees
9. Primitive operations common to all record management systems include
A. Print
B. Sort
C. Look-up
D. All of the above
E. None of the above
Ans-C
10. What is the data structures used to perform recursion?
Ans-Stack
11. Check whether 2^(n+1) = O(2^n)?
12. state the big o of the following fragment:
sum =0;
for (int i=1; i<n; i++) {
for (int j=1; j< n/i; j++) {
sum = sum +j;
}
}
Ans- O(n log n)
13. What's the correct big O notation for an algorithm that runs in triangular time?
func(x):
for i in 0..x
for j in 0..i
do_something(i, j)
14. What will be the Big O notation for the function 100*x8 + 20*x2 + 12?
Ans- O(x8)
15. 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
16. What are the main underlying concepts of object orientation?
17. What are models and Meta models?
18. Differentiate the class representation of Booch, Rumbaugh and UML?
19. Using ODL, you can define which of the following?
A. Attribute
B. Structure
C. Operation
D. All of the above.
Ans-D
20. Multiplicity is the same as what concept for an ERD?
A. Relationship
B. Attribute
C. Entity
D. Cardinality
Ans-D
21. What are the disadvantages in File Processing System?
22. What is durability in DBMS?
23. What are the different phases of transaction?
Ans- 1.) Analysis phase,
2.) Redo Phase,
3.) Undo phase.
24. Which prefixes are available to Oracle triggers?
A. :new only
B. :old only
C. Both :new and :old
D. Neither :new nor :old
Ans-C
25. What Oracle backup and recovery file contains user and system data?
A. Control file
B. Datafile
C. OnLine ReDo file
D. Offline ReDo file
Ans-B
26. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?
A. Full backup
B. Consistent backup
C. Inconsistent backup
D. Differential backup
Ans-B
27. Composition is a stronger form of which of the following?
A. Aggregation
B. Encapsulation
C. Inheritance
D. All of the above.
Ans-A
28. Which SQL-92 standard SQL command can be used to change a table name?
A. RENAME TABLE
B. CHANGE TABLE
C. ALTER TABLE
D. None of the above is correct.
Ans-D
29. Changing cardinalities in a database is:
A. a common database design task.
B. a rare database design task, but does occur.
C. a database design task that never occurs.
D. is impossible to do, so a new database must be constructed and the data moved into it.
Ans-A
30.If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
A. All fields are stored in one relation.
B. All fields are stored in two relations.
C. All fields are stored in three relations.
D. All fields are stored in four relations.
Ans-B
English(25 questions)
1. 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. of 2. we 3. Heard 4. him 5. had
A. 42351
B. 52341
C. 25341
D. 25431
E. 25314
Ans-E
2. 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. not 2. Hari 3. Away 4. run 5. did
A. 13542
B. 35412
C. 52431
D. 25143
E. 21345
Ans-D
3. 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
his powerful desire brought about his downfall.
A. His intense desire
B. His desire for power
C. His fatal desire
D. No improvemen
Ans-B
4. 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 logic of Berlin wall already had been undermined but when the news came through that the wall itself had been opened I jumped into a car.
A. had been undetermined already
B. had already been undetermined
C. had been already undetermined
D. No improvement
Ans-B
Questions(5-6) Which of phrases given below each sentence should replace the phrase printed in bold type to make the grammatically correct?
5. I need not offer any explanation regarding this incident - my behaviour is speaking itself.
A. will speak to itself B. speaks for itself
C. has been speaking D. speaks about itself
E. No correction required
Ans-B
6. He is too important for tolerating any delay.
A. to tolerate
B. to tolerating
C. at tolerating
D. with tolerating
E. No correction required
Ans-A
In questions(7-9),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.
7.
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.
S1: Minnie went shopping one morning.
P : Disappointed She turned around and returned to the parking lot.
Q : She got out and walked to the nearest shop.
R : She drove her car into the parking lot and stopped.
S : It was there that she realised that she'd forgotten her purse at home.
S6: She drove home with an empty basket.
The Proper sequence should be:
A. RSQP
B. RQSP
C. PQRS
D. QPRS
Ans-B
9.
S1: Far away in a little street there is a poor house.
P : Her face is thin and worn and her hands are coarse, pricked by a needle, for she is a seam stress.
Q : One of the windows is open and through it I can see a poor woman.
R : He has a fever and asking for oranges.
S : In a bed in a corner of the room her little boy is lying ill.
S6: His mother has nothing to give but water, so he is crying.
The Proper sequence should be:
A. SRQP
B. PQSR
C. QPSR
D. RSPQ
Ans-C
Questions (10-12) the sentences have been given in Active/Passive voice. From the given alternatives, choose the one which best expresses the given sentence in Passive/Active voice.
10. They greet me cheerfully every morning.
A. Every morning I was greeted cheerfully.
B. I am greeted cheerfully by them every morning.
C. I am being greeted cheerfully by them every morning.
D. Cheerful greeting is done by them every morning to me.
Ans-B
11. She spoke to the official on duty.
A. The official on duty was spoken to by her
B. The official was spoken to by her on duty.
C. She was spoken to by the official on duty.
D. She was the official to be spoken to on duty.
Ans-A
12. The doctor advised the patient not to eat rice.
A. The patient was advised by the doctor not to eat rice.
B. The patient was advised by the doctor that he should not eat rice.
C. The patient was being advised by the doctor that he should not rice by the doctor.
D. The patient has been advised not to eat rice by the doctor.
Ans-A
13. Choose the one which best expresses the given sentence in Indirect/Direct speech.
He said to his father, "Please increase my pocket-money."
A. He told his father, "Please increase the pocket-money"
B. He pleaded his father to please increase my pocket money.
C. He requested his father to increase his pocket-money.
D. He asked his father to increase his pocket-money.
Ans-C
14. Can you help me? I _____ a post office.
A. am looking for
B. look for
C. am look for
d. looking for
Ans-A
15. It's wrong. You_____ do it.
A. shouldn't to
B. needn't
C. don't have to
D. shouldn't
Ans-D
16. When the police arrived, the criminals _____ escaped.
A. were already
B. already
C. had already
D. have already
Ans-C
17. If I _____ in your position then, I would have told the truth.
A. have been
B. was
C. were
D. had been
Ans-B
18. They've moved to a different house _____ their children can attend a better school.
A. So as
B. in order
C. so that
D. for
Ans-C
19. In the question given below a word is printed in bold. Below it four choices are given. Pick up the one which is most nearly the same in meaning as the word printer in bold and can replaces it without altering the meaning of the sentence.
The attitude of Western countries towards the Third World Countries is rather callous to say the least.
A. passive
B. unkind
C. cursed
D. unfeeling
Ans-D
20. Working under pressure always brings _____ the best in him.
A. out
B. up
C. through
D. across
Ans-A
Questions (21-25) Read the passage given and answer the questions that follow
21.
Nationalism, of course, is a curious phenomenon which at a certain stage in a country's history gives life, growth and unity but, at the same time, it has a tendency to limit one, because one thinks of one's country as something different from the rest of world. One's perceptive changes and one is continuously thinking of one's own struggles and virtues and failing to the exclusion of other thoughts. The result is that the same nationalism which is the symbol of growth for a people becomes a symbol of the cessation of that growth in mind. Nationalism, when it becomes successful sometimes goes on spreading in an aggressive way and becomes a danger internationally. Whatever line of thought you follow, you arrive at the conclusion that some kind of balance must be found. Otherwise something that was good can turn into evil. Culture, which is essentially good become not only static but aggressive and something that breeds conflict and hatred when looked at from a wrong point of view. How are you find a balance, I don't know. Apart from the political and economic problems of the age , perhaps, that is the greatest problem today because behind it there is tremendous search for something which it cannot found. We t
