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

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *

five × 1 =