Why SELECT * is not preferred in embedded SQL pr

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Why SELECT * is not preferred in embedded SQL programs ?

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

(Continued on next question...)

Other Job Interview Questions

• Describe the elements of the SELECT query syntax?
• What authority is required to create a table?
• How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?
• What authority is required to create a table?
• What are the column name qualifiers?
• Where in a table are added column located ?
• What are correlated subqueries?
• My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. why?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• What RDMS objects are required before you can create a table ?
• More...