sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.
Database interview questions and answers asked in various interviews, faqs,tutorial and articles..