They asked all basic questions in SQL and PLSQL . Basic queries on aggregate functions,group by,having clauses ; mainly on types of sub queries and joins,indexes,cursor,exception handling; examples for ref cursor,collections; difference between truncate and delete , v array and nested tables,procedure and functions , rank and dense rank; some depth questions on triggers and query to write trigger ; new features introduced in oracle 11 g.

Interview questions were easy but we have to analyse the question