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


SQL Server Interview Questions
Questions Answers Views Company eMail

How can we remove orphan records from a table?

 524

What do you mean by recursive stored procedure?

 508

What structure can you implement for the database to speed up table reads?

 708

What are the acid properties?

 551

Explain different types of index?

 590

What are user-defined functions (udfs) in sql server?

 570

Explain how many normalization forms?

 577

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

 535

Explain boyce and codd normal form(bcnf)?

 533

How important do you consider cursors or while loops for a transactional database?

 529

In what version of sql server were synonyms released?

 502

What are the aggregate and scalar functions?

 521

What is the need for group functions in sql?

 563

What is the difference between varchar and varchar types?

 562

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

 564

Un-Answered Questions { SQL Server }

How to create a user name in a database?

584

What are a scheduled jobs or what is a scheduled tasks?

492

What are the different authentication modes in sql server?

571

A trigger can reference objects outside the current database? State true or false.

550

What is log shipping?

558




What is intellisense?

584

What is use of except clause?

626

Can we use pragma autonomous_transaction in trigger?

537

How to convert numeric values to integers in ms sql server?

531

What are advantages of ssrs or why we should use ssrs?

104

How do you size a resultset?

498

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

530

How to recover from sql injection? : sql server security

520

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

620

What are subquery and its properties?

571

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