Databases Interview Questions
Questions Answers Views Company eMail

Explain how to maintain a fill factor in existing indexes?

526

Explain difference between control flow and data flow?

528

Explain about temporary stored procedure?

524

Define right outer join in sql server joins?

515

Explain features of analysis services?

523

What is the stuff?

527

Explain about remote stored procedure?

589

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

512

What are the differences between lost updates and uncommitted dependencies?

539

Explain the different index configurations a table can have?

502

How do clustered indexes store data?

613

How to create nested stored procedure?

539

Explain the truncate command?

520

How does stuff differ from the replace function?

550

What's the information that can be stored inside a bit column?

542


Un-Answered Questions { Databases }

what are the security recommendations while using mysql? : Sql dba

578


What is dynamic query?

539


how to create a scrollable cursor with the scroll option? : Sql server database administration

607


Where do you find the default index fill factor and how to change it? : sql server DBA

554


What is the log shipping?

582






Do you know what is difference between index seek vs. Index scan?

517


Why is nosql good?

593


How to convert numeric values to character strings?

520


What is the difference between insert() and insertOne()?

5


What are user defined functions in ms sql server?

508


What is an explain plan and how does it help in optimizing the sql query?

1


Where is sql database stored?

518


What is sql mysql pl sql oracle?

567


How to rollback the current transaction in oracle?

538


What is the purpose of the grep command?

276