Data Models into Database Designs

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].



img not found
img

For help Students Orientation
Mcqs Questions

One stop destination for examination, preparation, recruitment, and more. Specially designed online test to solve all your preparation worries. Go wherever you want to and practice whenever you want, using the online test platform.