Oracle
1Z0-882 · Question #48
1Z0-882 Question #48: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #48. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.