1 / 5
A good schema should ___ the data model accurately.
-
-
-
-
To represent a model means to express it faithfully. Represent is the precise verb; the distractors are casual.
2 / 5
We ___ a primary key to uniquely identify each row.
-
-
-
-
To define a key means to declare it in the schema. Define is the natural collocation; the others are wrong.
3 / 5
To avoid redundancy, we ___ the schema into related tables.
-
-
-
-
To normalize a schema means to reduce duplication. Normalize is the exact term; the distractors do not collocate.
4 / 5
We ___ a foreign key to link orders to customers.
-
-
-
-
To add a foreign key means to create a referential link. Add is the standard verb; the others are informal.
5 / 5
Schema changes must ___ backward compatibility for clients.
-
-
-
-
To preserve compatibility means to keep it intact. Preserve is the idiomatic collocation; the distractors are wrong.