Can you give me an overview of some of the datab

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

(Continued from previous question...)

Can you give me an overview of some of the database objects available for use in SQL Server 2000?

You are looking for objects such as: tables, views, user-defined functions, and stored procedures; it's even better if they mention additional objects such as triggers. It's not a good sign if an applicant cannot answer this basic question.

(Continued on next question...)

Other Job Interview Questions

• You need to remove a large table from your database ...
• In which order do you perform an upgrade to SQL Server 2005 for replicated databases?
• What does the NULLIF function do?
• You restart your SQL Server on a Sunday morning after some maintenance ...
• How many users can be added to an application role in SQL Server 2005?
• What is the difference between a return parameter and an OUTPUT parameter?
• What does SEND do in SQL Server 2005?
• Which framework would you use to manage this database programatically?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• You want to disable the trigger dEmployee on the HumanResources...
• More...