Which there statements describe valid reasons why queries that use “SELECT” construct are discouraged?

Which there statements describe valid reasons why queries that use “SELECT” construct
are discouraged?

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *