What is the difference between them (Ethernet ne

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

(Continued from previous question...)

What is the difference between them (Ethernet networks and token ring networks)?

With Ethernet, any devices on the network can send data in a packet to any location on the network at any time. With Token Ring, data is transmitted in ‘tokens’ from computer to computer in a ring or star configuration. Token ring speed is 4/16 Mbit/sec , Ethernet - 10/100 Mbit/sec.

(Continued on next question...)

Other Job Interview Questions

• Is SQL Server implemented as a service or an application?
• What are user defined datatypes and when you should go for them?
• Can you have a nested transaction?
• What kind of LAN types do you know?
• What is a traditional Network Library for SQL Servers?
• Do you know how to configure DB2 side of the application?
• What is a join and explain different types of joins.
• What is a traditional Network Library for SQL Servers?
• What are the steps you will take, if you are tasked with securing an SQL Server?
• What is lock escalation?
• More...