Monday 29 April 2013

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.

No comments:

Post a Comment