Data Models into Database Designs - Technical MCQs

Q1:

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?

A Null status

B Data type

C Default value

D Data constraints

ANS:D - Data constraints

Data constraints are limitations on data values:

Domain constraint - Column values must be in a given set of specific values.

Range constraint - Column values must be within a given range of values.

Intrarelation constraint - Column values are limited by comparison to values in other columns in the same table.

Interrelation constraint - Column values are limited by comparison to values in other columns in other tables [Referential integrity constraints on foreign keys].