Cognizant PL SQL Developer interview questions

Joins, Acid properties, constraints, diff types, aggregate functions, how to improve performance, cursor types of cursor, triggers type of triggers, views and materialized views diff also, operators bulk collect and for all statement,indexing, n its types, clustered and non-clustered index diff,correlated query,partitions, diff b/w truncate and drop, dml ddl n dcl commands, normalization, hierarchical representation from any table write a query, mutating error, instead of trigger indirect use, one question from package

Difference between ASM and ADDR report