Discussion
Home ‣ Database ‣ Database Design Using Normalization Comments
- Question
Normalization requires programmers to write more complex SQL.
Options- A. True
- B. False
- Correct Answer
- True
- 1. Denormalized tables are in BCNF.
Options- A. True
- B. False Discuss
- 2. In all cases, normalization into BCNF is desirable.
Options- A. True
- B. False Discuss
- 3. The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
Options- A. True
- B. False Discuss
- 4. SQL is a programming language.
Options- A. True
- B. False Discuss
- 5. Indexes may be created or dropped at any time.
Options- A. True
- B. False Discuss
- 6. When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
Options- A. True
- B. False Discuss
- 7. One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data.
Options- A. True
- B. False Discuss
- 8. Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF.
Options- A. True
- B. False Discuss
- 9. We use the SQL construct COUNT(*) to count the number of rows in a table.
Options- A. True
- B. False Discuss
- 10. One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
Options- A. True
- B. False Discuss
Database Design Using Normalization problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.