Database Application Unit 4

Which of the following comparison operators is NOT EQUAL?

A. NOT
B. ^=
C. !=
D. <>
E. All of the above
F. None of the above

Which of the following is not a valid compound operator?

A. AND
B. OR
C. NOT
D. BETWEEN
E. All of the above
F. None of the above

Which of the following statements will display rows for a commission greater than 100 and less than 2000?

A. SELECT col1, col2, coln FROM table_name WHERE commission BETWEEN 101 AND 20001;
B. An identifier of columns in a relational table
C. SELECT col1, col2, coln FROM table_name WHERE commission > 100 AND commission <2000;
D. A column that identifies other columns in a table
E. SELECT col1, col2, coln FROM table_name WHERE commission BETWEEN 100 and 2000;
F. SELECT col1, col2, coln FROM table_name WHERE commission >= 100 AND commission <= 2000

Which of the following is a valid statement?

A. WHERE clause to limit the rows and HAVING clause to limit the groups
B. WHERE clause to limit the groups and HAVING clause to limit the columns
C. WHERE clause to limit the rows and HAVING clause to limit the columns
D. WHERE clause to limit the groups and HAVING clause to limit the groups

Which of the following is not an aggregate function?

A. COUNT
B. AVG
C. SUM
D. MED
E. All of the above
F. None of the above

Which of the following is a valid SQL statement?

A. SELECT col1, col2 FROM table_name WHERE col1 = value ORDER BY col1;
B. SELECT col1, col2 WHERE col1 = value FROM table_name OREDER BY col1;
C. SELECT col1, col2, FROM table_name WHERE col1 = value GROUP BY col2 ORDER BY col1;
D. SELECT col1, col2 FROM table_name WHERE col1 = value GROUP BY col1;

Which of the following SQL statements will display REP_ID column values in a sorted manner?

A. SELECT rep_id FROM SALES_REP ORDERED ASC;
B. SELECT rep_id FROM SALES_REP SORTED BY rep_id DESC;
C. SELECT rep_id FROM SALES_REP SORTED ASC;
D. SELECT rep_id FROM SALES_REP ORDER BY rep_id DESC;
E. All of the above
F. None of the above

Which of the following statements will list a specific record in a table?

A. SELECT col1, col2, FROM table_name col1 = value;
B. SELECT col1, col2, FROM table_name WHERE col1 = value;
C. SELECT col1, col2, table_name WHERE col1 = value;
D. SELECT col1, col2, FROM table_name WHERE col1 value;
E. All of the above
F. None of the above

Which query will return rows for a column that has no value?

A. SELECT col1, col2 FROM table_name WHERE col1 = "";
B. SELECT col1, col2 FROM table_name WHERE col1 = NULL;
C. SELECT col1, col2 FROM table_name WHERE col1 IS NULL;
D. SELECT col1, col2 FROM table_name WHERE col1 IS NOT NULL;

Which of the following is true of a subquery?

A. It is referred to as a query within a query
B. It is evaluated first
C. It is referred to as the inner query
D. Its results are used by the outer query
E. All of the above
F. None of the above