| 41. | Which one of the following statements is false? |
| a. | The data dictionary is normally maintained by the database administrator. |
| b. | Data elements in the database can be modified by changing the data dictionary. |
| c. | The data dictionary contains the name and description of each data element. |
| d. | The data dictionary is a tool used exclusively by the database administrator. |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Data elements in the database can be modified by changing the data dictionary.
|
| 42. | An advantage of the database management approach is |
| a. | data is dependent on programs. |
| b. | data redundancy increases. |
| c. | data is integrated and can be accessed by multiple programs. |
| d. | none of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (c).data is integrated and can be accessed by multiple programs.
|
| 43. | It is possible to define a schema completely using |
| a. | VDL and DDL |
| b. | DDL and DML |
| c. | SDL and DDL |
| d. | VDL and DML |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).DDL and DML
|
| 44. | Data independence means |
| a. | data is defined separately and not included in programs. |
| b. | programs are not dependent on the physical attributes of data. |
| c. | programs are not dependent on the logical attributes of data. |
| d. | both b and c. |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (d).both b and c.
|
| 45. | DBMS helps achieve |
| a. | Data independence |
| b. | Centralized control of data |
| c. | Neither a nor b |
| d. | Both a and b |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (d).Both a and b
|
| 46. | It is better to use files than a DBMS when there are |
| a. | Stringent real-time requirements. |
| b. | Multiple users wish to access the data. |
| c. | Complex relationships among data. |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Multiple users wish to access the data.
|
| 47. | The users who use easy-to-use menu are called |
| a. | Sophisticated end users |
| b. | Naive users |
| c. | Stand-alone users |
| d. | Casual end users |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Naive users
|
| 48. | Which database level is closest to the users? |
| a. | External |
| b. | Internal |
| c. | Physical |
| d. | Conceptual |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (a).External
|
| 49. | Which are the two ways in which entities can participate in a relationship? |
| a. | Passive and active |
| b. | Total and partial |
| c. | Simple and Complex |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (b).Total and partial
|
| 50. | Which of the following database object does not physically exist? |
| a. | base table |
| b. | index |
| c. | view |
| d. | none of the above |
| View Answer Report Discuss Too Difficult! Search Google |
|
Answer: (c).view
|
