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,

1280

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

TCS,

1230

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

TCS,

1654

How to use copy and concatenate commands in SQL?

Amdocs,

1191

How many columns can exist together per table?

Cap Gemini,

1205

What is the use of RDBMS?

Wipro,

1051

Write a SQL query to make a column as unique?

Cap Gemini,

1069

Explain few examples of RDBMS?

Wipro,

1097

How many tables can be joined in SQL Server?

Cap Gemini,

1109

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

Wipro,

1028

Explain the database you used in your final year project?

Wipro,

1097

Write a SQL query to delete a table?

Amdocs,

1182

Explain the difference between HTTP and HTTPS in database?

Wipro,

1086

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

Cap Gemini,

1351

How to use clusters?

Amdocs,

1008

Un-Answered Questions { SQL Server }

How to create new tables with "select ... Into" statements in ms sql server?

1042

Indexes are updated automatically is the full-text index also updated automatically?

1062

Explain linked server in sql?

1288

What are distinctive joins find as a part of sql?

1000

Define self join in sql server joins?

990

How much is a sql server license?

1005

Explain different types of locks in sql server.

1124

how to control the amount of free space in your index pages? : Sql server database administration

1083

What is the security principal at the server level that represents your session?

1062

What is sql server schema compare? How we can compare two database schemas?

1076

What are indexes in ms sql server?

1112

What is shrink log file?

945

What is a collation?

1128

What are the diifferences between the ms sql server vs mysql?

1234

You want to implement the many-to-many relationship while designing tables. How would you do it?

1043

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