Oracle
1Z0-882 · Question #48
Which there statements describe valid reasons why queries that use "SELECT" construct are discouraged?
The correct answer is A. SELECT * may cause more data than you need to be read from disk if your application needs B. SELECT * causes more data than you need to be sent via the client/server protocol if your D. SELECT *causes your application to depend on the columns present when you wrote it , so your. See the full explanation below for the reasoning.
Question
Which there statements describe valid reasons why queries that use "SELECT" construct are discouraged?
Options
- ASELECT * may cause more data than you need to be read from disk if your application needs
- BSELECT * causes more data than you need to be sent via the client/server protocol if your
- CSELECT * prevents the use of indexes, so a full table scan for every query.
- DSELECT *causes your application to depend on the columns present when you wrote it , so your
- ESELECT * causes the statements to return all rows from the table.
How the community answered
(25 responses)- A76% (19)
- C16% (4)
- E8% (2)
Community Discussion
No community discussion yet for this question.