SQL Practice Final Exam Answers

A relational database _____. - Answer- consists of tables called relations Which command(s) can you use to delete an entire table and its data? - Answer- DROP TABLE Which element belongs in the blank if you want to display data from all rows with a credit limit greater than the credit limit of one or more category B cardholders? WHERE (CREDIT_LIMIT _____ (SELECT CREDIT_LIMIT FROM CARDHOLDER WHERE CATEGORY = 'B')) - Answer- ANY Which of the following is a valid SQL command? - Answer- DROP TABLE LEVEL1_CUSTOMER; When a subquery involves a table listed in the outer query, the subquery is called a(n) _____. - Answer- correlated subquery What do you need to know to complete the FIRST step in the process of creating a new table using data from an existing table, called CANDY, in MySQL? - Answer- the columns from CANDY that you want to include and their characteristics KimTay sells _____. - Answer- pet supplies James has created a new MySQL table called FAVORITES and would like to populate it with data from the existing CANDY table. Which command can he use to add data for rows with a rating of seven or more? - Answer- INSERT INTO FAVORITES (SELECT ID, NAME, PRICE, RATING FROM CANDY WHERE (RATING 7)); Which is the correct sequence of elements for a SQL command that will change a value in an existing table row? - Answer- UPDATE, table name, SET, column name, equal sign, new value Which command should Josephine use if she would like to add a new row to the BMI table in MySQL? - Answer- INSERT INTO BMI VALUES ('Emily', 'Cross', 66, 115); To list all the columns in a table and their properties in MySQL, use the LIST COLUMNS command. - Answer- False How does the procedure for adding rows to an existing MySQL table compare to that for populating a new table that has just been created? - Answer- They are identical. Which is the correct sequence of elements in a command to remove rows from a MySQL