Modeling Data in the Organization problems
- 1. A binary relationship cannot be which of the following?
Options- A. One-to-One
- B. One-to-Many
- C. Many-to-Many
- D. Zero-to-Zero Discuss
Correct Answer: Zero-to-Zero
- 2. A ternary relationship involves how many entities?
Options- A. 3 or less
- B. 3
- C. More than 3
- D. 3 or more Discuss
Correct Answer: 3
- 3. A good identifier is which of the following?
Options- A. One that can change over time
- B. Can be null
- C. One that is unique
- D. Be intelligent Discuss
Correct Answer: One that is unique
- 4. An entity name should be which of the following?
Options- A. A singular noun
- B. Specific to the organization
- C. Concise
- D. All of the above. Discuss
Correct Answer: All of the above.
- 5. A good business rule is which of the following?
Options- A. Declarative
- B. Imprecise
- C. Redundant
- D. Compound Discuss
Correct Answer: Declarative
- 6. When the minimum and maximum number of instances of an entity is one, you know which of the following?
Options- A. Mandatory one
- B. Optional one
- C. Mandatory many
- D. Cannot tell Discuss
Correct Answer: Mandatory one
- 7. An oval represents which of the following in an ERD?
Options- A. Attribute
- B. Entity
- C. Optional One
- D. Relationship Discuss
Correct Answer: Attribute
- 8. A composite attribute is which of the following?
Options- A. An attribute that can be broken into components
- B. An attribute that cannot be broken into components
- C. Multiple attributes
- D. An identifier Discuss
Correct Answer: An attribute that can be broken into components
- 9. An attribute name should be which of the following?
Options- A. Singular verb or verb phrase
- B. Follow a standard format
- C. Use a alias
- D. All of the above. Discuss
Correct Answer: Follow a standard format
- 10. When the minimum number of instances of an entity is one, you know which of the following?
Options- A. Mandatory one
- B. Optional one
- C. Mandatory many
- D. Cannot tell Discuss
Correct Answer: Cannot tell
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.