Databases Interview Questions
Questions Answers Views Company eMail

How many types of normalization are there?

696

How do you write an index?

733

Is clustered index a primary key?

718

How do I delete a trigger?

744

How do you delete a table?

803

How do I remove duplicates in two columns?

729

How do I find duplicates in two columns?

769

How can I delete duplicate rows?

771

How do rank () and dense_rank () differ?

757

Are stored procedures faster than queries?

722

What schema means?

694

Is delete faster than truncate?

787

Can we use rowid as primary key?

767

How do you remove duplicate records from a table?

710

How do you truncate?

680


Un-Answered Questions { Databases }

What is sqlca in powerbuilder?

774


Explain spool.

927


What is the purpose of the master database?

846


How many types of cluster table in Oracle?

798


State some of the criticism about sybase iq?

679


Which command is used to modify the rows?

562


Is there a row limit in access?

630


how can you get actual data change values from previous transactions in oracle?

830


What is the index requirement in SQL Azure?

86


What is the type of image in database?

649


What is the function of having virtual internet protocol address (vip) in oracle rac?

1


what is not null constraint? : Sql dba

763


Explain the use of grant option in imp command.

762


What is the use of drop command?

1016


How can you determine the space left in a file system?

464