To support data independence, you should _____ in an SQL SELECT command.
A)use the * (asterisk) wildcard to represent all fields
B)avoid using more than five fields
C)explicitly list all the required fields
D)only list fields from a single table

Question

Quizplus · Accepted Answer

Explicitly listing all the required fields in an SQL SELECT command supports data independence by ensuring that the query only retrieves the necessary data, making it less dependent on the structure of the database. This practice also helps in maintaining the query's functionality even if the database structure changes, as long as the explicitly listed fields remain unchanged.

To Support Data Independence, You Should _____ in an SQL