Q1. Another name for the data dictionary in a database is the:
A. validation data.
B. relational data.
C. database management system.
D. database schema.
Q2. Field attributes (such as data type and field size) in a database are also known as:
A. metadata.
B. default values.
C. field names.
D. primary keys.
Q3. When entering data, violations of ____________ usually result in error messages.
A. data entry
B. validation rules
C. arithmetic operators
D. computation
Q4. ____________ are the values the database will automatically use for the field unless the user enters another value.
A. Data types
B. Default values
C. Validated data
D. Metadata
Q5. Common types of validation checks include all of the following, EXCEPT:
A. range.
B. completeness.
C. redundancy.
D. consistency.
Q6. Range checks ensure that the data entered falls within the set ____________, which are properties that must be satisfied for an entry to be accepted into a field.
A. field constraints
B. default values
C. validations
D. descriptions
Q7. In addition to keying data directly into the database, data entry can be done from a(n):
A. input form.
B. table.
C. field.
D. data dictionary.
Q8. ____________ is the process within the database design of ensuring that data entered into a database meets validation rules.
A Proofreading
B. Authorization
C. Validation
D. Computation
Q9. The phrase �>5.50 And <20� is an example of a(n) ____________ check to validate data in a database.
A. requirements
B. completeness
C. range
D. insurance
Q10. A(n) ____________ check confirms that only text characters are entered in a field.
A. alphabetic
B. numeric
C. completeness
D. range
Q11. A(n) ____________ check ensures that all fields in a database defined as �required� have data entered into them.
A. requirements
B. completeness
C. consistency
D. alphabetic and numeric
Q12. A ____________ check compares the values of data in two or more fields to see if these values are reasonable.
A. constraint
B. completeness
C. consistency
D. range
Q13. Making a field ____________ means that it cannot be left blank.
A. numeric
B. required
C. calculated
D. validated
Q14. ____________ organizes a database into the order you need.
A. Browsing
B. Scrolling
C. Sorting
D. Querying
Q15. SQL is based on a branch of mathematics called:
A. structured algebra.
B. data-driven calculus.
C. artificial intelligence.
D. relational algebra.
Q16. A(n) ____________ query displays a subset of data from one table based on specified criteria.
A. select
B. variable
C. operational
D. join
Q17. A ____________ query displays a subset of data from two or more tables using a common field.
A. select
B. complex
C. table
D. join
Q18. A(n) ____________ enables users to have the database select and display records that match a certain criteria.
A. query
B. sort
C. operation
D. join
Q19. The process of reducing redundancy in a database is called:
A. a consistency check.
B. normalization.
C. metadata.
D. schema.
Q20. The primary key must be a(n) ____________ field.
A. numeric
B. object
C. unique
D. related
Q21. A ____________ is a large-scale electronic repository of data that is time-variant.
A. data warehouse
B. data mine
C. knowledge-based system
D. decision support system
Q22. The premise behind a relational database is that ____________ are established among the tables.
A. relationships
B. schema
C. consistencies
D. normalizations
Q23. ____________ is the term used for extracting data from source databases, transforming or reformatting the data, and storing it in the data warehouse.
A. Data staging
B. Validation
C. Normalization
D. Clickstream data
Q24. All of the following are types of reports generated by a management information system, EXCEPT:
A. summary
B. detail
C. exception
D. validation
Q25. Which of the following items is NOT a major component of a decision support system (DSS)?
A. internal and external data sources
B. data warehousing
C. model management systems
D. knowledge-based systems
ANSWERS:
1. D 11. B 21. A
2. A 12. C 22. A
3. B 13. B 23. A
4. B 14. C 24. D
5. A 15. D 25. B
6. B 16. A
7. A 17. D
8. C 18. A
9. C 19. B
10. A 20. C
A. validation data.
B. relational data.
C. database management system.
D. database schema.
Q2. Field attributes (such as data type and field size) in a database are also known as:
A. metadata.
B. default values.
C. field names.
D. primary keys.
Q3. When entering data, violations of ____________ usually result in error messages.
A. data entry
B. validation rules
C. arithmetic operators
D. computation
Q4. ____________ are the values the database will automatically use for the field unless the user enters another value.
A. Data types
B. Default values
C. Validated data
D. Metadata
Q5. Common types of validation checks include all of the following, EXCEPT:
A. range.
B. completeness.
C. redundancy.
D. consistency.
Q6. Range checks ensure that the data entered falls within the set ____________, which are properties that must be satisfied for an entry to be accepted into a field.
A. field constraints
B. default values
C. validations
D. descriptions
Q7. In addition to keying data directly into the database, data entry can be done from a(n):
A. input form.
B. table.
C. field.
D. data dictionary.
Q8. ____________ is the process within the database design of ensuring that data entered into a database meets validation rules.
A Proofreading
B. Authorization
C. Validation
D. Computation
Q9. The phrase �>5.50 And <20� is an example of a(n) ____________ check to validate data in a database.
A. requirements
B. completeness
C. range
D. insurance
Q10. A(n) ____________ check confirms that only text characters are entered in a field.
A. alphabetic
B. numeric
C. completeness
D. range
Q11. A(n) ____________ check ensures that all fields in a database defined as �required� have data entered into them.
A. requirements
B. completeness
C. consistency
D. alphabetic and numeric
Q12. A ____________ check compares the values of data in two or more fields to see if these values are reasonable.
A. constraint
B. completeness
C. consistency
D. range
Q13. Making a field ____________ means that it cannot be left blank.
A. numeric
B. required
C. calculated
D. validated
Q14. ____________ organizes a database into the order you need.
A. Browsing
B. Scrolling
C. Sorting
D. Querying
Q15. SQL is based on a branch of mathematics called:
A. structured algebra.
B. data-driven calculus.
C. artificial intelligence.
D. relational algebra.
Q16. A(n) ____________ query displays a subset of data from one table based on specified criteria.
A. select
B. variable
C. operational
D. join
Q17. A ____________ query displays a subset of data from two or more tables using a common field.
A. select
B. complex
C. table
D. join
Q18. A(n) ____________ enables users to have the database select and display records that match a certain criteria.
A. query
B. sort
C. operation
D. join
Q19. The process of reducing redundancy in a database is called:
A. a consistency check.
B. normalization.
C. metadata.
D. schema.
Q20. The primary key must be a(n) ____________ field.
A. numeric
B. object
C. unique
D. related
Q21. A ____________ is a large-scale electronic repository of data that is time-variant.
A. data warehouse
B. data mine
C. knowledge-based system
D. decision support system
Q22. The premise behind a relational database is that ____________ are established among the tables.
A. relationships
B. schema
C. consistencies
D. normalizations
Q23. ____________ is the term used for extracting data from source databases, transforming or reformatting the data, and storing it in the data warehouse.
A. Data staging
B. Validation
C. Normalization
D. Clickstream data
Q24. All of the following are types of reports generated by a management information system, EXCEPT:
A. summary
B. detail
C. exception
D. validation
Q25. Which of the following items is NOT a major component of a decision support system (DSS)?
A. internal and external data sources
B. data warehousing
C. model management systems
D. knowledge-based systems
ANSWERS:
1. D 11. B 21. A
2. A 12. C 22. A
3. B 13. B 23. A
4. B 14. C 24. D
5. A 15. D 25. B
6. B 16. A
7. A 17. D
8. C 18. A
9. C 19. B
10. A 20. C
No comments:
Post a Comment