What does Default Object refers to in MS SQL Ser

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

(Continued from previous question...)

What does Default Object refers to in MS SQL Server?

Default Object refers to an object associated to a column to specify the default value of that column. If an INSERT statement does not provide any value for that column, the default value will be used.

(Continued on next question...)

Other Job Interview Questions

• What two categories you can divide T-SQL statements into?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• Is MS SQL Server compliant to ANSI SQL standards?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What is the difference between a "User DSN" and a "System DSN" ODBC connection?
• What is the default TCP/IP port # used by MS SQL Server to receive connection requests?
• What should you do to prepare for MS SQL Server upgrade?
• During a BULK INSERT operation, are triggers and contraints enforced by default?
• What is the T-SQL command to create a new login in MS SQL Server?
• What stored procedure you can execute to find out if a database is set to single-user or multi-user mode?
• More...