Which of the following ORM snippets would return the ID, state, and country of all customers with the newest customers appearing first?

Given the following customer table:

Which of the following ORM snippets would return the ID, state, and country of all customers with the newest customers appearing first?

A)

B)

C)

D)

A . Option A
B . Option B
C . Option C
D . Option D

View Answer

Answer: C

Explanation:

The ORM snippet that would return the ID, state, and country of all customers with the newest customers appearing first is option C. This snippet uses the select method to specify the columns to be returned, the order method to sort the results by ID in descending order, and the all method to fetch all the records. The other options either have syntax errors, use incorrect methods, or do not sort the results correctly.

Reference: CompTIA DataSys+ Course Outline, Domain 1.0 Database Fundamentals, Objective 1.2 Given a scenario, execute database tasks using scripting and programming languages.