Physical Design   «Prev  Next»

Database Business Objects - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following statements offers the best definition of a business object?
Please select the best answer.
  A. A business object is a table in a database.
  B. A business object is a view in a database.
  C. A business object is a person, place, or thing to be represented in a database.
  D. A business object is a guideline governing table data.

2. How do you represent business rules in a database, when a rule is a good fit for database-level enforcement?
Please select the best answer.
  A. With tables
  B. With columns
  C. With business objects
  D. With constraints

3. Which of the following are common mistakes associated with business objects?
Please select all the correct answers.
  A. Representing only one business object in a table
  B. Representing more than one business object in a table
  C. Representing too many attributes of an object in a table
  D. Representing too many objects in the database

4. A designer stores a distributor's name and address directly inside the CD table instead of creating a separate Distributor table. That same distributor supplies 100 different CDs, and the distributor later moves to a new address. What is this scenario a classic example of?
Please select the best answer.
  A. An insertion anomaly
  B. An update anomaly
  C. A deletion anomaly
  D. A referential integrity violation

5. Per this module, a business rule is a good candidate for enforcement as a database constraint if it meets which of the following conditions?
Please select all the correct answers.
  A. It helps preserve data integrity.
  B. It does not undermine the company's potential growth in a way that would require a schema revision.
  C. It was stated by a single employee.
  D. It only applies to numeric data.