Software - db

1. What is SQL?  
2. What is SELECT statement?
3. How can you compare a part of the name rather than the entire name?
4. What is the INSERT statement?
5. How do you delete a record from a database?
6. How could I get distinct entries from a table?
7. How to get the results of a Query sorted in any order?
8. How can I find the total number of records in a table?
9. What is GROUP BY?
10. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table?
11. What are the Large object types suported by Oracle?
12. Difference between a "where" clause and a "having" clause?
13. What's the difference between a primary key and a unique key?
14. What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
15. What are triggers? How to invoke a trigger on demand?
16. What is a join and explain different types of joins?
17. What is a self join?