Macromedia ColdFusion MX 7 Certified Developer Study Guide

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?

  1. SELECT

  2. INSERT

  3. UPDATE

  4. 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

  1. Inner

  2. Equi

  3. Right outer

  4. Full outer

3:

Which of these keywords are used in JOIN statements?

  1. INNER

  2. SELF

  3. LEFT

  4. FULL

Related

Категории