How many layers of TCP/IP protocol combined of?

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

(Continued from previous question...)

How many layers of TCP/IP protocol combined of?

Five. (Application, Transport, Internet, Data link, Physical).

(Continued on next question...)

Other Job Interview Questions

• When you create a database how is it stored?
• How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
• What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
• What is database replicaion? What are the different types of replication you can set up in SQL Server?
• Is SQL Server implemented as a service or an application?
• How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
• But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%?
• How to determine the service pack currently installed on SQL Server?
• There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
• Let’s assume you have data that resides on SQL Server 6.5. You have to move it SQL Server 7.0. How are you going to do it?
• More...