Databases Interview Questions
Questions Answers Views Company eMail

How many types of normalization are there?

487

How do you write an index?

525

Is clustered index a primary key?

528

How do I delete a trigger?

541

How do you delete a table?

538

How do I remove duplicates in two columns?

508

How do I find duplicates in two columns?

552

How can I delete duplicate rows?

562

How do rank () and dense_rank () differ?

519

Are stored procedures faster than queries?

522

What schema means?

524

Is delete faster than truncate?

545

Can we use rowid as primary key?

543

How do you remove duplicate records from a table?

510

How do you truncate?

504


Un-Answered Questions { Databases }

Define join types.

518


What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?

474


Is there any difference between primary key and unique with the not null condition?

529


how to calculate the difference between two dates? : Sql dba

548


What is clustered and nonclustered index in sql?

498






How to rename an existing column in a table?

541


What is sql*plus?

567


What are difference between Cluster index and Non-Cluster index?

608


what is a self join? : Sql server database administration

523


What is the use of Markers?

277


What is trigger in dbms?

517


Explain the use of assign statement in progress database?

525


Explain all codd's rules for relational database system?

521


what's the information that can be stored inside a bit column? : Sql server database administration

527


Does table partitioning require user-defined segments in sybase?

412