What is an extended stored procedure? Can you in

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

An extended stored procedure is a function within a DLL (written in a programming language like C, C++ using Open Data Services (ODS) API) that can be called from T-SQL, just the way we call normal stored procedures using the EXEC statement.

Yes, you can instantiate a COM (written in languages like VB, VC++) object from T-SQL by using sp_OACreate stored procedure.

(Continued on next question...)

Other Job Interview Questions

• What type of Index will get created after executing the above statement?
• What is a self join? Explain it with an example.
• What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
• What is a traditional Network Library for SQL Servers?
• What are the steps you will take, if you are tasked with securing an SQL Server?
• What is blocking and how would you troubleshoot it?
• Is SQL Server implemented as a service or an application?
• Define candidate key, alternate key, composite key.
• There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
• What kind of LAN types do you know?
• More...