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 you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 3874

one table has four field id,name,design,salary. i have to find maximum salary .

6 7947

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 10726

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 5029

How to find the date and time of last updated table?

Teledata,

6 9950

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 24050

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 9350

What value could be assigned to Varchar Type?

3 6053

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 5641

What types of integrity are enforced by a foreign-key constraint

1 4346

What are the main control-of-flow T-SQL constructs?

1 4896

What are the two virtual tables SQL Server maintains for triggers?

3 8619

What does the INSTEAD OF trigger do?

3 7763

What are explicit and implicit transactions?

BirlaSoft,

4 22303

What are the two types of concurrency?

4 8241

Un-Answered Questions { SQL Server }

Explain comment on transactions?

1045

Can we store videos inside the sql server table?

1028

What are the commands used in DCL?

1086

which backup strategy you are following at ur company

2197

What are various ways to enhance the ssrs report?

1037

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2137

what is raid and what are different types of raid configurations? : Sql server database administration

1107

What is a cube? : sql server analysis services, ssas

1055

what are the three command line utilities and what are their primary functions?

153

What are different backups available in sql server?

1159

What is Transparent Data Encryption?

1061

Do you know what is rank function?

1128

Does sql server 2000 clustering support load balancing?

1028

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1076

Why use view instead of a table?

1005

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