2016-08-08 Two-year mock exam

A:

B:

C:

D:

The answer is a. The "Select @avgPrice =avg (bookprice) from book" statement in the topic calls the AVG () function to get the average price of the books, whereas option C and option D refer to the highest price, so options C and D are wrong. In the IF statement, use the conditional expression "(@avgPrice >80)" To determine whether the value of the local variable @avgprice is greater than 80. If it is greater than 80, the query results are sorted in descending order by the DESC keyword in the ORDER BY clause, and the top keyword is used to output the 10 most expensive book information. Instead of the query described in option B, the lowest price of the 10 book information

(select two items)

• B:

• C:

• D:

In the definition stored procedure, displays the user-defined error message, may use Paiserror and print, if processing should be the return statement, therefore excludes b,d. The correct option is a,c.

2016-08-08 Two-year mock exam