ROWS WITH COMMON VALUES IN THEIR COMMON ATTRIBUTE

QUESTION 1. A (n) ________ links tables by selecting only the rows with common values in their common attribute(s).                (0.25 points)

1. Foreign join

1. Outer join

1. natural join

1. equijoin

QUESTION 2. A (n) ________ links tables by selecting only the rows with common values in their common attribute(s).                (0.25 points)

1. foreign join

1. outer join

1. natural join

1. equijoin

QUESTION 3. A table that is in 2NF and contains no transitive dependencies is said to be in ________.   (0.25 points)

1. 1NF

1. 2NF

1. 3NF

1. 4NF

QUESTION 4. The normalization process involves assigning ________ to tables based on the concept of determination.                (0.25 points)

1. attributes

1. relations

1. data

1. files

QUESTION 5. Lower normalization forms occur (and are even required) in specialized databases known as ________.                (0.25 points)

1. data dumps

1. operational databases

1. data warehouses

1. historical databases

QUESTION 6. Each table is perceived as a ________.      (0.25 points)

1. two-dimensional structure

1. graph

1. linked structure

1. three-dimensional structure

QUESTION 7. Nulls, if used improperly, can create problems because they can represent ________.      (0.25 points)

1. a known, but missing, attribute value

1. zero

1. an unsortable value

1. a default value

QUESTION 8. A(n) ________ attribute is not part of a key.           (0.25 points)

1. nonprime

1. composite

1. prime

1. assigned

QUESTION 9. An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ________.                (0.25 points)

1. candidate key

1. superkey

1. secondary key

1. primary key

QUESTION 10. Data redundancy produces ________.    (0.25 points)

1. robust design

1. slower lookups

1. data integrity problems

1. efficient storage use

QUESTION 11. A table can be logically connected to another table by defining a ________.          (0.25 points)

1. primary key

1. superkey

1. hyperlink

1. common attribute

QUESTION 12. A ________ functionally determines all of the row`s attributes.   (0.25 points)

1. combined key

1. foreign key

1. primary key

1. superkey

QUESTION 13. Given the following table definition, how many tables would be produced by the conversion to 2NF? 1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, ASSIGN_HOURS)           (0.25 points)

1. one

1. two

1. three

1. four

QUESTION 14. In a normalized database, what is represented by each table?      (0.25 points)

1. an entire application

1. a single subject

1. a functional area

1. one attribute

QUESTION 15. The use of a(n) ________ relationship ensures that two entity sets are not placed in the same table when they should not be.        (0.25 points)

1. 1:1

1. 1:M

1. M:1

1. M:N

QUESTION 16. Date attributes contain calendar dates stored in a special format known as the ________ date format.                (0.25 points)

1. Julian

1. Augustan

1. Jamesian

1. Gregorian

QUESTION 17. In an ideal (database design) world, the level of desired granularity is determined at the ________ design or at the requirements gathering phase.    (0.25 points)

1. functional

1. data

1. conceptual

1. external

QUESTION 18. A table that has all key attributes defined, no repeating groups, and an identified primary key is said to be in ________.         (0.25 points)

1. 1NF

1. 2NF

1. 3NF

1. 4NF

QUESTION 19. A ________ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.             (0.25 points)

1. candidate

1. foreign

1. surrogate

1. composite

QUESTION 20. A relational operator that yields all values for selected attributes is known as the ________ operator.                (0.25 points)

1. select

1. difference

1. project

1. product

QUESTION 21. A relational operator that yields all rows in one table that are not found in the other table is the ________ operator.             (0.25 points)

1. difference

1. union

1. product

1. intersect

QUESTION 22. A table that is in 2NF and contains no transitive dependencies is said to be in ________. (0.25 points)

1. 1NF

1. 2NF

1. 3NF

1. 4NF

QUESTION 23. The normalization process involves assigning ________ to tables based on the concept of determination.                (0.25 points)

1. attributes

1. relations

1. data

1. files

QUESTION 24. Lower normalization forms occur (and are even required) in specialized databases known as ________.                (0.25 points)

1. data dumps

1. operational databases

1. data warehouses

1. historical databases

QUESTION 25. Each table is perceived as a ________.    (0.25 points)

1. two-dimensional structure

1. graph

1. linked structure

1. three-dimensional structure

QUESTION 26. Nulls, if used improperly, can create problems because they can represent ________.    (0.25 points)

1. a known, but missing, attribute value

1. zero

1. an unsortable value

1. a default value

QUESTION 27. A(n) ________ attribute is not part of a key.        (0.25 points)

1. nonprime

1. composite

1. prime

1. assigned

QUESTION 28. An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ________.         (0.25 points)

1. candidate key

1. superkey

1. secondary key

1. primary key

QUESTION 29. Data redundancy produces ________.    (0.25 points)

1. robust design

1. slower lookups

1. data integrity problems

1. efficient storage use

QUESTION 30. A table can be logically connected to another table by defining a ________.          (0.25 points)

1. primary key

1. superkey

1. hyperlink

1. common attribute

QUESTION 31. A ________ functionally determines all of the row`s attributes.   (0.25 points)

1. combined key

1. foreign key

1. primary key

1. superkey

QUESTION 32. Given the following table definition, how many tables would be produced by the conversion to 2NF? 1NF (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, ASSIGN_HOURS)           (0.25 points)

1. one

1. two

1. three

1. four

QUESTION 33. In a normalized database, what is represented by each table?      (0.25 points)

1. an entire application

1. a single subject

1. a functional area

1. one attribute

QUESTION 34. The use of a(n) ________ relationship ensures that two entity sets are not placed in the same table when they should not be.        (0.25 points)

1. 1:1

1. 1:M

1. M:1

1. M:N

QUESTION 35. Date attributes contain calendar dates stored in a special format known as the ________ date format.                (0.25 points)

1. Julian

1. Augustan

1. Jamesian

1. Gregorian

QUESTION 36. In an ideal (database design) world, the level of desired granularity is determined at the ________ design or at the requirements gathering phase.    (0.25 points)

1. functional

1. data

1. conceptual

1. external

QUESTION 37. A table that has all key attributes defined, no repeating groups, and an identified primary key is said to be in ________.         (0.25 points)

1. 1NF

1. 2NF

1. 3NF

1. 4NF

QUESTION 38. A ________ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.             (0.25 points)

1. candidate

1. foreign

1. surrogate

1. composite

QUESTION 39. A relational operator that yields all values for selected attributes is known as the ________ operator.                (0.25 points)

1. select

1. difference

1. project

1. product

QUESTION 40. A relational operator that yields all rows in one table that are not found in the other table is the ________ operator.             (0.25 points)

1. difference

1. union

1. product

1. intersect