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 sql servers link to other servers?

1034

Describe how to use the linked server?

1076

What are transactions in sql?

999

Explain the third normal form(3nf)?

903

What are the different types of collation sensitivity?

1068

List out the differences between global and local temp tables in sql server?

1012

Explain “@@rowcount” and “@@error” in sql server?

1018

What are the different types of join?

1113

Why are sql functions used?

1062

Explain mixed authentication mode of sql server?

998

How can you insert null values in a column while inserting the data?

1230

Is it possible to update the views? If yes, how, if not, why?

983

What are the difference between “where” and “having” clause in sql server?

1023

What the different components in replication and what is their use?

923

What are subquery and its properties?

988

Un-Answered Questions { SQL Server }

What are transactions in sql?

999

What is a system database and what is a user database?

1035

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1036

If any stored procedure is encrypted, then can we see its definition in activity monitor?

951

What is page-level compression?

913

Can you name some of the dml commands in sql?

977

Explain what are the restrictions while creating batches in sql server?

1034

What are xml indexes?

898

Describe in brief authentication modes in sql server.

983

Explain what role entity and relationship play in an ER diagram.

1032

What program is used to store the data source file?

921

What are the properties of the relational tables?

838

Does sql server use t sql?

974

How to edit table in sql server 2017?

887

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1110

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