Answer Happy

Question 13 Assuming the fields and tables exist, which ariswer best describes the syntax error if one exists in the query below? SELECT ARTIST.NE, ALBUM. WE FROM ALBUM, ARTIST ON ALBUM ARTIST_ID - ARTIST ARTIST_ID; Nothing is wrong with it There is a syntax error in the SELECT ise O It's missing the WHERE clause None of these is the correct answer The ON clause should not be there Question 14 Match the definition on the right to the concept on the left. Assume that we're only dealing with two tables in any join for the purposes of this question. LEFT JOIN Choose RIGHT JOIN I Choose V OUTER JOIN Choose FULL JOIN Choose Question 15 Which of the following queries is an inner join? Sclect all (if any) that apply, A] SELECT ARTIST.NE, ALBUM.MOVE FROM ALBUM INNER JOIN ARTIST ON ARTIST ARTIST_ID - ALBUM. ARTIST.1); B) SFI FET ARTIST NAHE, A MNYE FROM ALBUM FULL MIN ARTIST ON RITST, ARTIST_TON BIHARITST_TO; C] SELECT ARTIST.NE, ALBUM NAYE FRON ALBUM, ARTIST MIERE ARTIST ARTIST_ID - ALBUM.ARTIST_ID; D SELECT ARTIST.NE, ALBUM. NAME FRON ALBUY RIGHT JOIH ARTIST ON ARTIST.ARTIST ID - ALBUM. ARTIST ID; E] SELECT ARTIST.KOHE, ALBUM.MEVE FRON ALBUM JCIN ARTIST ON ARTIST ARTIST_ID - ALBUY ARTIST_ID; F SELECT ARTIST.NE, ALB.M.NAME FRON ALBUM LEFT JOIN ARTIST ON ARTIST.ARTIST ID - ALBUM ARTIST ID: NA DB IC DF DE D Question 16 The ANY keyword is not supported in MYSQL True O False Question 17 In order to compare the cost of a product to the least experisive (but not necessarily the most experisivel the product in a database, which key word could be used in the query? Select]