Self-study assessment
Transact-SQL Basics - Quiz Results
You can only take a quiz once. These results are from the first time you took this quiz.Explanation of answers
The answers you selected are indicated below, along with text that explains the correct answers.
| 1. |
What is the relationship between Transact-SQL and SQL-92? Please select the best answer. |
|
| A. | Transact-SQL conforms to the SQL-92 standard, but adds SQL Server 7 functionality. | |
| B. | SQL-92 conforms to the Transact-SQL standard, but adds SQL Server 7 functionality. | |
|
|
C. | Transact-SQL is just another name for SQL-92. |
|
|
The correct answer is A. Transact-SQL conforms to the SQL-92 standard, but adds functionality specific to SQL Server 7. B is incorrect because SQL-92 does not contain SQL Server 7 functionality. C is incorrect because Transact-SQL is NOT the same thing as SQL-92. | |
| 2. |
For which of the following categories does Transact-SQL provide commands? Please select all the correct answers. |
|
|
|
A. | Distributed queries |
|
|
B. | Serial queries |
|
|
C. | Parallel queries |
|
|
D. | Enhanced cursor support |
|
|
E. | Distributed authentication |
|
|
The correct answers are A, C, and D. Transact-SQL provides commands for distributed queries, parallel queries, and enhanced cursor support. B and E are incorrect because there are no such terms as serial query or distributed authentication within the SQL Server lexicon. | |
| 3. |
The query optimizer does which of the following? Please select all the correct answers. |
|
|
|
A. |
Uses OLE DB to communicate with database storage facilities
|
|
|
B. | Determines the best cost-based execution strategy for SQL Server 7 |
|
|
C. | Determines which, if any, indexes should be used to speed up the query |
| D. | Computes statistics related to your queries | |
|
|
The correct answers are B and C. Among other functions, the query optimizer determines the best cost-based execution strategy for SQL Server 7 and determines which, if any, indexes should be used to speed up the query. A is incorrect because it's the query processor that uses OLE DB to communicate with database storage facilities. D is incorrect because it's also the query processor that computes statistics related to your queries. | |