SQL Server Interview Questions
Questions Answers Views Company eMail

what is web server?

Satyam,

3 9037

What are functions

3 6824

how to get the automatic backup of the database in the sql server

4 32014




What command do we use to rename a db?

IBM,

5 8815

What are the four main query statements?

Wipro,

7 15617

Which command using Query Analyzer will give you the version of SQL server and operating system?

3 12465

What is the STUFF function and how does it differ from the REPLACE function?

2 17470

What is SQL server agent?

HCL, SAP Labs,

2 6451

What is the purpose of UPDATE STATISTICS?

2 10366

What is de-normalization and when do you do it?

3 5670

Difference between Function and Stored Procedure?

C1 India, NA,

9 15185

What is data integrity? Explain constraints?

Thinksoft,

1 22502

Explain some DBCC commands?

6 14623

What are tasks?

Wipro,

3 8624

What is the purpose of using COLLATE in a query?

1 16600







Un-Answered Questions { SQL Server }

What is the maximum rows in sql server table?

10


How to create an index on an existing table in ms sql server?

46


What are the built in functions in sql server?

10


What are the drawbacks of reporting in ssrs?

7


How do you migrate data from mssql server to azure?

46






What is the guest user account in sql server? What login is it mapped to it? : sql server security

73


Write a code to select distinct records without using the DISTINCT keyword.

81


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

48


Can the “if update (colname)” statement be used in a delete trigger?

41


What is the maximum size per database for sql server express?

44


how we use window authentication connection with sql server.?

70


Difference between rowid and rownum in SQL?

66


you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

45


How is sql used in sql server?

13


What were the latest updates to SQL Azure service?

13