Query Trees Notations Quiz with Answers PDF Download – Test 45

In the notation for query trees, the node which is used to terminate the execution is classified as

1. attribute nodes
2. leaf nodes
3. stem nodes
4. root nodes

The technique used in DBMS to store all the related objects in the mixed file is classified as

1. ternary clustering
2. secondary clustering
3. physical clustering
4. primary clustering

In database management system, the module which support handling of data search, data access and data storage is classified as

1. structural module
2. logical module
3. client module
4. server module

The person who implements the specifications of the database programs is considered as

1. software engineers
2. application programmers
3. software developers
4. all of above

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