Get Started
1234

Q: Why SELECT * is not preferred in embedded SQL programs?

  • Show Answer
  • Workspace

Answer :
Explanation :

- If the table structure is changed ( a field is added ), the program will have to be modified. - Program might retrieve the columns which it might not use, leading on I/O over head. - The chance of an index only scan is lost.

The Most Comprehensive Exam Preparation Platform

Get the Examsbook Prep App Today