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

Are all views updatable ?

MCN Solutions,

1201

How each E-R model constructs can be mapped to the relational model?

HCL,

1050

Tell me about normalization in DBMS.

Honeywell, Zomato,

1061

what is the difference between count(*) and count(1) ?

MCN Solutions,

1125

Relational calculus is what type of language?

HCL,

1091

How can i Relate Tables in SSIS

HCL,

1134

What are audit control procedures?

Ernst Young, Thomson Reuters,

1034

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

MCN Solutions,

1030

What is the Disadvantage of indexed sequential file.

HCL,

1128

Explain Geography datatype in SQL Server

Infosys,

1190

What is the difference between implicit and explicit transaction?

1052

Tell me about joins in database system and explain each in detail.

Axtria, ITC Indian Tobacco Company,

1105

What is SubQuery in SQL Server 2008

HCL,

1070

How to find Duplicate Records In table?

HCL,

1071

What is the beast way to write CTE in SQL Server ?

HCL,

1093

Un-Answered Questions { SQL Server }

How to insert a new row into a table with "insert into" statements in ms sql server?

1013

What are temporal tables in sql server 2016?

929

Explain about sql server login?

1133

What is the difference between Stored Procedures and triggers?

1133

How to find related tables in sql server?

1001

If user is owning any SQL Objects, can we drop that user

2130

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1941

How can sql server instances be hidden?

1028

Explain syntax for disabling triggers?

1093

What is etl - extraction, transformation, and loading?

960

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1023

How to backup SQL Server Reporting Services ?

152

what is sql server? : Sql server database administration

1042

How sql server enhances scalability of the database system?

1315

What are the diifferences between the ms sql server vs mysql?

1235

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