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:
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.
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.
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.
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.
