Explanation:snapshots.os_latch_stats is a System level resource table. 9. Which of the following is syntax for sp_add_collector_type procedure ?
A. core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’
B. core.sp_add_collector_type [ @collector_type_uid = ]
C. core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’
D. None of the mentioned
Answer:A
Explanation:snapshots.os_latch_stats is a System level resource table. 9. Which of the following is syntax for sp_add_collector_type procedure ?
A. core.sp_add_collector [ @collector_type_uid = ] ‘collector_type_uid’ B. core.sp_add_collector_type [ @collector_type_uid = ] C. core.sp_add_collector_type [ @collector_type_uid = ] ‘collector_type_uid’ D. None of the mentioned
Explanation:core.sp_add_collector_type adds a new entry to the core.supported_collector_types view in the management data warehouse database. 10. What does collector_type_id stands for in the following code snippet ?