Database - Data Models into Database Designs

Database - Data Models into Database Designs
1. Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
  • A domain constraint
  • A range constraint
  • An intrarelation constraint
  • An interrelation constraint
Show Answer
2. In a 1:N relationship, the foreign key is placed in:
  • either table without specifying parent and child tables.
  • the parent table.
  • the child table.
  • either the parent table or the child table.
Show Answer
3. Which of the following column properties specifies whether or not cells in a column must contain a data value?
  • Null status
  • Data type
  • Default value
  • Data constraints
Show Answer
4. A primary key should be defined as:
  • NULL.
  • NOT NULL.
  • Either of the above can be used.
  • None of the above are correct.
Show Answer
5. Which of the following column properties would be used to specify that cells in a column
must contain a monetary value?
  • Null status
  • Data type
  • Default value
  • Data constraints
Show Answer
6. Which of the following situation requires the use of ID-dependent entities?
  • Association relationships only
  • Multivalued attributes only
  • Archetype/instance relationships only
  • All of the above use ID dependent entities
Show Answer
7. A foreign key is:
  • a column containing the primary key of another table.
  • used to define data types.
  • used to define null status.
  • all of the above are above correct.
Show Answer
8. Which of the following columns is(are) are required in a table?
  • A foreign key
  • An alternate key
  • A primary key
  • A surrogate key.
Show Answer
9. In a 1:1 relationship, the foreign key is placed in:
  • either table without specifying parent and child tables.
  • the parent table.
  • the child table.
  • either the parent table or the child table.
Show Answer
10. Which of the following column properties would be used to specify that cells in a column
must be immediately filled with a monetary value of $10,000?
  • Null status
  • Data type
  • Default value
  • Data constraints
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test