Chapter 1: Client/Server Databases and the Oracle10g Relational Database
TRUE/FALSE
1. In a data file, a record contains one piece of information such as a person’s last name.
ANS: F PTS: 1 REF: 2
2. A DBMS is usually administered by several programmers.
ANS: F PTS: 1 REF: 4
3. Redundant data is a big problem because it can become inconsistent.
ANS: T PTS: 1 REF: 4
4. A relational database was the earlier type of database, but is no longer used in modern computing.
ANS: F PTS: 1 REF: 5
5. Relationships between entities in database tables are maintained using key fields.
ANS: T PTS: 1 REF: 5
6. NULL is a valid value for a primary key.
ANS: F PTS: 1 REF: 6
, 7. A candidate key for a database table can change often as long as it is unique.
ANS: F PTS: 1 REF: 6
8. Oracle can automatically generate surrogate keys.
ANS: T PTS: 1 REF: 7
9. A customer database table with columns first_name, last_name, and phone_number would
probably need to use a surrogate key.
ANS: T PTS: 1 REF: 7
10. A foreign key value must exist in the table where it is a primary key.
ANS: T PTS: 1 REF: 9
11. A composite key usually comprises fields that are foreign keys in other tables.
ANS: F PTS: 1 REF: 10
12. Database design is usually a very simple task since it is always obvious what tables should be
created and how they are related.
ANS: F PTS: 1 REF: 11
13. There are two main tasks involved with the design of a database: developing an entity-
relationship (ER) model and regulating the database tables.
ANS: F PTS: 1 REF: 11
,14. In an ER diagram a 1:M relationship shows a simple straight line between two entities.
ANS: F PTS: 1 REF: 11-12
15. A student can take many different classes in the same term, and each class can be composed of
many different students; this is an example of a many-to-many relationship.
ANS: T PTS: 1 REF: 12
16. During the design of the actual database tables, the N:M relationship is broken down into a series
of two or more 1:M relationships through the use of a linking table in the process of
normalization.
ANS: T PTS: 1 REF: 12
17. The purpose of normalization is to store data efficiently in the least possible amount of space.
ANS: F PTS: 1 REF: 12
18. Data is considered to be normalized as long as a primary key has been designated.
ANS: F PTS: 1 REF: 13
19. First normal form means that the data has been organized in such a manner that it has a primary
key and no repeating groups.
ANS: T PTS: 1 REF: 14
20. A shorthand method of identifying a table and its contents is to give the name of the table
followed by a list of the column names and data types, separated by commas, within a set of
square brackets.
, ANS: F PTS: 1 REF: 14
21. A transitive dependency means that the fields within the table are dependent only on part of the
primary key.
ANS: F PTS: 1 REF: 16
22. The final step in the normalization process is to convert the tables to fourth normal form (4NF).
ANS: F PTS: 1 REF: 16
23. During the normalization process, it is common to decrease the number of tables in the database
design.
ANS: F PTS: 1 REF: 16-17
24. A terminal is a program that requests and uses server resources.
ANS: F PTS: 1 REF: 17
25. MS Access is an example of a client/server database.
ANS: F PTS: 1 REF: 18
26. It is possible to use a personal database in a multiuser environment.
ANS: T PTS: 1 REF: 18
27. A personal database should only be used for non-mission-critical applications.
TRUE/FALSE
1. In a data file, a record contains one piece of information such as a person’s last name.
ANS: F PTS: 1 REF: 2
2. A DBMS is usually administered by several programmers.
ANS: F PTS: 1 REF: 4
3. Redundant data is a big problem because it can become inconsistent.
ANS: T PTS: 1 REF: 4
4. A relational database was the earlier type of database, but is no longer used in modern computing.
ANS: F PTS: 1 REF: 5
5. Relationships between entities in database tables are maintained using key fields.
ANS: T PTS: 1 REF: 5
6. NULL is a valid value for a primary key.
ANS: F PTS: 1 REF: 6
, 7. A candidate key for a database table can change often as long as it is unique.
ANS: F PTS: 1 REF: 6
8. Oracle can automatically generate surrogate keys.
ANS: T PTS: 1 REF: 7
9. A customer database table with columns first_name, last_name, and phone_number would
probably need to use a surrogate key.
ANS: T PTS: 1 REF: 7
10. A foreign key value must exist in the table where it is a primary key.
ANS: T PTS: 1 REF: 9
11. A composite key usually comprises fields that are foreign keys in other tables.
ANS: F PTS: 1 REF: 10
12. Database design is usually a very simple task since it is always obvious what tables should be
created and how they are related.
ANS: F PTS: 1 REF: 11
13. There are two main tasks involved with the design of a database: developing an entity-
relationship (ER) model and regulating the database tables.
ANS: F PTS: 1 REF: 11
,14. In an ER diagram a 1:M relationship shows a simple straight line between two entities.
ANS: F PTS: 1 REF: 11-12
15. A student can take many different classes in the same term, and each class can be composed of
many different students; this is an example of a many-to-many relationship.
ANS: T PTS: 1 REF: 12
16. During the design of the actual database tables, the N:M relationship is broken down into a series
of two or more 1:M relationships through the use of a linking table in the process of
normalization.
ANS: T PTS: 1 REF: 12
17. The purpose of normalization is to store data efficiently in the least possible amount of space.
ANS: F PTS: 1 REF: 12
18. Data is considered to be normalized as long as a primary key has been designated.
ANS: F PTS: 1 REF: 13
19. First normal form means that the data has been organized in such a manner that it has a primary
key and no repeating groups.
ANS: T PTS: 1 REF: 14
20. A shorthand method of identifying a table and its contents is to give the name of the table
followed by a list of the column names and data types, separated by commas, within a set of
square brackets.
, ANS: F PTS: 1 REF: 14
21. A transitive dependency means that the fields within the table are dependent only on part of the
primary key.
ANS: F PTS: 1 REF: 16
22. The final step in the normalization process is to convert the tables to fourth normal form (4NF).
ANS: F PTS: 1 REF: 16
23. During the normalization process, it is common to decrease the number of tables in the database
design.
ANS: F PTS: 1 REF: 16-17
24. A terminal is a program that requests and uses server resources.
ANS: F PTS: 1 REF: 17
25. MS Access is an example of a client/server database.
ANS: F PTS: 1 REF: 18
26. It is possible to use a personal database in a multiuser environment.
ANS: T PTS: 1 REF: 18
27. A personal database should only be used for non-mission-critical applications.
