MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 30 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Another name for multimedia data is unstructured data. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 2. |
The database approach requires additional costs and risks. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 3. |
The source of the data is sometimes called the system of record. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 4. |
Stored representations of objects and events that have meaning and importance in the user's environment are known as a database. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 5. |
The primary mechanism for providing context for data is metadata. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 6. |
Data quality problems currently cost U.S. businesses some $60 million each year (Hudica, 2003). |
| A. | 1 |
| B. | |
| Answer» C. | |
| 7. |
Stand-alone databases exhibit many of the same advantages common to file processing systems. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 8. |
The most common source of database failures in an organization is the failure to implement a strong database administration function. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
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. | |
| 10. |
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. | |
| 11. |
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. | |
| 12. |
Database management systems were first introduced in the 1950s. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 13. |
Some advantages of the database approach include all, but: |
| A. | minimal data redundancy. |
| B. | improved data consistency. |
| C. | improved data sharing. |
| D. | program-data dependency. |
| Answer» E. | |
| 14. |
An advantage of the database approach is the creation of maximum data redundancy. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 15. |
Data descriptions are stored in a central location called the depository. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 16. |
An enterprise data model is a relational model that shows the high-level entities for the organization and associations among those entities. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 17. |
An enterprise data model is: |
| A. | a graphical model that shows the high-level entities for an organization. |
| B. | a graphical model that shows all entities for an organization. |
| C. | a non-graphical model that shows the high-level entities for an organization. |
| D. | a non-graphical model that shows the all entities for an organization. |
| Answer» B. a graphical model that shows all entities for an organization. | |
| 18. |
Which of the following types of databases are the most common? |
| A. | Personal |
| B. | Workgroup |
| C. | Department |
| D. | Enterprise |
| Answer» D. Enterprise | |
| 19. |
A workgroup typically comprises between 25 and 100 persons. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 20. |
Databases that contain historical and summarized information are usually called data warehouses. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 21. |
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. | |
| 22. |
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 | |
| 23. |
Metadata enables database designers and users to do all of the following except: |
| A. | sample data. |
| B. | understand what data exist. |
| C. | what the fine distinctions are between similar data items. |
| D. | what the data mean. |
| Answer» B. understand what data exist. | |
| 24. |
A database application can perform which of the following activities? |
| A. | Add records |
| B. | Read records |
| C. | Update records |
| D. | All of the above. |
| Answer» E. | |
| 25. |
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. | |
| 26. |
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. | |
| 27. |
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. | |
| 28. |
Which of the following is true for a relational database? |
| A. | Data is represented by tables. |
| B. | It is difficult to access data. |
| C. | Complex programs have to be written for simple queries. |
| D. | All of the above. |
| Answer» B. It is difficult to access data. | |
| 29. |
All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 30. |
A data warehouse uses: |
| A. | partial operational data. |
| B. | historical operational data. |
| C. | future operational data. |
| D. | health care data. |
| Answer» C. future operational data. | |