Query Trees Notations Quiz with Answers PDF Download – Test 45

MCQ 221: 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

MCQ 222: 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

MCQ 223: 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

MCQ 224: 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

MCQ 225: 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