13 Consider The Following Two Sql Snippets Referring To A Database For A Hypothetical Store Select Products Name Sel 1 (70.37 KiB) Viewed 41 times
13. Consider the following two SQL snippets, referring to a database for a hypothetical store: SELECT products.name, sellers.name FROM products INNER JOIN sellers ON products.seller_id = sellers.id; SELECT products.name, seller.name FROM products LEFT JOIN sellers ON products.seller_id = sellers.id; Assume that products.seller_id is a foreign key referring to sellers.id; also assume that all products have sellers, but not all sellers have products. Will these two queries produce the same results? (4 Points) The two queries will produce the same results. The first query will produce rows that the second query won't. The second query will produce rows that the first query won't. Each query will produce rows that the other won't. There isn't enough information to tell.
11. True or false: once a row has been added to the table, it can be modified or nulled, but it cannot be completely erased. (2 Points) True False 12. Which of the following is not a fundamental SQL operation? (2 Points) O UPDATE OBRANCH FORK SELECT D More than one of the above is not a fundamental operation All of the above are fundamental operations
8. True or false: you can use an inner join to join a table to itself. (2 Points) True False 9. True or false: you can use a left outer join to join a table to itself. (2 Points) True False 10. True or false: a right outer join is logically equivalent to an inner join, but has a different performance profile. (2 Points) True False
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!