Database Management Interview Questions
Questions Answers Views Company eMail

Explain the role of metadata for the three-layer architecture.

504

what is storage manager?

526

What is compound key?

534

Describe why operational and informational systems are separate.

457

What are the steps to follow when preparing to create a table?

450

what are the advantages of using them.

491

Describe the difference between embedded and dynamic sql.

504

Briefly describe an outer join.

504

What are the disadvantage in file processing system?

510

Explain issues for database performance.

501

Describe the difference between homogeneous and heterogeneous distributed database.

508

Describe the four types of indexes.

533

Explain concurrency transparency.

576

what are the different kinds of indexing?

496

What is file manager?

498


Post New Database Management Questions

Un-Answered Questions { Database Management }

What is information schema in database?

495


What's the difference between delete and truncate ?

469


Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

523


Mention few case manipulation functions in sql

523


How do convert or display the date or time as string?

620






Write a query to remove duplicate rows from a table?

455


What is file manager?

498


What are the main differences between primary key and unique key?

494


What are the importance of partitioning in dbms?

517


What are the types of database lock?

548


What's the difference between 'union' and 'union all' ?

488


What is procedure in dbms?

476


How to write udf s in delphi?

521


What are reports in a database?

485


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

447