SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

How to update a field in SQL after ALTERING a row?

Amdocs,

1229

Write a sql query to get zero records from a table having n number of records?

TCS,

1175

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

TCS,

1600

How to use copy and concatenate commands in SQL?

Amdocs,

1138

How many columns can exist together per table?

Cap Gemini,

1154

What is the use of RDBMS?

Wipro,

996

Write a SQL query to make a column as unique?

Cap Gemini,

1030

Explain few examples of RDBMS?

Wipro,

1034

How many tables can be joined in SQL Server?

Cap Gemini,

1054

What is the name of the Database which IBM mainframe uses?

Wipro,

978

Explain the database you used in your final year project?

Wipro,

1032

Write a SQL query to delete a table?

Amdocs,

1132

Explain the difference between HTTP and HTTPS in database?

Wipro,

1025

How to automatically create a log when an exception is being received into SQL Server?

Cap Gemini,

1279

How to use clusters?

Amdocs,

935

Un-Answered Questions { SQL Server }

How to create new table with "create table" statements?

1092

What is application role in sql server database security? : sql server security

1055

What are the system database in sql server 2008?

1028

your distribution database is full what will u do

2170

How to execute function in stored procedure sql server?

1147

What is efficiency data?

946

Can select statements be used on views in ms sql server?

1061

What is the purpose of the master database?

1115

What are the different types of replication are there in sql server 2000?

1036

Do you know spatial data types - geometry and geography in sql server 2008?

1021

Ways to improve the performance of a SQL Azure Database?

125

What is your recommendation for a query running very slow? : sql server database administration

1039

How do I view views in sql server?

1001

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

978

What is the need for group functions in sql?

1078

For More Un-Answered { SQL Server } Questions Click Here