Interview ... Some Suggestion

Here r a few suggestions to face the viva in any database related post. Hope it will help u.

Programming
-----------

• Basic programming concepts and common problems.
• Example: calculate factorial, Fibonacci series etc.
• Needed language/script: C/C++, JAVA, PHP, ASP, .NET, mysql query
  

Unix
-----

• Basic Unix Commands
• Shell Scripts
• Linux job scheduler
  

Oracle
------

• All types of SQL commands (Specially ALTER TABLE commands)
• Built in Functions like TO_DATE, ADD_MONTHS, TO_CHAR, ROUND .. I mean all the common and frequently used functions.
• PL/SQL: Functions and Procedures
• Memory Management: In details
• Optimizer, Execution plan etc
• Performance tuning: SP Report, TKPROF, Indexing etc
• Backup and Recovery: RMAN
  

Well, thats all for today. Follow these guideline. Hopefully u will get more than 60% common from here.

Cheers!