SQL Server 2000 – True or False

6. SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.

A. True
B. False

Correct Answer:  B. False
Advertisement

7. SQL Server supports two kinds of indexes: clustered and nonclustered.

A. True
B. False

Correct Answer:  A. True
Advertisement

8. SQL Server indexes are special data structures used to improve performance.

A. True
B. False

Correct Answer:  A. True
Advertisement

9. SQL Server supports a language called Transact-SQL (also called T-SQL).

A. True
B. False

Correct Answer:  A. True
Advertisement

10. The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.

A. True
B. False

Correct Answer:  B. False
Advertisement

Leave A Comment?