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

Explain database normalization?

1166

Do you know exporting and importing utility?

991

Explain microsoft sql server functions?

1054

What are scalar functions?

966

Explain steps of normalization?

956

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

870

what is the system function to get current user's user id? : Sql server database administration

963

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

999

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

895

what are acid properties? : Sql server database administration

945

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

861

explain how to create a new schema in a database? : Sql server database administration

1078

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

870

what is the difference between a primary key and a unique key? : Sql server database administration

961

what are isolation levels? : Sql server database administration

931

Un-Answered Questions { SQL Server }

Are resultset updatable?

905

How can I add Reporting Services reports to my application?

129

How the authentication mode can be changed?

1092

What is the xml datatype?

1014

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1099

What is precedence constraint?

946

How sql server enhances scalability of the database system?

1141

Which sql server table is used to hold the stored procedure script?

898

What is an inner join?

932

Give the query of getting last two records from the table in SQL SERVER?

913

Can we update data in a view?

983

What is transaction server distributed transaction?

1001

What is #temp and @table variable in SQL server?

1037

How many types of the database links?

1036

How do you troubleshoot errors in a SQL Server Agent Job?

1021

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