Which of the following is an invalid file name f

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

(Continued from previous question...)

Which of the following is an invalid file name for a database file?

Answer
None of the above

Explanation
Explanation from BOL: SQL Server 2005 does not enforce the .mdf, .ndf, and .ldf file name extensions, but these extensions help you identify the different kinds of files and their use.

(Continued on next question...)

Other Job Interview Questions

• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• If you absolutely need a report to look the same regardless of what OS or viewing software is being used, which of the following file formats would be the best choice?
• What is the difference between a return parameter and an OUTPUT parameter?
• You are loading 100 rows of data into a narrow table that is heavily used by your production inventory queries...
• How can you get SQL Server 2005 to simulate multiple processors for query testing?
• You want to be sure that your reporting solutions using a database snapshot are properly protected from disaster. How can you back up your database snapshots?
• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• In SQL Server 2005, which network protocols use endpoints?
• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• More...