Which there statements describe valid reasons why queries that use “SELECT” construct
are discouraged?
A.
SELECT * may cause more data than you need to be read from disk if your application
needs only some columns.
B.
SELECT * causes more data than you need to be sent via the client/server protocol if your
application needs only some columns.
C.
SELECT * prevents the use of indexes, so a full table scan for every query.
D.
SELECT *causes your application to depend on the columns present when you wrote it ,
so your application could break if the table structure changes.
E.
SELECT * causes the statements to return all rows from the table.
A,B,D
A,B,D
ABD