Databases Interview Questions
Questions Answers Views Company eMail

What are page splits?

577

What are different types of statements that are supported by sql?

584

Characterize join and name diverse sorts of joins?

522

Why would you use sql agent?

723

What are the different types of backups avaialabe in sql server 2005?

616

What is set nocount on?

494

What are the different types of upgrades that can be performed in sql server?

685

What does null mean?

595

What is the difference between truncate and delete commands?

556

What is normalization? What number of normalization shapes are there?

592

What is collation?

711

What are the operating modes in which database mirroring runs?

597

Define self join?

622

Does transparent data encryption provide encryption when transmitting data across the network?

619

What are transactions and its controls?

607


Un-Answered Questions { Databases }

What is sqlca in db2?

523


Which is better Oracle or MS SQL? Why?

5419


What is the anchoring in reports?

1


What are the options which must be set to allow the usage of optimistic models?

505


What is a trigger word?

505






How many types of cluster table in Oracle?

568


What are the limitations of check constraint?

558


What should a dba know?

261


What is the data pump import utility?

573


Why we need sql server?

546


Does mongodb store data in memory?

1


Explain an index segment?

631


What is journaling in mongodb?

1


What is the data pump export utility?

633


what is raid? : Sql server database administration

545