Which framework would you use to manage this dat

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

(Continued from previous question...)

Which framework would you use to manage this database programatically?

You have an old database that needs to run in compatability mode 65 on your SQL Server 2005 server. Which framework would you use to manage this database programatically?

Answer
SQL-DMO

Explanation
SMO does not support compatibility modes 60 or 65, so you would ned to use DMO insead.

(Continued on next question...)

Other Job Interview Questions

• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• What T-SQL function can achieve this?
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• Which collation is used for Service Broker messages sent between the instances?
• How can you you be sure that a SOAP queries that are looking for a WSDL response will be provided?
• When declaring an XML document, which type allows text nodes at the top level?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• Credentials in SQL Server 2005 are used to access what?
• You have a SQL Server 2005 cluster and need to add anti-virus software as per your corporate standards. What should you exclude from scans?
• Is it possible to build an index on a view
• More...