N5 DDD Validation - Keys - Database Types

What is a calculated field?

• a field that only contains text data

• a static value that does not change.

• a field that stores images or files

• a field that uses a formula based on other fields

Which of the following are types of validation in a database?

• data check

• length check

• presentce check

• range check

Match the following

• checks if a required value is present

• restricted choice

• ensures the length of a value meets specified criteria

• presence check

• validates if a value falls within a specified range

• range check

• limits the selection to predefined options

• length check

A relational database has a single table?

• True

• False

A flat file database has a primary key?

• True

• False

Reatinal databases tables are linked with a foreign key?

• foreign keys are only flat file databases

• primary keys are used to link tables in relational databases

• relational database tables are linked with a foreign key.

• relational databases do not use foreign keys.

Match the following

• links two tables together

• relational database

• ensures sensible data stored

• foreign key

• stores data in multiple related tables

• flat file database

• stores data in a single table

• validation

• a unique identifier for a record

• primary key