Interview Question's

**************************************************   Oracle  ************************************************************
1. What is the difference between DBMS and RDBMS?
2. What is difference between logical schema and Physical Schema?
3. What is the difference between Truncate, Delete and Drop commands?
4. What is the difference between Simple View and Complex Views?
5. What is the difference bewtween Procedures and Functions?
6. What is a Package?
7. What are the different types of Triggers in a Database?
8. What is index and differnt types of indexes?
9. What are the different aggregrate function's in oracle database?
10. What is instance?
11. What is the difference between SQL and PL/SQL?

**************************************************   Oracle DBA  ************************************************************
1. What are the different background processes in oracle database?

**********************************************   Oracle App's DBA   *******************************************************
1. Difference between R12.1 and R12.2 ?
2. Diference between FNDCPASS and AFPASSWD?