What are the different types of System Testing ?

1. Facility Testing
2. Volume Testing
3. Stress Testing
4. Usability Testing
5. Security Testing
6. Performance Testing
7. Storage Testing
8. Configuration Testing
9. Installability Testing
10. Reliability Testing
11. Recovery Testing
12. Serviceability Testing
13. Documentation Testing
14. Procedure Testing

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

What is System Testing ?

The process of comparing the software to its original objectives.

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

What is Function Testing ?

It is process of finding discrepencies between the program and requirement.

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

What is the other name of Unit Testing ?

Module Testing.

www.codecollege.NET|http://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