• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

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?
  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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint