Database Management System Advantages MCQ (Multiple Choice Questions) PDF Download

The implications of database management approaches includes

1. flexibility
2. economies of scale
3. reduced development time
4. all of theses

The files used for speedy disk search by providing the specialized structures of data are classified as

1. indexes
2. glossaries
3. content specification
4. listing documents

The problem arises because of incompatibility between data structures of programming language and database management structures is called

1. structural dependency problem
2. logical redundancy problem
3. structural specification problem
4. impedance mismatch problem

One of the module in the database management system which is responsible for choosing efficient execution plan considering queries is considered as

1. index and glossary optimization
2. query processing and optimization
3. structural optimization
4. content optimization

In database management system, the types of data structures used in indexes are

1. hash data structures
2. tree data structures
3. content and glossary structures
4. both a and b