SQL Server Interview Questions
Questions Answers Views Company eMail

What are the advantages of paper records?

543

What is the difference between sdf and mdf?

655

What is acid db?

496

How do I find my localdb version?

481

What are the 7 disadvantages to a manual system?

497

What is a dbms wizard?

603

What is advantage data architect?

499

What is field in algebra?

611

What is a field name?

502

Where is localdb stored?

540

How do I know if localdb is running?

501

What does normalization do to data?

529

What are the five characteristics of good data?

507

What is data file in computer?

532

Why is normalisation important?

487


Un-Answered Questions { SQL Server }

Explain datetimeoffset data type in sal server 2008?

520


What are the events recorded in a transaction log?

491


How to enable/disable indexes?

574


How to use copy and concatenate commands in SQL?

584


What is raid, and how it can influence database performance?

560






Tell me something about security and sql azure?

100


Is BCNF better than 2NF & 3NF? Why?

611


What is difference between count (*) and count column?

510


What is difference between table aliases and column aliases? Do they affect performance?

499


do you know how to configure db2 side of the application? : Sql server database administration

585


How do triggers work?

527


What are commit and rollback in sql?

557


Explain Geography datatype in SQL Server

616


What is the difference between for xml raw and for xml auto?

551


What is a transact-sql statement?

524