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?

1089

Explain different backup plans?

1007

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

965

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

1045

Can a trigger be created on a view?

996

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

1095

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

1102

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

1044

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

1023

How raid can influence database performance?

1087

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?

1021

Explain for xml explicit mode?

1029

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

1092

Explain an automatic checkpoint

1018

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

1036

Un-Answered Questions { SQL Server }

Can you move the resources after pausing the node? : sql server database administration

1171

What is the primary use of the model database?

1136

What are the properties of the transactions?

1173

How does using a separate hard drive for several database objects improves performance right away?

990

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

Do you know the cursor types?

1205

What Is Rdbms?

1241

Define magic tables in sql server?

1124

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

1092

Write SQL queries on Self Join and Inner Join.

1220

What are the types of containers in ssis?

1239

Does windows server 2016 come with sql server?

986

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1064

How to use order by with union operators in ms sql server?

1067

Explain what is analysis service repository?

1051

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