W09 Quiz Prove Introduction to Databases

School: Brigham Young University, Idaho - Course: CIT 111 - Subject: Accounting

W09 Quiz: Prove DueNov 13 at 6:59amPoints20Questions10Time LimitNone Allowed Attempts2 Attempt History AttemptTimeScore KEPTAttempt 23 minutes20 out of 20 LATESTAttempt 23 minutes20 out of 20 Attempt 125 minutes14 out of 20  Correct answers are hidden. Score for this attempt:20 out of 20 Submitted Nov 7 at 4:36am This attempt took 3 minutes. 2 / 2 pts Question 1 If you want to joinall of the rowsin the first table listed with just the matched rows in a second table, you use a/anjoin. RIGHT OUTER LEFT OUTER FULL OUTER INNER 2 / 2 pts Question 2

SELECT vendor_name, invoice_date FROM vendors v JOIN invoices i ON v.vendor_id = i.vendor_id The 'v' in this example of code is known as a/an. table alias filter column alias index 2 / 2 pts Question 3 In most cases, the join condition in the ON clause of an inner join uses the operator to compare two keys. = JOIN WHERE <> 2 / 2 pts Question 4

You can simulate a full outer join by using. a union a left outer join the ON clause a right outer join 2 / 2 pts Question 5 In most cases, the join condition of an inner join compares the primary key of one table to thekey of another table. null foreign indexed primary 2 / 2 pts Question 6 SELECT vendor_name, invoice_date FROM vendors v JOIN invoices i ON v.vendor_id = i.vendor_id

This type of join is called a/anjoin. RIGHT OUTER FULL OUTER INNER LEFT OUTER 2 / 2 pts Question 7 A tablecan be used when you want to assign a temporary name to a table.