Oracle Placement Paper III

Oracle Placement Paper Pattern & Interview On 2011 @ Mumbai

Paper Pattern:

30 Technical Questions – Time 30 minutes. Mostly on DBMS, Oracle (like what would be the output), C, C++, Java (2-3 Questions on class and constructors) and data structures. 30 General Questions – Time 30 minutes.7 Aptitude Questions, 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 judgment, etc.)
The technical test would be easy and 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)?
Ans. A macro in MS-word is used to group a sequence of jobs and make it as a button or
keyboard shortcut. Suppose, if you need always to draw a table containing 2 rows and 5 cols,you can start,record a macro and make it as a button and 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?
Ans. In oracle fine, 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 and by which data type?
Ans. Yes, you can and it can be achieved by using a BLOB (binary large object) type and
store up to 4GB in a single column.
 

4. Have you used reports and forms in oracle?
 

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

6. Some DOS commands and UNIX.
 

7. Project description (both academic and mini projects, if any)
 

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