Database - The Database Environment
Database - The Database Environment
1. A data warehouse uses:
- partial operational data.
- historical operational data.
- future operational data.
- health care data.
2. Metadata enables database designers and users to do all of the following except:
- sample data.
- understand what data exist.
- what the fine distinctions are between similar data items.
- what the data mean.
3. Duplicate data often results in loss of data integrity because:
- the data formats may be inconsistent.
- data values may not agree.
- Both A & B.
- Neither A & B.
4. Legacy data is which of the following?
- Data contained in a newly-installed system
- Data rejected during the installation of a new system
- Data contained in a file system
- Data contained by a system used prior to the installation of a new system
5. A database management system (DBMS) is a:
- hardware system used to create, maintain, and provide controlled access to a database.
- hardware system used to create, maintain, and provide uncontrolled access to a database.
- software system used to create, maintain, and provide controlled access to a database.
- software system used to create, maintain, and provide uncontrolled access to a database.
6. A database application can perform which of the following activities?
- Add records
- Read records
- Update records
- All of the above.
7. An enterprise data model is:
- a graphical model that shows the high-level entities for an organization.
- a graphical model that shows all entities for an organization.
- a non-graphical model that shows the high-level entities for an organization.
- a non-graphical model that shows the all entities for an organization.
8. A shared database should:
- be accurate and available.
- provide for backup and recovery.
- be secure.
- All of the above.
9. Data administrators are responsible for:
- physical database design.
- managing technical issues in the database environment.
- overall management of data resources in an organization.
- writing application programs.
10. Which of the following types of databases are the most common?
- Personal
- Workgroup
- Department
- Enterprise