Discussion
Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
- Question
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Options- A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
- B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- C. Three rows have the values Brown, NULL, and Blue in the same column.
- D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
- Correct Answer
- Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
- 1. When two transactions are being processed against the database at the same time they are termed concurrent transactions.
Options- A. True
- B. False Discuss
- 2. The XSLT processor copies the elements of the stylesheet until it finds a command in the format:
Options- A. SELECT ... FROM ... WHERE.
- B. {item, action}.
- C. {for-each select}.
- D. <HTML>...<\HTML>. Discuss
- 3. Functional decomposition is the process of breaking down the functions of an organization into greater levels of detail.
Options- A. True
- B. False Discuss
- 4. Whose role is it to determine the requirements and design for a database?
Options- A. Database analysts
- B. Database administrators
- C. Both A and B.
- D. Neither A or B. Discuss
- 5. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.
Options- A. True
- B. False Discuss
- 6. SQL views can be used to hide:
Options- A. columns and rows only.
- B. complicated SQL syntax only.
- C. both of the above can be hidden by an SQL view.
- D. None of the above is correct. Discuss
- 7. Some advantages of partitioning include: efficiency, security, and load balancing.
Options- A. True
- B. False Discuss
- 8. Websites without a database attached to them have which of the following characteristics?
Options- A. The ability to generate data via SQL.
- B. The inability to use a browser to display Web pages.
- C. Static information using HTML or JavaScript.
- D. The need to use TCP/IP as the network protocol. Discuss
- 9. The reserved word enum is used for which of the following?
Options- A. To define a range for an attribute.
- B. To define a range for a class.
- C. To define a range for a relationship.
- D. All of the above. Discuss
- 10. The term Complete for a UML has the same meaning as which of the following for an EER diagram?
Options- A. Overlapping rule
- B. Disjoint rule
- C. Total specialization rule
- D. Partial specialization rule Discuss
More questions
Correct Answer: True
Correct Answer: {item, action}.
Correct Answer: True
Correct Answer: Database analysts
Correct Answer: False
Correct Answer: both of the above can be hidden by an SQL view.
Correct Answer: True
Correct Answer: Static information using HTML or JavaScript.
Correct Answer: To define a range for an attribute.
Correct Answer: Total specialization rule
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.