.net Database Interview Questions & Answers

[meena1]

Hai all,,,,


Here are some important . Net Database Interview Questions & Answers.

1. What is the use of trace utility?
Ans:- Tracing is a very important monitoring and debugging tool for distributed, multitier applications. Such applications often contain problems that can only be observed when the application is under a heavy load and the inherent randomness of a real-life environment. Trace utility allows developers and administrators to monitor the health ofapplications running in real-life settings.

2. What is referential integrity and how can we achieve it?
Ans:- Referential integrity preserves the defined relationships between tables when records are entered or deleted. In SQL Server, referential integrity is based on relationships between foreign keys and primary keys or between foreign keys and unique keys. Referential integrity ensures that key values are consistent across tables. Such consistency requires that there be no references to nonexistent values and that if a key value changes, all references to it change consistently throughout the database.
We can achieve this by using foreign key.


For more details you just [url="http://www.coolinterview.com/type.asp?iType=645"]visit here.....[/url]