What is referential integrity and how can we achieve it?

.NET Database ,COM interop,and .NET deployment questions and answers

(Continued from previous question...)

What is referential integrity and how can we achieve it?

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.

(Continued on next question...)

Other Interview Questions

• To test a Web Service you must create a windows application or web application to consume this service? It is True/False?
• How many classes can a single.NET DLL contain?
• What are good ADO.NET object(s) to replace the ADO Recordset object?
• On order to get assembly info which namespace we should import?
• How do you declare a static variable and what is its lifetime? Give an example.
• How do you get records number from 5 to 15 in a dataset of 100 records? Write code.
• How do you call and execute a Stored Procedure in.NET? Give an example.
• What is the maximum length of a varchar in SQL Server?
• How do you define an integer in SQL Server?
• How do you separate business logic while creating an ASP.NET application?
• If there is a calendar control to be included in each page of your application, and and we do not intend to use the Microsoft-provided calendar control, how do you develop it? Do you copy and paste the code into each and every page of your application?
• How can you deploy an asp.net application ?
• Explain similarities and differences between Java and.NET?
• What are the XML files that are important in developing an ASP.NET application?
• Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
• How many objects are there in ASP?
• Which DLL file is needed to be registered for ASP?
• Is there any inbuilt paging (for example shoping cart, which will show next 10 records without refreshing) in ASP? How will you do pating?
• What does Server.MapPath do?
• Name atleast three methods of response object other than Redirect.
• Name atleast two methods of response object other than Transfer.
• What is State?
• Explain differences between ADO and DAO.
• How many types of cookies are there?
• Tell few steps for optimizing (for speed and resource) ASP page/application.
• Which command using Query Analyzer will give you the version of SQL Server and Operating System?
• How to find the SQL server version from Query Analyser
• Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
• What is the purpose of using COLLATE in a query?
• What is one of the first things you would do to increase performance of a query? For example, a boss tells you that “a query that ran yesterday took 30 seconds, but today it takes 6 minutes”?
• What is an execution plan? When would you use it? How would you view the execution plan?
• What is the STUFF function and how does it differ from the REPLACE function?
• What does it mean to have quoted_identifier on? What are the implications of having it off?
• What is the difference between a Local temporary table and a Global temporary table? How is each one used?
• What are cursors? Name four type of cursors and when each one would be applied?
• What is the purpose of UPDATE STATISTICS?
• How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
• What is referential integrity and how can we achieve it?
• What is indexing?
• Explain differences between server.transfer and server.execute method?
• What is de-normalization? When do you do it and how?
• Explain features of SQL Server like Scalibility, Availability, Integration with Internet.
• What is DataWarehousing?
• What is OLAP?
• How do we upgrade SQL Server 7.0 to 2000?
• What is job?
• What is Task?
• How do you find the error, how can you know the number of rows affected by last SQL Statement?
• What are the advantages/disadvantages of viewstate?
• Describe session handling in webform. How does it work and what are the limits?
• Explain differences between framework 1.0 and framework 1.1
• If we write any code for dataGrid methods, what is the access specifier used for that methods in the code behind file and why and how? Give an example.
• What is the use of trace utility?
• What are the differences between User control and Web control and Custom control?
• If I have more than one version of one assemblies, then how will I use old version in my application? Give an example.
• How does you handle this COM components developed in other programming languages in.NET?
• How will you register COM+ services?
• How do u call and execute a stored procedure in .NET?
• What are the different types of replication? How are they used?
• How do SQL Server 2000 and XML linked? What is SQL Server agent?
• How do you create thread in.NET?
• Describe the advantages of writing a managed code application instead of unmanaged one. What’s involved in certain piece of code being managed?
• Are COM objects managed or unmanaged?
• So can a COM object talk to a .NET object?
• How do you generate an RCW from a COM object?
• I can’t import the COM object that I have on my machine. Did you write that object?
• How do you call unmanaged methods from your .NET code through PInvoke?
• Can you retrieve complex data types like structs from the PInvoke calls?
• I want to expose my .NET objects to COM objects. Is that possible?
• Can you inherit a COM class in a .NET application?
• Suppose I call a COM object from a .NET applicaiton, but COM object throws an error. What happens on the .NET end?
• What do you know about .NET assemblies?
• What’s the difference between private and shared assembly?
• What’s a strong name?
• How can you tell the application to look for assemblies at the locations other than its own install?
• How can you debug failed assembly binds?
• Where are shared assemblies stored?
• How can you create a strong name for a .NET assembly?
• Where’s global assembly cache located on the system?
• Can you have two files with the same file name in GAC?
• How do I tell the client applications that are already installed to start using this new MyApp.dll?
• What is delay signing?