In the Windows world, if you hit the "Enter" key

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

(Continued from previous question...)

In the Windows world, if you hit the "Enter" key on your keyboard between two single quotes and inserted this value, what data would be stored in the column?

Answer: ASCII 13 and ASCII 10
Explanation: In the Windows world, the Enter key creates two characeters: ASCII 13 and ASCII 10. The 13 is a carriage return and the 10 is a line feed. This is different than Unix based systems.

(Continued on next question...)

Other Job Interview Questions

• What algorithm is used to encrypt the Database Master Key when it is created?
• What is the best way to have your junior DBA do this?
• When using the SQLCMD tool, what does the -V parameter do?
• How many rows are returned by these two select statements?
• When you install SQL Server 2005 and create a new database, is a Database Master Key created?
• What is the granularity in seconds of the timestamp datatype?
• How can you ensure they do not change the underlying tables without also changing the view and not disrupt their workflow?
• You have installed a US English SQL Server 2000 instance with the default options, collation, and sorting...
• What result would you expect from this statement? Select * from dbo .MyTable
• There are two types of subscriptions in SQL Server replication. What are they?
• More...