Question

question 20 (2 points) saved
listen
which of the following is not true about surrogate keys?

1. they are identifiers that are supplied by the system, not the users.
2. they have no meaning to the users.
3. they are nonunique within a table.
4. they are nonunique within a table.

Explanation:

Surrogate keys are unique identifiers generated by the system (not users) and have no business meaning to users. A key (including surrogate key) must be unique within a table. So the statement "They are nonunique within a table" is false. Options 3 and 4 (assuming a typo, likely same as 3) are incorrect, but as the selected option in the image is 3, we confirm that option 3 (and 4 if duplicate) is the one not true.

Answer:

1. They are nonunique within a table, 4) They are nonunique within a table (Note: Likely a typo in options 3 and 4, but the incorrect statement is that surrogate keys are nonunique within a table, so the answer is the option(s) stating they are nonunique within a table, e.g., 3) They are nonunique within a table)