MySQL questions

1. To label and reference a column or table name WITHIN an sql by an different name use an _______

2. Which aggregate function will return the number of rows in a table? ________

3. Which value is returned from the following SQL statement... select ( 1 + 5 * 2 - ( 2 * 1 ));

A. "( 1 + 2 * 5 - ( 3 * 2 ))"

B. Error

C. 9

D. 5

4. All lower case letters in the english language exist in the "alphabet" table as a char data type. Which of the following will guarantee to output a list of letters in the alphabet sorted from "z" through "a".

A. select letter from alphabet group by letter;

B. select letter from alphabet order by letter;

C. select distinct letter from alphabet;

D.select letter from alphabet order by letter desc;

5. What syntax should be added to an SQL select statement to only return unique rows for the columns requested? _________

6. Which clause filters rows after a GROUP BY operation?

A. HAVING

B. LIMIT

C. WHERE

D. FILTER

7. Which following MySQL SQL clauses will cause at most 5 rows to be returned?

A. ROWNUM <= 5

B. LIMIT 5

C. TOP 5

D. LIMIT FIVE

8. Which of the following SQL statements is syntactically correct?

A. from books select price where title='data';

B. select price from books where title='data';

C. select title='data' from books where price;

D. select price where title='data from books;

9.

For the table... people(person_id,first_name,last_name) ...which columns will be shown when executing the following SQL statement... SELECT * FROM people;

A. None.

B. "person_id"

C. "person_id", "first_name" and "last_name"

D. "first_name" and "last_name"

10. For the following SQL statement...

select title from books where title like 'not%'; ...which "may" be possible values return assuming they exist as a "title" the "books" table.

A. "nothing"
B. "not"
C. "NOT"
D. "another"