(Paper) Oracle Job Interview Latest Placement Paper 2011

Oracle Job Interview Latest Placement Paper: 2011

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