Question for Dot Net Interview (Part 7):

--* What is Data Binding?
Data binding is a way used to connect values from a collection of data (e.g. DataSet) to the controls on a web form.

--* Describe the difference between inline and code behind.
1)Inline code is written along side the HTML in a page.
2)Code-behind is code written in a separate file and referenced by the .aspx page


--* What is the transport protocol you use to call a Web service?
SOAP (Simple Object Access Protocol) is the preferred protocol.

--* What is database replicaion
Replication is the process of copying/moving data between databases on the same or different servers

--* What are the different types of replication?
1) Transactional
2) Snapshot
3) Merge


--* What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table.

* Dropping : (Table structure + Data are deleted), Invalidates the dependent objects ,Drops the indexes
* Truncating: (Data alone deleted), Performs an automatic commit, Faster than delete
* Delete : (Data alone deleted), Doesn’t perform automatic commit


--* BulkCopy is a tool used to copy huge amount of data from tables

--* Types of Trigger:
Inserted and Deleted.


--* What is SQL Profiler?
SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server


--* What is User Defined Functions?
User-Defined Functions allow to define its own T-SQL functions that can accept 0 or more parameters
and return a single scalar data value or a table data type