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?
Select an option to see the answer and solution.
Database · all questionsData Models into Database Designs
Data Models into Database Designs
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
1/2
Page
Pick an option on a question to see the right answer and solution.
In a 1:N relationship, the foreign key is placed in:
Select an option to see the answer and solution.
Which of the following column properties specifies whether or not cells in a column must contain a data value?
Select an option to see the answer and solution.
A primary key should be defined as:
Select an option to see the answer and solution.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Select an option to see the answer and solution.
Which of the following situation requires the use of ID-dependent entities?
Select an option to see the answer and solution.
A foreign key is:
Select an option to see the answer and solution.
Which of the following columns is(are) are required in a table?
Select an option to see the answer and solution.
In a 1:1 relationship, the foreign key is placed in:
Select an option to see the answer and solution.
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?
Select an option to see the answer and solution.
The identifier of an entity will become the ________ of the new table.
Select an option to see the answer and solution.
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Select an option to see the answer and solution.
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Select an option to see the answer and solution.
Which is not true about surrogate keys?
Select an option to see the answer and solution.
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Select an option to see the answer and solution.
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Select an option to see the answer and solution.
Each entity is represented as a(n):
Select an option to see the answer and solution.
For every relationship, how many possible sets of minimum cardinalities are there?
Select an option to see the answer and solution.
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Select an option to see the answer and solution.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Select an option to see the answer and solution.