Database interview questions

1. Trigger types
2. Transaction handling in oracle pl/sql
3. Clustered and Non-Clustered index 
4. SQL Query related interview question
5. Oracle general interview question - 1
6. Oracle general interview question - 2
7. Max number existing in any of the tables
8. Identifying left outer and right outer join
9. Difference between DBA and SYSDBA
10. What is table partitioning and when it should be done
11. Queries for table partitioning
12. Partitioning existing table using exchange partition
13. Partitioning existing table using dbms_redifinition
14. Getting table partition related information using all_tab_partition
15. SQL interview question series

     Analytic Interview Questions -

1. Handling table's heirarchical data in query
2. Analytical function query 
3. Analytical function based query