QUESTIONS AND ANSWERS FULL
SOLUTION
●● Which statement about the logical operators is true?.
Answer: The order of operator precedence is AND, NOT, and OR.
The order of operator precedence is NOT, OR, and AND.
*A=The order of operator precedence is NOT, AND, and OR.
The order of operator precedence is AND, OR, and NOT.
●● Which of the following best describes the meaning of the LIKE
operator?.
Answer: Display rows based on a range of values.
To find Null values.
To test for values in a list.
*A=Match a character pattern.
, ●● You need to change the default sort order of the ORDER BY clause
so that the data is displayed in reverse alphabetical order. Which
keyword should you include in the ORDER BY clause?.
Answer: SORT
ASC
CHANGE
*A=DESC
●● Which statement about the ORDER BY clause is true?.
Answer: *A=You can use a column alias in the ORDER BY clause.
The ORDER BY clause should immediately precede the FROM clause
in a SELECT statement
The ORDER BY clause can only contain columns that are included in
the SELECT list.
The default sort order of the ORDER BY clause is descending.