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?

 530

What do you mean by recursive stored procedure?

 513

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

 716

What are the acid properties?

 555

Explain different types of index?

 599

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

 575

Explain how many normalization forms?

 581

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

 545

Explain boyce and codd normal form(bcnf)?

 539

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

 541

In what version of sql server were synonyms released?

 507

What are the aggregate and scalar functions?

 528

What is the need for group functions in sql?

 569

What is the difference between varchar and varchar types?

 568

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

 573

Un-Answered Questions { SQL Server }

Explain the truncate command?

524

What is the use of sign function?

564

Write a sql query to display the current date?

639

Do you know what guidelines should be followed to help minimize deadlocks?

541

How can I check if a view exists in a sql server database?

568




Explain the disadvantages/limitation of the cursor?

566

What is the federation in sql azure?

79

What is difference between rownum and rowid?

512

What is database architecture? : SQL Server Architecture

555

Do you know what is bit data type and whats the information that can be stored inside a bit column?

558

How you can find out if an index is useful to the optimizer?

499

Does sql server 2000 full-text search support clustering?

510

Explain various On-Delete options in a DB table. Which is the default option?

901

What kind of problems occurs if we do not implement proper locking strategy?

969

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

560

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