What are the different types of Sub-Query ?

Saturday, March 19, 2011

1. Single-row
2. Multiple-row
3. Multiple-column


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the expansion of OLTP ?

OnLine Transation Processing


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the different types of Collation sensitivity ?

1. Case sensitivity
2. Accent sensitivity
3. Kana sensitivity
4. Width sensitivity


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the default port number on which SQL Server runs on ?

1433.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is an Identity ?

Its an field which automatically generates numeric values.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What are the different kinds of User Defined Functions ?

1. Scalar User-Defined Function
2. Inline Table-Value User-Defined Function
3. Multi-statement Table-Value User-Defined Function


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is Collation ?

Set of rules which decides how data is sorted and compared.


www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Blog Widget by LinkWithin