1.

Mention A Credible Reason Why Select* Is Never Given Preference In An Sql Program That Has Been Embedded?

Answer»

There are primarily three reasons why SELECT* is never given preference in an EMBEDDED SQL program. These are:–

  • In case if there is an alteration in the structure of the table, then the program has to undergo a modification process.
  • All columns will be retrieved by the program INCLUDING those columns , which MIGHT not be used.
  • In case if the user WISHES to scan the INDEX, then that will not be possible.

There are primarily three reasons why SELECT* is never given preference in an embedded SQL program. These are:–


Discussion

No Comment Found

Related InterviewSolutions