What is the difference in Login Security Modes b

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

(Continued from previous question...)

What is the difference in Login Security Modes between v6.5 and 7.0?

7.0 doesn’t have Standard Mode, only Windows NT Integrated mode and Mixed mode that consists of both Windows NT Integrated and SQL Server authentication modes.

(Continued on next question...)

Other Job Interview Questions

• How many bits IP Address consist of?
• What is a major difference between SQL Server 6.5 and 7.0 platform wise?
• What is a transaction and what are ACID properties?
• Do you know how to configure DB2 side of the application?
• What are statistics, under what circumstances they go out of date, how do you update them?
• Explain CREATE DATABASE syntax
• How many layers of TCP/IP protocol combined of?
• What are constraints? Explain different types of constraints.
• What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
• How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?
• More...