Is MS SQL Server compliant to ANSI SQL standards

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

(Continued from previous question...)

Is MS SQL Server compliant to ANSI SQL standards?

Yes. MS SQL Server is compliant to ANSI SQL-92 standard.

(Continued on next question...)

Other Job Interview Questions

• What information do you need to identify a remote MS SQL Server to make a connection request?
• What is default sorting order when you use "ORDER BY" clause in a query statement?
• What is the default login account used by the installation process, when you are doing an unattended installation of MS SQL Server?
• What is the "master" database? Can I delete it to save disk space?
• What does Constraint refer to in MS SQL Server?
• What is the meaning of the NOTRUNCATE option in the "DBCC SHRINKDATABASE" command?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What is the meaning of Data Normalization?
• What does Constraint refer to in MS SQL Server?
• What does Constraint refer to in MS SQL Server?
• More...