1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


SQL Server Interview Questions
Questions Answers Views Company eMail

How can I enforce to use particular index?

Symphony,

1 5254

What is sorting and what is the difference between sorting and clustered indexes?

 1 7210

What are the differences between UNION and JOINS?

CarrizalSoft Technologies,

3 5113

What is the use of SCOPE_IDENTITY() function?

 2 5124

Can we rollback records deleted by a truncate statement?

CarrizalSoft Technologies, United Healthcare,

3 7542

How many types of indexes are there in SQL Server?

CarrizalSoft Technologies, United Healthcare,

6 10209

How many types of TRIGGERS are there in MS SQL Server?

CarrizalSoft Technologies, TCS, United Healthcare,

8 28713

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

United Healthcare,

1 4919

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

United Healthcare,

1 4966

Can we execute a stored procedure inside a trigger?

BirlaSoft, CarrizalSoft Technologies, United Healthcare,

6 22739

What is the query optimization statistics?

 1 2238

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

 3 5443

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

Cognizant, TCS,

12 12545

How will u test the stroded procedures and functions? difference between SP and Triggers

TCS,

2 6257

explain the type of contraints

 3 4248

Un-Answered Questions { SQL Server }

Tell me what are the essential components of sql server service broker?

497

Can you please explain the difference between primary keys and foreign keys?

648

Explain the difference between primary keys and foreign keys?

503

What is catalog views?

598

Do you know what are the steps to process a single select statement?

524




Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2074

What to perform pattern match with the like operator?

475

Can we install sql server 2016 on windows 7?

664

How to install sql server 2005 express edition?

583

What is difference between join and natural join?

471

What is collation sensitivity?

541

When columns are added to existing tables, what do they initially contain?

621

What is report rendering ?

102

What do you understand by integration services in sql server?

541

What are distributed partitioned views?

606

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