MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 24 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
The database approach requires additional costs and risks.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 3. |
The primary mechanism for providing context for data is metadata.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
Stand-alone databases exhibit many of the same advantages common to file processing systems.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
An advantage of the database approach is the creation of maximum data redundancy.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
The most common source of database failures in an organization is the failure to implement a strong database administration function.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003).%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
Databases that contain historical and summarized information are usually called data warehouses.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 9. |
Another name for multimedia data is unstructured data.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
The source of the data is sometimes called the system of record.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 11. |
Database management systems were first introduced in the 1950s.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 12. |
Stored representations of objects and events that have meaning and importance in the user's environment are known as a database.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 13. |
A workgroup typically comprises between 25 and 100 persons.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.%! |
| A. | True |
| B. | False |
| Answer» B. False | |
| 15. |
Data descriptions are stored in a central location called the depository.%! |
| A. | True |
| B. | False |
| Answer» C. | |
| 16. |
*/*_A database management system (DBMS) is a:? |
| A. | hardware system used to create, maintain, and provide controlled access to a database. |
| B. | hardware system used to create, maintain, and provide uncontrolled access to a database. |
| C. | software system used to create, maintain, and provide controlled access to a database. |
| D. | software system used to create, maintain, and provide uncontrolled access to a database. |
| Answer» D. software system used to create, maintain, and provide uncontrolled access to a database. | |
| 17. |
*/*_An extranet is which of the following?? |
| A. | The use of Internet protocols with limited access to company data by the company's customers and suppliers. |
| B. | The use of Internet protocols with unlimited access to company data by the company's customers and suppliers. |
| C. | The use of Internet protocols with limited access to company data by people within an organization. |
| D. | The use of Internet protocols with unlimited access to company data by people within an organization. |
| Answer» B. The use of Internet protocols with unlimited access to company data by the company's customers and suppliers. | |
| 18. |
*/*_Which of the following types of databases are the most common?? |
| A. | Personal |
| B. | Workgroup |
| C. | Department |
| D. | Enterprise |
| Answer» D. Enterprise | |
| 19. |
_ Legacy data is which of the following?$? |
| A. | Data contained in a newly-installed system |
| B. | Data rejected during the installation of a new system |
| C. | Data contained in a file system |
| D. | Data contained by a system used prior to the installation of a new system |
| Answer» E. | |
| 20. |
_ Structured data may include which of the following?$? |
| A. | Photo image |
| B. | Video clip |
| C. | Dates |
| D. | None of the above |
| Answer» D. None of the above | |
| 21. |
_ Data administrators are responsible for:$? |
| A. | physical database design. |
| B. | managing technical issues in the database environment. |
| C. | overall management of data resources in an organization. |
| D. | writing application programs. |
| Answer» D. writing application programs. | |
| 22. |
Duplicate data often results in loss of data integrity because:$? |
| A. | the data formats may be inconsistent. |
| B. | data values may not agree. |
| C. | Both A & B. |
| D. | Neither A & B. |
| Answer» D. Neither A & B. | |
| 23. |
An enterprise database is which of the following?$? |
| A. | A database designed to support only users external to an organization |
| B. | A database designed to support an entire organization |
| C. | A database designed to support a relatively small group |
| D. | A database designed to support a single PC |
| Answer» C. A database designed to support a relatively small group | |
| 24. |
A shared database should:$? |
| A. | be accurate and available. |
| B. | provide for backup and recovery. |
| C. | be secure. |
| D. | All of the above. |
| Answer» E. | |