php chapter 18

Which of the following isn't a valid column alias? A. total B. total sales C. total_sales D. "Total Sales"

B. total sales

Which clause in a SQL statement will only allow the retrieval of a maximum number of rows? A. LIMIT B. RESTRICT C. MAX D. NUMBER

A. LIMIT

Which of the following is used as a wildcard in a SQL statement to specify that all columns should be retrieved? A.asterisk (*) B. exclamation point (!) C. question mark (?) D. dollar sign ($)

A. asterisk (*)

A _____ is used in a SQL statement to combine columns from two or more tables into a result set. A. join B. sort C. combine D. wildcard

A. join

Which of the following is NOT a comparison operator in a SQL statement? A.<> B. != C. = D>

B. !=

_____ functions perform calculations on the values in a set of selected rows in a SQL query. A. Illegal B. Ideal C. Aggregate D. Computational

C. Aggregate

Which of the following LIMIT clauses will return a maximum of five rows starting with the eleventh row in the result set? A. LIMIT 10, <= 5 B. LIMIT 11, <= 5 C. LIMIT 10, 5 D. LIMIT 11, 5

C. LIMIT 10, 5

In an SQL statement, the _____ clause specifies the rows to retrieve. A.SELECT B.FROM C. WHERE D. ORDER BY

C. WHERE

If introduced as follows, the subquery can return which of the values listed below?FROM (subquery) A. a single value B. a column of one or more rows C. a table D. a subquery can't be introduced in this way

C. a table

In a join, column names need to be qualified only A.in inner joins B. in outer joins C. when the code is confusing D. when the same names are used in both tables

D. when the same names are used in both tables