Summary

Relational database design is an important part of application design in general, and one that has a significant impact on everything from application performance to data manageability to resource usage to SQL complexity. Relational data is joined for retrieval, and several join types are supported (the most common being the INNER JOIN). Tables are usually joined by their primary and foreign keys.

Sample Questions

1:	Which statement is used to join tables? SELECT INSERT UPDATE DELETE
2:	What kind of join is being used in this statement? SELECT customers.customer_name, customers.customer_id, orders.order_id, orders.order_date FROM customers, orders WHERE customers.customer_id=*orders.customer_id Inner Equi Right outer Full outer
3:	Which of these keywords are used in JOIN statements? INNER SELF LEFT FULL