What are the testing options provided by Microsoft ?

1. Unit Testing integrated into VSTS
2. WebTest
3. Load Test
4. Generic Test
5. Manual Test
6. Ordered Test

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

What is the expansion of BCP ?

Bulk Copy Program.

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

What is a table called if it has no Clustered index and Non-Clustered index ?

Heap.

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

what is Log Shipping ?

In SQL Server, it is a process of automating the back up of a database and transaction log files on a production server.

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

What is the maximum level of recursion allowed in SQL Server ?

32.

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

Is recursion allowed in Stored Procedures in SQL Server ?

Yes.

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

What is SQL Profiler ?

Its an tool which is used to montior activites in SQL Server and also helps in increasing performance.

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

What are the different types of Sub-Query ?

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

What is the difference between 'where' and 'Having' Clause ?

'Where' works before statement is executed and 'having' after executioin. 'Where' is always peferred over 'having'.

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

What the various levels in ISTQB certification?

a. Foundation
b. Advanced

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is Selenium?

It is open source test automation tool widely used.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is cross browser Testing?

It is a method of testing an application over multiple browsers and operating systems.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is Beta Testing?

A prerelease testing done by the customers

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is Basis Path Testing?

A white box test case design technique that uses the algorithmic flow of the program to design tests.

1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning