PL/SQL interview questions...

o Normalize many to many relationships
o Difference - Equijoin and union
o What is TEMP table space in Oracle, what is rollback segment
o How do we find row chaining?
o Pattern matching operators
o Features in oracle 9i and 10g
o Why truncating table is faster than delete
o copy commit syntax
o Convert Zulu time zone to US Eastern time zone
o Difference - union and union all
o Difference - Group by, Order by clause
o Which Ranking functions are available?
o Difference - Decode, NVL, NVL2
o Tradeoffs of using partitioned tables
o How can we call stored procedure in SQL query
o What are the restrictions on calling PL/SQL from SQL
o Why EXISTS is preferable to distinct
o Give 2 examples of avoiding unnecessary parsing.