SQL Server Interview Questions
Questions Answers Views Company eMail

What are the advantages of paper records?

559

What is the difference between sdf and mdf?

681

What is acid db?

521

How do I find my localdb version?

499

What are the 7 disadvantages to a manual system?

516

What is a dbms wizard?

621

What is advantage data architect?

519

What is field in algebra?

630

What is a field name?

517

Where is localdb stored?

567

How do I know if localdb is running?

521

What does normalization do to data?

551

What are the five characteristics of good data?

520

What is data file in computer?

547

Why is normalisation important?

503


Un-Answered Questions { SQL Server }

What is the data type of time?

523


What happens when converting big values to integers?

572


How to set a database state to offline in ms sql server?

543


What are the advantages of mirroring?

574


Do you know the isolation level that sql server support?

530






which backup strategy you are following at ur company

1735


What do you know about system database? : SQL Server Architecture

499


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

104


How do use Having,Group by,Group function in SQL?

1360


Explain what is sql server english query?

533


Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

547


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1577


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

536


What are approximate numeric data types in ms sql server?

593


What is difference between line feed ( ) and carriage return ( )?

529