If you have access to SQL Server, search its help system to answer the following questions. A. Does SQL Server support both optimistic and pessimistic locking? B. What levels of transaction isolation...

If you have access to SQL Server, search its help system to answer the following

questions.

A. Does SQL Server support both optimistic and pessimistic locking?

B. What levels of transaction isolation are available?

C. What types of cursors, if any, does SQL Server use?

D. How does the security model for SQL Server differ from that shown in

Figure 6-16?

E. Summarize the types of SQL Server backup.

F. Summarize the SQL Server recovery models.