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

Can you name a few encryption mechanisms in sql server?

908

What are subqueries in sql server?

1077

What is the purpose of update statistics and scope_identity() function?

1066

what do you understand by change data capture?

952

Mention the different types of triggers?

1032

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

1113

Explain the properties of subqueries in sql server?

1034

How do you start single user mode in clustered installations?

912

What are the differences between sql server and mysql.

1045

Mention the different types of replication in sql server.

974

Explain the steps to create and execute a user-defined function in the sql server?

933

What do you understand by triggers?

873

mention different types of relationships in the dbms?

976

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

987

What do you understand by recursive stored procedure?

887

Un-Answered Questions { SQL Server }

How to concatenate two character strings together?

1075

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1016

Can a rule be bound to any column of any data type?

922

Can sql server be linked with other servers like oracle?

918

Explain what are the basic functions for master, msdb, model, tempdb databases?

926

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

990

How to use the inserted and deleted pseudo tables?

925

How to rebuild the master database?

1028

What is attribute hierarchy? : sql server analysis services, ssas

977

Does a full backup include transaction log?

919

What is nolock hint in sql server 2008

1088

Explain primary key, foreign key and unique key?

943

What is a document index?

988

What are system databases into sql server (2005/2008)?

967

What is the difference between DATETIME2 and DATETIME?

1026

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