Explanation:@objname is the qualified or nonqualified name of the table, indexed view, or queue for which space usage information is requested. 9. Which of the following determines type or resource to which the lock applies ?
A. sp_lock
B. sp_who
C. sp_monitor
D. sp_spaceused
Answer:A
Explanation:@objname is the qualified or nonqualified name of the table, indexed view, or queue for which space usage information is requested. 9. Which of the following determines type or resource to which the lock applies ?
A. sp_lock B. sp_who C. sp_monitor D. sp_spaceused
Explanation:sp_lock reports information about locks.use the sys.dm_tran_locks dynamic management view in future versions. 10. The Activity Monitor in SQL Server Management Studio graphically displays information about :