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?

1034

Explain different backup plans?

935

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

896

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

978

Can a trigger be created on a view?

950

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

1033

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

1051

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

1000

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

965

How raid can influence database performance?

1021

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?

955

Explain for xml explicit mode?

970

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

1040

Explain an automatic checkpoint

968

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

985

Un-Answered Questions { SQL Server }

What is the difference between clustered and a non-clustered index?

1018

What is a with(nolock)?

980

Explain what is analysis service repository?

982

What is difference between line feed ( ) and carriage return ( )?

896

Why truncate is ddl command?

1057

How can I create a report based on a query? : sql server management studio

1015

What are subqueries in sql server?

1118

How to convert numeric expression data types using the cast() function?

1059

Which tcp/ip port does the sql server run on? How can it be changed?

1049

What is buffer cash and log cache in sql server?

1114

What is transaction server distributed transaction?

1049

How to turn off warning messages during php execution?

1039

Tell me about builtinadministrator?

989

How to connect a database with sql express.?

1056

What is the difference between a function and a stored procedure?

1065

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