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,

1232

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

TCS,

1179

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

TCS,

1606

How to use copy and concatenate commands in SQL?

Amdocs,

1140

How many columns can exist together per table?

Cap Gemini,

1156

What is the use of RDBMS?

Wipro,

1004

Write a SQL query to make a column as unique?

Cap Gemini,

1039

Explain few examples of RDBMS?

Wipro,

1039

How many tables can be joined in SQL Server?

Cap Gemini,

1064

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

Wipro,

987

Explain the database you used in your final year project?

Wipro,

1044

Write a SQL query to delete a table?

Amdocs,

1137

Explain the difference between HTTP and HTTPS in database?

Wipro,

1031

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

Cap Gemini,

1287

How to use clusters?

Amdocs,

945

Un-Answered Questions { SQL Server }

Can you explain what are various ways to enhance the ssrs report?

1002

Is it possible in sql table to have more than one foreign key?

1033

What are truncate options available in sql server? : sql server database administration

1030

What is SQL Azure Firewall?

136

Define Unique Key?

1003

What are the different types of backups that exist?

1167

How you can add messages to the nt event log from within a stored procedure?

1068

What is the contrast amongst drop and truncate?

1034

How is a full-text index updated?

954

How to disconnect from a sql server using mssql_close()?

1109

Explain isolation levels that sql server supports?

1039

What is difference between delete & truncate commands?

1081

What is scrollable cursor?

1041

How do I get to sql server configuration manager?

1009

What is autocommit mode in sql server?

1174

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