SQL Server Interview Questions
Questions Answers Views Company eMail

What are the advantages of paper records?

526

What is the difference between sdf and mdf?

637

What is acid db?

474

How do I find my localdb version?

463

What are the 7 disadvantages to a manual system?

481

What is a dbms wizard?

579

What is advantage data architect?

477

What is field in algebra?

589

What is a field name?

486

Where is localdb stored?

522

How do I know if localdb is running?

485

What does normalization do to data?

514

What are the five characteristics of good data?

491

What is data file in computer?

509

Why is normalisation important?

471


Un-Answered Questions { SQL Server }

Explain important index characteristics?

535


Show Practically Sql Server Views are updatable?

568


How to choose all records from the table?

624


Define left outer join in sql server joins?

528


What is the ‘fillfactor’?

546






What are the new data types are introduced in sql 2000?

477


What are the different types of collation sensitivity?

525


What does normalization do to data?

514


How to encrypt Strored Procedure in SQL SERVER?

530


What is Federation Root Database?

90


What are the restrictions applicable while creating views? : SQL Server Architecture

554


Can sql servers link to other servers?

528


How to replace the Query Result 'Null Value' with a text ?

540


Can you explain important index characteristics?

498


Where views are stored in sql server?

529