2008 Oracle Corporation Placement Interview test paper 2

PAPER 3(this is very easy paper to land the job)

30 Questions. technical - 30 mins. - mostly on DBMS, Oracle(like what would be the output), C, C++, Java(2-3 Questions. on class & constructors) & data structures.



30 Questions. general - 30 mins. - 7 Questions. aptitude, more like English (filling up prepositions, same meaning, reading comprehension, four sentences would be given - you have to order them to form a paragraph, similarly four questions would be given - you have to say which one is a inference statement, which one is a judgement,etc.)



The technical test would be easy & general test would be little difficult.





In the interview, they asked me the following questions.

=============



1. what are the macros other than C macros (the macros in word,excel)

A macro in MS-word is used to group a sequence of jobs & make it as a button or keyboard shortcut.

Suppose, if you need always to draw a table containing 2 rows & 5 cols, you can start,record a macro &

make it as a button & put in taskbar, so that when you press it, you will be provided with a fixed table.


2. can you delete a column from a table. In oracle 9i, you can do it by the statement

ALTER TABLE table1 DROP COLUMN column1; In oracle 8,you can,t.



3. can you store a image in oracle & by which datatype? Yes, you can & it can be acheived by using a BLOB (binary large object) type & store upto 4GB in a single column.



4. have you used reports & forms in oracle?



5. have you written applications to retrieve stored images in a table?



6. some DOS commands & UNIX.



7. project desription (both academic & miniprojects,if any)



8. some situation questions like what would you do if your company is burning,etc.







PAPER 4



1. It contains 30 Questions of SQL + PL/SQL & the TIME allocated

is 30 minutes

STRICTLY!



2. After test (15 Mins.) a Oracle guy declared test results by announcing the full name of candidates & apologising to others. Very Polite.



3. Then another test for Programming is there.



4. After this they have to go for the round of Interviews.I remembered some questions from the Test Paper:

(I wish this will help others in their preparations)

(THESE QUESTIONS ARE IN RANDOM ORDER)



Q. 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)));



Q. When there is a failure in fetching the rows from a cursor...

A. %ISOPEN

B. %NOTFOUND

C. %FOUND

D. %ROWCOUNT



Q. SELECT ,ORACLE, FROM DUAL WHERE NULL = NULL;

A. ORACLE

B. NULL

C. ERROR OUT

D. NO ROWS SELECTED



Q. There is a question of Package body & Package Specification, they have provided the code for that describing the scenario of movie_tickets_sold & asked the programmer to insert a block of code...., where that code block to be inserted? In Package body? or in Package Specification?



Q. Which of the following operator is not used in Outer Join?

a. =

b. !=

c. &

d. OR



Q. PL/SQL uses which of the following

a. Early Binding

b. Late binding

c. No Binding

d. Deferred Binging



Q. followin is a database trigger,



CREATE OR REPLACE TRIGGER delete_row

ON DELETE did not remember the complete code for this ...

....



if table contains 100 rows & it is truncated, how many rows get

updated

a. 0

b. 1

c. 100

d. No rows updated