depends upon the type of company in which u r going for interview. In small companies coding/database admin/testing/maintainence is done by same set of people. So they may ask little difficult questions as well. Once i was asked to design database of a email server. Many times i have been asked to write queries(and they were not simple for me atleast).
Prakash Dwivedi (SCJP2, SCWCD, SCBCD)
"Failure is not when you fall down, Its only when you don't get up again"
Some of the questions are: 1)How do you write stored procedure and exexute in java(Show me step by step ) 2)Oracle related Can I execute java function from PL/SQL How?) 3)How will you write a query to retrieve say,5th,10th,15th etc rows from a table?