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,

1182

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

TCS,

1129

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

TCS,

1548

How to use copy and concatenate commands in SQL?

Amdocs,

1064

How many columns can exist together per table?

Cap Gemini,

1102

What is the use of RDBMS?

Wipro,

957

Write a SQL query to make a column as unique?

Cap Gemini,

961

Explain few examples of RDBMS?

Wipro,

974

How many tables can be joined in SQL Server?

Cap Gemini,

1004

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

Wipro,

947

Explain the database you used in your final year project?

Wipro,

970

Write a SQL query to delete a table?

Amdocs,

1078

Explain the difference between HTTP and HTTPS in database?

Wipro,

974

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

Cap Gemini,

1210

How to use clusters?

Amdocs,

882

Un-Answered Questions { SQL Server }

Can we add a cpu to sql server?

958

SQL Server Architecture ?

2397

What are the kinds of subquery?

951

Define inner join? Explain with an example?

924

Why do we partition data?

977

what is dbcc? : Sql server database administration

965

What is extended stored procedures?

901

In what sequence sql statement is processed?

953

What do you mean by the term 'normalization'?

1127

What is lock escalation? : sql server database administration

1102

What is difference between materialized view and view?

877

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1021

What is an example of a primary key?

912

What do you mean by an execution plan?

1052

What is a trace frag? Where do we use it?

1044

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