Answer Happy

Question 8 For a table called "Album that contains "Album Name", "Release Date", and "Song Count', what is the proper short hand to represent this table? ALBUM ALBUM NAME: RELEASE DATE; SONG COUNT ALBUM: ALBUM NAME, RELEASE DATE, SONG COUNT ALBUM ALBUM NAME, RELEASE DATE SONG COUNT) ALBUM ALBUM NAME, RELEASE DATE SONG COUNT D Question 9 Using the SOLMARIS Database, answer the question below. How many tables are directly related to the CONDO UNIT table? Question 10 Which of the following statements is true? When using a held combined with a function, you must use the HAVING clause When using a field combined with a function, you must use the GROUP BY clause The HAVING clause is interchange-able with the WHERE clause When using GROUP BY, you must use HAVING Question 11 Based on the table definition below, what's wrong with the query below? ALBUM (ALBUM ID, NAME, YEAR_RELEASED, NUM_OF_SONGS) SELECT YEAR_RELEASED, COUNT(*) FROM ALBUM It's missing the WHERE clause Nothing is wrong with it It's missing the GROUP BY clause It's missing the HAVING clause Question 12 Assuming the tables and fields shown in the queries below exist, which statement best describes these queries. SELECT * FROM ALBUM, ARTIST WHERE ALBUM ARTIST_TD ARTIST, ARTIST_TD; SELECT * FROM ARTIST JOIN ALBUM ON ARTIST.ARTIST_ID - ALBUM.ARTIST_ID; They both return the same data They both have improper syntax They will each return different results from each other One of them has improper syntax