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,

1607

How to use copy and concatenate commands in SQL?

Amdocs,

1141

How many columns can exist together per table?

Cap Gemini,

1156

What is the use of RDBMS?

Wipro,

1005

Write a SQL query to make a column as unique?

Cap Gemini,

1040

Explain few examples of RDBMS?

Wipro,

1039

How many tables can be joined in SQL Server?

Cap Gemini,

1065

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

Wipro,

987

Explain the database you used in your final year project?

Wipro,

1045

Write a SQL query to delete a table?

Amdocs,

1137

Explain the difference between HTTP and HTTPS in database?

Wipro,

1036

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

Cap Gemini,

1289

How to use clusters?

Amdocs,

945

Un-Answered Questions { SQL Server }

What are locks in sql?

980

What is precedence constraint?

983

What are the disadvantages of merge replication?

1424

what are acid properties? : Sql server database administration

997

Which language is supported by sql server?

1013

What is similarity and difference between truncate and delete in sql?

1101

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

987

Explain how does the report manager work in ssrs?

955

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

984

How can we determine what objects a user-defined function depends upon?

1014

What is the sql case statement used for? Explain with an example?

992

What is the command used to check locks in microsoft sql server?

1044

What is a schema in ms sql server 2005?

970

How to replace the Query Result 'Null Value' with a text ?

1043

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1203

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