What does the following SELECT statement do?

SELECT Age FROM People WHERE LastName = 'Purple'

a) It selects the age of the person (or people) with the last name Purple from the People table.
b) It selects the value Purple from the Age table of the People database.
c) It selects the age of the person with the last name Purple from the People database.
d) It selects the People field from the Age table with the LastName value Purple.


Answer: A

Computer Science & Information Technology

You might also like to view...

Suppose there are only two constructors for a class, one that passes in a single integer parameter called amount, for setting an amount data member, and another that passes in a single integer parameter called code, for setting a code data member. Which of the following is true?

A. An error exists in the class. B. Everything will be fine as long as the program can tell the difference between amount and code. C. We need to use a Peterson Language Modifier. D. We need to use different return types for the constructors.

Computer Science & Information Technology

The _________ is the notation that indicates a file's location on a computer. A. path B. route C. track D. trail

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Outlook automatically formats ____________________ so that recipients can use them to access a website directly.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Describe the main characteristics of two-dimensional arrays. How do you access an element in a two-dimensional array? What are some synonyms for a two-dimensional array?

What will be an ideal response?

Computer Science & Information Technology