Candidate keys that are not selected or designated as the primary key of a table are known as what?
A. Composite Keys
B. Alternate Keys
C. Foreign Keys
D. Super Keys
Answer: Option B
Solution (By JKSSB Mock Tests)
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.
Explanation:
A Common Table Expression (CTE) provides a temporary named result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement.
No comments yet. Be the first to start the discussion!