Database Interview Questions - CGI

1. How efficient you are in oracle and SQL server?
2. What is E-R diagram?
3. What is the relationship that exists inside in E-R diagram?
4. Differentiate between unique key and foreign key?
5. What are indexes in oracle?
6. Write a query to retrieve for many to many relationships?
7. Write a query to get maximum and second maximum in oracle?
8. How do you pass parameter in stored procedure?