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

A. True
B. False

Show Answer

17. SQL Server AFTER Triggers may be assigned views.

A. True
B. False

Show Answer

18. ‘dbo’ stands for database object.

A. True
B. False

Show Answer

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

A. True
B. False

Show Answer

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

A. True
B. False

Show Answer