1.

What Are The Approach For Code Review?

Answer»

The following points to be considered when one is doing code review:

  1. Orders of Sections and Subsections is as per standards.
  2. Are proper domains USED for the variables
  3. Codes are used for message/questions (not hard coded)
  4. Select statements appear only in FUNCTIONS
  5. Whenever only one record is needed, as set with used in select clause
  6. Repeating code put in a function
  7. Wildcards (eg. tccom001.*) not used in select statement
  8. Refers to used wherever REFERENCES available
  9. Index_n used wherever possible
  10. Unwanted joins removed from the main select

The following points to be considered when one is doing code review:


Discussion

No Comment Found

Related InterviewSolutions