Select the best answer from the list of choices. 12. Which of the following is n
ID: 3697003 • Letter: S
Question
Select the best answer from the list of choices.
12. Which of the following is not a benefit of a well-designed relational database?
a. Reduces redundant data
b. Has lower overall storage requirements
c. Improves reporting flexibility
d. Is easier to create than a single-table database
13. First normal form can be described as:
a. A well-functioning, fully developed relational database.
b. Any collection of data in any form.
c. A single two-dimensional table with rows and columns.
d. A series of queries and subqueries.
14. Which of the following activities occurs during the creation of second normal form?
a. Redundant data is removed from one table, and relationships are created.
b. Calculated fields are removed from tables.
c. Additional calculated fields are added to tables.
d. All data is organized in one master table.
15. Which of the following activities occurs during the creation of third normal form?
a. All data is organized in one master table.
b. Calculated fields are removed from tables.
c. Additional calculated fields are added to tables.
d. Redundant data is removed from one table, and relationships are created.
16. Which report property is used to add a watermark to a report?
a. Record Source
c. Default View
b. Caption
d. Picture
17. A multifield primary key consists of:
a. Two or more fields.
c. An AutoNumber field.
b. One field.
d. A primary key field that also serves as a foreign key field.
18. Which of the following is not true for the Caption property?
a. It is the default field name at the top of the field column in datasheets.
b. The value of the Caption property is the default label that describes a field on a report.
c. The value of the Caption property is the default label that describes a field on a form.
d. It is used instead of the field name when you build expressions.
19. Which of the following fields would most likely be used for an index?
a. MiddleName
c. ApartmentNumber
b. FirstName
d. LastName
20. Which of the following phrases best describes the need for both null values and zero-length strings?
a. They represent two different conditions.
b. Having two different choices for “nothing” clarifies data entry.
c. Null values speed up calculations.
d. They look different on a query datasheet
Explanation / Answer
Answer:
12 . c) Improves reporting flexibility
relational data base reduces redundancy. If redundancy can be removed then storage will decrease also. It is easy as well.
13. c) A single two-dimensional table with rows and columns.
Any form cant be the answer as each normal form have different representation in which data is present series of queries and all in one where related to 1NF
14. a) Redundant data is removed from one table, and relationships are created.
15. b) b. Calculated fields are removed from tables.
16. b) Caption
17. c. An Auto Number field.
18. d. It is used instead of the field name when you build expressions.
19. c. Apartment Number
20. a. They represent two different conditions.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.