1. The practical significance of taking the logical view of a database is that it serves as a
reminder of the simple file concept of data storage.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Moderate REF:
...
1. The practical significance of taking the logical view of a database is that it serves as a
reminder of the simple file concept of data storage.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Moderate REF: p.73
NAT: BUSPROG: Analytic STATE: DISC: Information Technology
KEY: Bloom’s:Comprehension TOP: A Logical View of Data
2. You can think of a table as a persistent representation of a logical relation.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF. p.74
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: A Logical View of Data
3. The order of the rows and columns is important to the DBMS.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.74
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: A Logical View of Data
4. Character data can contain any character or symbol intended for mathematical
manipulation.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.75
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: A Logical View of Data
5. The row’s range of permissible values is known as its domain.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF:
p.75
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s Knowledge TOP: A Logical View of Data
6. The idea of determination is unique to the database environment.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Moderate REF: p.76
NAT: BUSPROG: Analytic STATE: DISC: Information Technology
KEY: Bloom’s Comprehension TOP: Keys
7. Only a single attribute, not multiple attributes, can define functional dependence.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.76
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: Keys
8. If the attribute (B) is functionally dependent on a composite key (A) but not on any subset
of that composite key, the attribute (B) is fully functionally dependent on (A).
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Moderate REF: p.77
NAT: BUSPROG: Analytic STATE: DISC: Information Technology
KEY: Bloom’s Comprehension TOP: Keys
9. A null is created when you press the Enter key or the Tab key to move to the next entry
without making a prior entry of any kind.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF:
p.78
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: Keys
10. Depending on the sophistication of the application development software, nulls can create
problems when functions such as COUNT, AVERAGE, and SUM are used.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.78
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: Keys
11. RDBMSs enforce integrity rules automatically.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF:
p.80
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: Integrity Rules
12. Relational algebra defines the theoretical way of manipulating table contents using
relational operators.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.82
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: Relational Algebra
13. The SELECT operator yields a vertical subset of a table.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF:
p.83
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: Relational Algebra
14. The DIFFERENCE operator subtracts one table from the other.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.85
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: Relational Algebra
15. In a natural join, the column on which the join was made occurs twice in the new table.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Easy REF: p.88
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: Relational Algebra
16. The DIVIDE operation uses one singlecolumn table (e.g., column “a”) as the divisor and
one twocolumn table (e.g., columns “a” and “b”) as the dividend.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF:
p.90
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s:Knowledge TOP: Relational Algebra
17. A data dictionary is sometimes described as “the database designer’s database” because it
records the design
decisions about tables and their structures.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.91
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: The Data Dictionary and the System Catalog
18. The onetomany (1:M) relationship is easily implemented in the relational model by putting
the foreign key of the “1” side in the table of the “many” side as a primary key.
1. True
2. False
ANSWER: False
PTS: 1 DIF: Difficulty: Moderate REF: p.94
NAT: BUSPROG: Analytic STATE: DISC: Information Technology
KEY: Bloom’s Comprehension TOP: Relationships within the Relational Database
19. As rare as 1:1 relationships should be, certain conditions absolutely require their use.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF: p.96
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: Relationships within the Relational Database
20. Each table in a relational database must have a primary key.
1. True
2. False
ANSWER: True
PTS: 1 DIF: Difficulty: Easy REF:
p.20
NAT: BUSPROG: Technology STATE: DISC: Information Technology
KEY: Bloom’s: Knowledge TOP: A Logical View of Data
[Show More]
