Interview Questions.........................................................

Posted by Anu_Dgr8 under Interview Questions on 3/29/2012 | Points: 10 | Views : 989 | Status : [Member] | Replies : 5
1>How to start using JQUERY.I have never used it.Whats the importance of using JQUERY.What are the differences between Javascript and JQUERY?
2>CONNECTED Vs DISCONNECTED DATABASE
3>Given 3rd party dll,how would you use it in ur project?
4>What's Normalization in SQL?
5>What all to consider when designing tables in SQL ?
6>When will you use Threading?
7>What's MVVM and MVC?

Thanks and Regards,
Hoosha Boosha



Responses

Posted by: Naraayanan on: 4/2/2012 [Member] Starter | Points: 25

Up
0
Down

2)
Connection: Access a Database for the Project .So we use like this..
Declare a Path and Security of the Database
SqlConnection myConnection = new SqlConnection("user id=username;" + "password=password;server=serverurl;" + "database=database; " + )  

Con.open()

Disconnection: To close a Connection .So we use
Con.Close()



3) 3Rd Party DLL:
1) If Dll is a Control ,Use Add Reference in the Toolbox and use your Project.
2) Declare a Namespace :
 System.Runtime.InteropServices;  


4)
Normalization:
efficiently organizing data in a database
Eliminate data redundancy
Improve performance
Query optimization
Faster update due to less number of columns in one table
Index improvemen




Regards,
Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
http://abaprocker.blogspot.com/

Anu_Dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Gaur1982 on: 5/10/2012 [Member] Starter | Points: 25

Up
0
Down
You can read many Interview Question here : http://planetofcoders.com/category/interview-question/

Gaurav Agrawal
http://www.planetofcoders.com/

Anu_Dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ashyour on: 6/20/2012 [Member] Starter | Points: 25

Up
0
Down
Question 3:
You can use Plateform Invoke for any dll file.
please visit here to know about it
http://msdn.microsoft.com/en-us/library/aa288468(v=vs.71).aspx

Anu_Dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ashyour on: 6/20/2012 [Member] Starter | Points: 25

Up
0
Down
Question 6:
we use threading when we require Asynchronous programming.
i.e. two task can be executed simultaneously

Question 2:
Connected approach is when we use SqlDataReader where connection remains open while we process data.
Disconnected approach is when we use DataSet and DataAdapter where connection remains close while we process data.

Anu_Dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajkatie on: 6/21/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Question 7:
In MVC, the Controller creates the Views and the Model. The Views register with the Controller, which also has a reference to the Model. A View notifies the Controller of user interactions, and the Controller in turn queries the View for its state and updates the Model appropriately. The Controller notifies the Views when there are changes in the Model, and the Views query the controller to update their states.

Model-View-ViewModel (MVVM) is a derivative of MVC that takes advantage of particular strengths of the Windows Presentation Foundation (WPF) architecture to separate the Model and the View by introducing an abstract layer between them: a "Model of the View," or ViewModel. It derives from the Smalltalk ApplicationModel pattern, as does the PresentationModel pattern described by Martin Fowler.

Rajesh Patel
.Net Trainer(M.C.S.A | MCT)
Brainbench (Asp.Net 4.5 and C# 5.0)

Anu_Dgr8, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response