Database Management Interview Questions
Questions Answers Views Company eMail

What do you understand by sub-queries in sql?

493

What is a deadlock and mention how it can be resolved?

451

Write a query to remove duplicate rows from a table?

465

Write a query to create a duplicate table with and without data present?

462

Explain database partitioning and its importance.

505

Mention the differences between the clustered and non-clustered index

502

write a query to retrieve the last day of next month in oracle.

509

Explain the term entity in dbms?

491

What is index hunting and how does it help in improving query performance?

1510

What do you understand by clause in sql?

528

What are the differences between a dbms and rdbms?

470

Explain the terms specialization and generalization.

525

Explain the term entity set in dbms?

606

Explain the term entity type in dbms?

517

What are the different types of keys in the database?

480


Post New Database Management Questions

Un-Answered Questions { Database Management }

Can you have more than one cursor open at any one time in a program ?

524


Do we consider null values the same as that of blank space or zero?

550


What is the difference between shrink database and shrink file?

476


What are the components of a database management system?

467


Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

1820






What is database management system(dbms)?

541


Is database a storage?

506


What is difference between database and dbms?

488


Explain fully functional dependency?

558


Explain the term entity in dbms?

491


What are the ways to tune reporting services?

502


What do you mean by index hunting?

521


Which software is best for database?

476


Explain the architecture of reporting services?

543


What is the difference between multiload and fastload interms of performance?

503