Self-study assessment
Transact-SQL Basics - Quiz
Each question is worth one point. Select the best answer or answers for each question.
| 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. |
|
| 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 |
|
| 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 |
|