Which of the following statements regarding Super Key and Primary Key is…

Concept

A super key is any set of one or more attributes that uniquely identifies every row (tuple) in a relation. A candidate key is a minimal super key (no attribute can be removed without losing uniqueness). The primary key is the ONE candidate key that the database designer chooses to be the row identifier for the table. So the hierarchy is: super keys (broadest) contain candidate keys, and exactly one candidate key is promoted to primary key.

Applying it to the statements

The question asks for the statement that is FALSE. The false statement claims that every super key is selected as the primary key of a table. That cannot be true: a table typically has many super keys, but only one of them is designated as the primary key. Selection happens once, on a single candidate key; the remaining super keys stay just super keys (some are alternate/candidate keys, others carry redundant extra attributes).

Why the others are true

• Every primary key is a super key: the primary key uniquely identifies each row, which is exactly the defining property of a super key, so it is a super key by definition.

• A super key may contain additional attributes not required for unique identification: this is precisely why a super key need not be minimal; remove the redundant attributes and it becomes a candidate key.

• A table can have multiple super keys: any super key plus any extra attributes is still a super key, so the count of super keys can be large.

• A primary key uniquely identifies each record in a table: this is the basic definition of a primary key.

Result

The statement "Every super key is selected as the primary key of a table" is the incorrect one, because only a single chosen candidate key becomes the primary key, not every super key.