What is de-normalization? When do you do it and how?

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

(Continued from previous question...)

What is de-normalization? When do you do it and how?

De-normalization is the process of attempting to optimize the performance of a database by adding redundant data. It’s used To introduce redundancy into a table in order to incorporate data from a related table. The related table can then be eliminated. De-normalization can improve efficiency and performance by reducing complexity in a data warehouse schema.

(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?