Discussion
Home ‣ Database ‣ The Relational Model and Normalization See What Others Are Saying!
- Question
If attribute A determines both attributes B and C, then it is also true that:
Options- A. A ? B.
- B. B ? A.
- C. C ? A.
- D. (B,C) ? A.
- Correct Answer
- A ? B.
- 1. An advantage of the database approach is the creation of maximum data redundancy.
Options- A. True
- B. False Discuss
- 2. When mapping a regular entity into a relation which of the following is true?
Options- A. One relation is created.
- B. Two relations are created.
- C. Three relations are created.
- D. Four relations are created. Discuss
- 3. A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Options- A. True
- B. False Discuss
- 4. Fact tables are which of the following?
Options- A. Completely denoralized
- B. Partially denoralized
- C. Completely normalized
- D. Partially normalized Discuss
- 5. What SQL structure is used to limit column values of a table?
Options- A. The LIMIT constraint
- B. The CHECK constraint
- C. The VALUE constraint
- D. None of the above is correct. Discuss
- 6. Which of the following is a way to create and modify tables using SQL Server?
Options- A. Write SQL code using either CREATE or ALTER SQL statements only.
- B. Use the graphical facilities of SQL Server Enterprise Manager only.
- C. Both of the two methods above will work.
- D. Neither of the two methods above will work. Discuss
- 7. For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Options- A. read-only
- B. updateable
- C. either a read-only or an updateable
- D. None of the above is correct. Discuss
- 8. JDBC Type 1 drivers are JDBC-ODBC bridge drivers.
Options- A. True
- B. False Discuss
- 9. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
Options- A. True
- B. False Discuss
- 10. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Options- A. a particular column in a particular underlying table.
- B. a particular column in a particular row.
- C. a particular row in a particular underlying table.
- D. None of the above is correct. Discuss
More questions
Correct Answer: False
Correct Answer: One relation is created.
Correct Answer: False
Correct Answer: Completely normalized
Correct Answer: The CHECK constraint
Correct Answer: Both of the two methods above will work.
Correct Answer: read-only
Correct Answer: True
Correct Answer: False
Correct Answer: a particular row in a particular underlying table.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.