Retrieving Data › Review

Review

Choose the correct answers for the questions below. More than one answer can apply for each question.

1. How many columns would be retrieved by the following statement:

   select * from sample_table;
   

   • a. One
   • b. Five
   • c. All
2. How can you limit the number of columns returned by your SELECT statement?
   • a. Use a FROM clause
   • b. List the columns you want to see
   • c. Use * after SELECT
   • d. Leave out the * between SELECT and FROM
3. How can you give heading names to columns?
   • a. Put a comma after the column name and specify the heading
   • b. Use AS after the column name and specify the heading
   • c. Use the heading in place of the column name
4. Given a table called SUPPLY_PRICE and a column in that table called PART_NUMBER, which of the following statements will find the number of unique part numbers in the table?
   • a. select part_number from supply_price;
   • b. select * from supply_price;
   • c. select distinct part_number from supply_price;
   • d. select part_number distinct from supply_price;
5. How can you name the column you want to sort by?
   • a. Use the column name
   • b. Use the heading name
   • c. Use the table name
   • d. Use the column number

To check your answers, see Review Answers for Chapter 3.