CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary Life/cis336study.com | Page 87

Question 2.( TCO 9) If the _____ clause of the UPDATE command is omitted, then all the rows in the specified table will be changed.

Question 3.( TCO 6) Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

Question 4.( TCO 8) Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of different categories contained in the table?

Question 5. valid SQL command?

( TCO 9) Which of the following is not a

Question 6.( TCO 8) Based on the contents of the BOOKS table shown below, which of the following SQL statements will return the total profit generated by books in the COOKING category?

Question 7.( TCO 8) Before the COMMIT command is used, you can retrieve deleted records by using the _____ command.

Question 8.( TCO 8) Based on the contents of the BOOK _ ORDER table shown below, which of the following SQL statements will list the order number and customer number for the most recent orders in the system?

Question 2.( TCO 9) If the _____ clause of the UPDATE command is omitted, then all the rows in the specified table will be changed.

Question 3.( TCO 6) Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?

Question 4.( TCO 8) Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of different categories contained in the table?

Question 5. valid SQL command?

( TCO 9) Which of the following is not a

Question 6.( TCO 8) Based on the contents of the BOOKS table shown below, which of the following SQL statements will return the total profit generated by books in the COOKING category?

Question 7.( TCO 8) Before the COMMIT command is used, you can retrieve deleted records by using the _____ command.

Question 8.( TCO 8) Based on the contents of the BOOK _ ORDER table shown below, which of the following SQL statements will list the order number and customer number for the most recent orders in the system?