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,

1183

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

TCS,

1131

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

TCS,

1551

How to use copy and concatenate commands in SQL?

Amdocs,

1067

How many columns can exist together per table?

Cap Gemini,

1104

What is the use of RDBMS?

Wipro,

960

Write a SQL query to make a column as unique?

Cap Gemini,

963

Explain few examples of RDBMS?

Wipro,

977

How many tables can be joined in SQL Server?

Cap Gemini,

1006

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

Wipro,

949

Explain the database you used in your final year project?

Wipro,

974

Write a SQL query to delete a table?

Amdocs,

1080

Explain the difference between HTTP and HTTPS in database?

Wipro,

976

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

Cap Gemini,

1213

How to use clusters?

Amdocs,

884

Un-Answered Questions { SQL Server }

Explain relational data?

860

How to define output parameters in stored procedures?

961

How do I manually uninstall an instance of sql server 2016?

965

what are defaults? : Sql server database administration

1008

What are different types of data sources?

937

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

922

What is snapshot parameter in ssrs?

140

What is a sql join?

954

Write down the syntax and an example for create, rename and delete index?

925

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

968

Tell me what are cursors and when they are useful?

910

What do you mean by table and field in sql?

969

What is difference between table aliases and column aliases? Do they affect performance?

913

Why should one not prefix user stored procedures with ‘sp_’?

987

What is the datatype of rowid?

877

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