Sql Server 2000 - Study Mode
[#6] With which type of SQL Server recovery model are all database changes logged?
Correct Answer
(B) Full recovery
[#7] SQL Server automatically creates an index on:
Correct Answer
(C) both primary and foreign keys
[#8] Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Correct Answer
(A) Lock level
[#9] SQL Server program code that is executed after an SQL command has been processed is called a(n):
Correct Answer
(C) AFTER trigger
[#10] Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
Correct Answer
(A) REPEATABLE READ