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

Mention the differences between local and global temporary tables.

1043

What do you understand by check constraint in sql server?

945

What is the tcp/ip port on which sql server runs?

1159

What do you understand by intent locks?

1012

Explain log shipping and mention its advantages.

1044

Explain log shipping?

1012

What do you understand by the analysis services in sql server?

939

What are the steps you must follow to hide sql server instances?

978

What are the advantages of mirroring?

995

What do you understand by user-defined function in the sql server?

951

What are the differences between having and where clause.

966

What are the options which must be set to allow the usage of optimistic models?

963

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

985

Mention the command used to rename the database.

1005

Mention the differences between sql server and mysql.

1013

Un-Answered Questions { SQL Server }

What is an active database?

1012

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

987

What is the process of normalization?

1124

What is the report model project?

141

mention different types of relationships in the dbms?

1020

What happens if null values are involved in arithmetic operations?

1011

What is BLOCK statements in SQL?

1263

Where actually sql azure database is hosted?

163

What do you mean by sql server agent?

990

What are number line correlation administrators will use while working with a subquery?

1176

Can an automatic recovery be initiated by a user?

1013

Can group by and orderby be used together?

1013

How to see existing views in ms sql server?

1043

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1032

can an automatic recovery be initiated by a user? : Sql server administration

953

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