| 1. | Given the evolution of DBMSs, business data is now: |
| a. | Stored in main memory and stays resident there even after the application that uses it terminates. |
| b. | Stored only if it is relevant to business decisions. |
| c. | Stored indefinitely in case it's needed since storing it is much cheaper now. |
| d. | None of the above. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (b).Stored only if it is relevant to business decisions.
|
| 2. | Which of the following is not true of a DBMS? |
| a. | It provides efficient storage and retrieval of data. |
| b. | It has evolved over the years into a fairly simple set of tools that are relatively easy to master. |
| c. | Marketplace demands and product innovation have led to the development of a broad range of features. |
| d. | None of the above. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (b).It has evolved over the years into a fairly simple set of tools that are relatively easy to master.
|
| 3. | Nonprocedural access to a database: |
| a. | Can provide a dramatic improvement in software productivity. |
| b. | Allows a user to submit queries to a database without having to know how the data will be retrieved. |
| c. | Is supported by more than one tool in most DBMSs. |
| d. | All of the above. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (d).All of the above.
|
| 4. | Which of the following statements is not true of a desktop DBMS? |
| a. | They usually run on personal computers or small servers. |
| b. | They have a much lower cost than other DBMSs. |
| c. | Although useful for processing ad hoc queries, they cannot perform transaction processing. |
| d. | They usually support databases used by work teams and small businesses. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (c).Although useful for processing ad hoc queries, they cannot perform transaction processing.
|
| 5. | In the evolution of database technology, second-generation products are considered to be the first true DBMSs because: |
| a. | They were "navigational", i.e. the programmer had to write code to navigate through a network of linked records. |
| b. | Of their foundation on mathematical relations and associated operators. |
| c. | They supported sequential and random searching. |
| d. | They could manage multiple entities and relationships. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (d).They could manage multiple entities and relationships.
|
| 6. | In the evolution of database technology, third-generation products supplanted second-generation systems because: |
| a. | Nonprocedural database access was an improvement over navigational access. |
| b. | IBM supported the CODASYL standard of database definition and manipulation. |
| c. | Nonprocedural languages were still not very efficient. |
| d. | All of the above. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (a).Nonprocedural database access was an improvement over navigational access.
|
| 7. | Which statement is not true of the Three Schema Architecture? |
| a. | It is an official standard of the American Standards Institute (ANSI). |
| b. | It is an architecture for compartmentalizing database descriptions. |
| c. | Its details have been widely adopted in third- and fourth-generation DBMSs. |
| d. | None of the above. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (c).Its details have been widely adopted in third- and fourth-generation DBMSs.
|
| 8. | Which of the following statements is not true of information resource management? |
| a. | It is very different and much more challenging than managing the other physical resources of an organization. |
| b. | Its goal is to use information technology as a tool for processing, distributing, and integrating information throughout an organization. |
| c. | Its emergence has created new management responsibilities. |
| d. | None of the above. |
| View Answer Report Discuss Too Difficult! |
|
Answer: (a).It is very different and much more challenging than managing the other physical resources of an organization.
|
| 9. | A Database Management System (DBMS) is |
| a. | Collection of interrelated data |
| b. | Collection of programs to access data |
| c. | Collection of data describing one particular enterprise |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! |
|
Answer: (d).All of the above
|
| 10. | Data Manipulation Language enables users to |
| a. | Retrieval of information stored in database |
| b. | Insertion of new information into the database |
| c. | Deletion of information from the database |
| d. | All of the above |
| View Answer Report Discuss Too Difficult! |
|
Answer: (d).All of the above
|
