Explanation: Phantom reads occur when an insert or delete action is performed against a row that belongs to a range of rows being read by a transaction. 8. Which of the following fixed database roles can add or remove user IDs?
A. db_accessadmin
B. db_securityadmin
C. db_setupadmin
D. db_sysadmin
Answer:A
Explanation: Phantom reads occur when an insert or delete action is performed against a row that belongs to a range of rows being read by a transaction. 8. Which of the following fixed database roles can add or remove user IDs?
A. db_accessadmin B. db_securityadmin C. db_setupadmin D. db_sysadmin
Explanation: The db_accessadmin role manages security, but handles access to the database, as the name implies. 9. By default sql server has ___________ isolation level