An ideal primary key is short, numeric and seldom changing. – McqOptions

MCQOPTIONS

1.	An ideal primary key is short, numeric and seldom changing.
A.	1
B.
Answer» B.

Discussion

No Comment Found

Related MCQs

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Intersection tables are ID-dependent on both their parent tables.
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Surrogate keys have much meaning for users.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
An intersection table is required to represent M:N relationships.
When the parent entity is required, a new parent row can always be inserted.
For every relationship, there are six possible referential integrity actions.
All primary keys are required.
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.