One Stop GATE eBooks Guides Discussions Group

1 Message

Digest #1947

Top 50 .Net Database Interview Questions & Answers by "A.maheshi" a.maheshi

Message

1 Top 50 .Net Database Interview Questions & Answers

Mon Jun 30, 2014 8:34 pm (PDT) . Posted by:

"A.maheshi" a.maheshi

________________________________

.NET DATABASE INTERVIEW QUESTIONS

Download Free Interview Questions eBook of 500 Questions

(If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolInterview-Subscribe@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.)
.Net Database Interview Questions
* How do you separate business logic while creating an ASP.NET application?
http://www.coolinterview.com/interview/21734/

* Which DLL file is needed to be registered for ASP?
http://www.coolinterview.com/interview/21779/

* What is the use of trace utility?
http://www.coolinterview.com/interview/21769/

* Explain features of SQL Server like Scalability , Availability, Integration with Internet.
http://www.coolinterview.com/interview/21759/

* How do you use DBCC statements to monitor various ASPects of a SQL Server installation?
http://www.coolinterview.com/interview/21780/

* What are good ADO.NET object(s) to replace the ADO Recordset object?
http://www.coolinterview.com/interview/21731/

* What is the purpose of UPDATE STATISTICS?
http://www.coolinterview.com/interview/21753/

* Explain similarities and differences between Java and .NET?
http://www.coolinterview.com/interview/21777/

* What are the differences between User control and Web control and Custom control?
http://www.coolinterview.com/interview/21770/

* Explain differences between Server.Transfer and server.execute method?
http://www.coolinterview.com/interview/21757/

* What are the different types of replication? How are they used?
http://www.coolinterview.com/interview/21773/

* What is referential integrity and how can we achieve it?
http://www.coolinterview.com/interview/21781/

* How do you create thread in .NET?
http://www.coolinterview.com/interview/21775/

* How do you declare a static variable and what is its lifetime? Give an example.
http://www.coolinterview.com/interview/21732/

* Explain differences between ADO and DAO.
http://www.coolinterview.com/interview/21741/

* How many objects are there in ASP?
http://www.coolinterview.com/interview/21778/

* Describe session handling in webform. How does it work and what are the limits?
http://www.coolinterview.com/interview/21765/

* What are the advantages/disadvantages of viewstate?
http://www.coolinterview.com/interview/21764/

* Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table.
http://www.coolinterview.com/interview/21744/

* How do you find the error, how can you know the number of rows affected by last SQL Statement?
http://www.coolinterview.com/interview/21763/

* What are cursors? Name four type of cursors and when each one would be applied?
http://www.coolinterview.com/interview/21752/

* Describe session handling in webform. How does it work and what are the limits?
http://www.coolinterview.com/interview/21766/

* What is the .NET datatype that allows the retrieval of data by a unique key?
http://www.coolinterview.com/interview/1562/

* What is the maximum length of a varchar in SQL Server?
http://www.coolinterview.com/interview/21733/

* How do u call and execute a stored procedure in .NET?
http://www.coolinterview.com/interview/21772/

* How do SQL Server 2000 and XML linked? What is SQL Server agent?
http://www.coolinterview.com/interview/21774/

* How does you handle this COM components developed in other programming languages in .NET?
http://www.coolinterview.com/interview/21771/

* Name atleast two methods of response object other than Transfer.
http://www.coolinterview.com/interview/21739/

* What is the STUFF function and how does it differ from the REPLACE function?
http://www.coolinterview.com/interview/21749/

* What does Server.MapPath do?
http://www.coolinterview.com/interview/21737/

* 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"?
http://www.coolinterview.com/interview/21746/

* What is an execution plan? When would you use it? How would you view the execution plan?
http://www.coolinterview.com/interview/21748/

* Explain differences between framework 1.0 and framework 1.1?
http://www.coolinterview.com/interview/21767/

* What does it mean to have quoted_identifier on? What are the implications of having it off?
http://www.coolinterview.com/interview/21750/

* Name atleast three methods of response object other than Redirect.
http://www.coolinterview.com/interview/21738/

* What is an execution plan? When would you use it? How would you view the execution plan?
http://www.coolinterview.com/interview/21747/

* How to deploy an asp.net application?
http://www.coolinterview.com/interview/41375/

* How can you deploy an asp.net application ?
http://www.coolinterview.com/interview/21736/

* What is de-normalization? When do you do it and how?
http://www.coolinterview.com/interview/21758/

* 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.
http://www.coolinterview.com/interview/21768/

* What is indexing?
http://www.coolinterview.com/interview/21756/

* Explain What is the .NET datatype that allows the retrieval of data by a unique key?
http://www.coolinterview.com/interview/45741/

* Explain How do we separate business logic while creating an ASP.NET application?
http://www.coolinterview.com/interview/41397/

* What are the types of cookies are there?
http://www.coolinterview.com/interview/21743/

* Explain What is referential integrity and how can we achieve it?
http://www.coolinterview.com/interview/45737/

* What is job?
http://www.coolinterview.com/interview/21761/

* What is the difference between a Local temporary table and a Global temporary table? How is each one used?
http://www.coolinterview.com/interview/21751/

* How can you deploy an asp.net application ?
http://www.coolinterview.com/interview/21776/

* Explain What is indexing?
http://www.coolinterview.com/interview/41371/

* Explain What is the .NET datatype that allows the retrieval of data by a unique key?
http://www.coolinterview.com/interview/41395/