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

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1047

Explain different backup plans?

951

When would you prefer to have a minimum number of indexes?

911

What specific conditions database should meet, before you can bulk copy data into it using bcp?

989

Can a trigger be created on a view?

961

What are the restraints imposed on the table design by a merge replication?

1040

What is raid, and how it can influence database performance?

1059

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1007

How would you choose between a clustered and a non-clustered index?

980

How raid can influence database performance?

1041

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

964

Explain for xml explicit mode?

979

How can you check the level of fragmentation on a table?

1048

Explain an automatic checkpoint

977

If no size is defined while creating the database, what size will the database have?

996

Un-Answered Questions { SQL Server }

Do you know what are the restrictions that views have to follow?

1081

Can group by be used without aggregate functions?

926

Can sql server be linked with other servers like oracle?

970

How to copy the tables, schema and views from one sql server to another?

1051

What are the various editions of sql server 2017 that are available in the market?

892

What are the different types of cursor?

1096

Please illustrate physical database architecture? : SQL Server Architecture

992

What is a view and what are its advantages?

1116

What do you mean by authentication modes in sql server?

1089

Tell me can we use custom code in ssrs?

1007

964

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1152

Can sql servers link to other servers?

1093

What are the parts of a function?

945

How to concatenate two character strings together?

1127

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