What does the DUMP command do?

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

(Continued from previous question...)

What does the DUMP command do?

Answer: Backs up the transaction log.

Explanation: This command is included for backward compatibility, but has be deprecated and will be removed. The BACKUP command is preferred.
It allows for a backup of the database or log.

(Continued on next question...)

Other Job Interview Questions

• What value should you use for the BROKER_INSTANCE parameter?
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• When creating a SQL Server 2005 Service Broker message type, what does the EMPTY validation option mean?
• You have upgraded your SQL Server 2000 on Windows 2000 server to SQL Server 2005 to take advantage ...
• What tool is available for ad hoc reporting by non IT end users in Reporting Services 2005?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• What does the SQL Writer service do?
• You wish to ensure you can recover your SQL Server 2005 database to a point in time if necessary. Which recovery models can you use?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• More...