Question 280
A data architect recommends this approach: Use ORDER BY created_at DESC in the SELECT query. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for ORDER BY. The result is sorted from newest to oldest timestamps.
Incorrect Answers
The other situation is better matched to Define a primary key on the employee identifier column. Each employee row gains a unique non-null identifier for referencing records.
The other situation is better matched to Create an enrollment junction table containing student and course foreign keys. A many-to-many relationship is modeled with linking rows.
The other situation is better matched to Execute CREATE TABLE with the required column definitions and constraints. A schema object exists to store rows subject to specified column types.