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 3804

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

6 7728

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

2 10613

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 4905

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

Teledata,

6 9723

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 23881

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 9208

What value could be assigned to Varchar Type?

3 5919

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

3 5530

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

1 4263

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

1 4813

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

3 8500

What does the INSTEAD OF trigger do?

3 7624

What are explicit and implicit transactions?

BirlaSoft,

4 22122

What are the two types of concurrency?

4 8087

Un-Answered Questions { SQL Server }

How to integrate the ssrs reports in application?

985

Does sql server use t sql?

1022

Explain the flow of creating a cube? : sql server analysis services, ssas

1050

Can sql server 2016 run on windows 7?

916

What are the types of user defined functions in sql server?

1049

What are the aggregate and scalar functions?

1068

What is fill factor and pad index?

1012

What do you understand by check constraint in sql server?

945

What is the default Port No on which SQL Server listens?

1124

What does asynchronous call backs means?

1157

How to select some specific columns from a table in a query in ms sql server?

1005

Explain filestream storage of sql server 2008?

1016

What is stored procedures?

1035

Explain collation?

1065

Name the different type of indexes in sql?

965

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