How can you ensure that a table named TableB wit

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

(Continued from previous question...)

How can you ensure that a table named TableB with a field named Fld1 will only have those values in the Fld1 field that are also in the table named TableA with a field named Fld1?

This relationship related question has two potential answers. The first answer (and the one that you want to hear) is the use of foreign key constraints. A foreign key constraint is used to maintain referential integrity. It is used to ensure that a field in a table will only hold values that are already defined in another field in a different (or the same) table. That field is the candidate key (usually a primary key of the other table).

The other option is the use of triggers. Triggers can be used to ensure the same effect of constraints in a roundabout way, but it is much more difficult to set up and maintain, and the performance is typically worse. Because of this, Microsoft recommends that developers use foreign key constraints instead of triggers for maintaining referential integrity.

(Continued on next question...)

Other Job Interview Questions

• What is a zettabyte?
• What happens when a transaction fails on the publisher?
• What port do you need to open on your server firewall to enable named pipes connections?
• What does the SQL Writer service do?
• You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
• Where are Notification Services event messages logged in SQL Server 2005?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• How can you determine which Service Broker ports are being used on your server?
• Using Report Builder, which of the following is the best statement about the formatting options for boolean columns?
• Yesterday's QOD How are comments denoted in an XML document?
• More...