Placement Papers: Oracle Paper Sample
Doorsteptutor material for CTET/Paper-1 is prepared by world's top subject experts: get questions, notes, tests, video lectures and more- for all subjects of CTET/Paper-1.
30 qns. Technical-30 mins. mostly on DBMS, Oracle (like what would be the output) , C, C ++ , Java (2 − 3 qns. On class and constructors) and data structures.
30 qns. General-30 mins. 7 qns. 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 and general test would be little difficult.
In the interview, they asked me the following questions.
== == == == == == =
- 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 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, sothat when you press it, you will be provided with a fixed table.
- 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.
- can you store a image in oracle and by which datatype? Yes, you can and it can be acheived by using a BLOB (binary large object) type and store upto 4GB in a single column.
- have you used reports and forms in oracle?
- have you written applications to retrieve stored images in a table?
- some DOS commands and UNIX.
- project desription (both academic and miniprojects, if any)
- some situation questions like what would you do if your company is burning, etc.
Please have a look on DBMS, and some simple queries like, select ⚹ from dual, for the technical
test. And on the questions in the attached file. All the best.