Databases Interview Questions
Questions Answers Views Company eMail

What is fill factor and pad index?

531

What are constraints in microsoft sql server?

551

What is user-defined function?

557

What guidelines should be followed to help minimize deadlocks?

498

Differentiate between ms sql server reporting services vs crystal reports?

479

What is the use of keyword with encryption.

570

What is default constraint in ms sql server?

528

Explain transaction server explicit transaction?

498

What is exporting utility?

535

What is the use of keyword with encryption. Create a store procedure with encryption?

573

Explain time data type in sal server 2008?

542

Explain transaction server isolation?

535

What is thr feature of change data capture?

498

What is exporting and importing utility?

602

Explain transaction server distributed transaction?

495


Un-Answered Questions { Databases }

How to drop an existing view in mysql?

523


what is a trigger? : Sql dba

568


Is mysql frontend or backend?

475


What is localdb mssqllocaldb?

608


What is the difference between composite index and covering index?

501






What is a ddl command?

527


What is replication and database mirroring?

568


Can we join tables without foreign key?

516


What is a constant or literal in ms sql server?

584


What is cast in mysql?

468


What are the limitations of rdbms?

525


What is the difference between an index and a unique index?

538


what is blob? : Sql dba

555


What are the different kinds of ssrs reports?

170


What do you mean by fill factor concept with respect to indexes?

494