SQL Server 2000 – True or False

16. Better security occurs if Windows-only authentication is selected.

A. True
B. False

Correct Answer:  A. True

17. SQL Server AFTER Triggers may be assigned views.

A. True
B. False

Correct Answer:  B. False

18. ‘dbo’ stands for database object.

A. True
B. False

Correct Answer:  B. False

19. With SQL Server optimistic locking, an update lock is placed on the row when the row is read.

A. True
B. False

Correct Answer:  B. False

20. By default, SQL Server will create one data file and one log file for each newly created database.

A. True
B. False

Correct Answer:  A. True

Leave A Comment?

nine − 8 =