Question { NBP, 36372 }

What is denormalization and when would you go for it?

Answer

Industrial experience---->

Denormalization or Normalization both we use on databse so
that any one can filter as well as retrive the data from
the tabel easily.
Denormalization - As the name suggest it is a reverse
process of normalization, means we fill some redundant data
in table so that user can retrive easily.
But actualy we use the major functionality of normalization
of higher normal form(BCNF, 4TH NF ,5TH NF, DKNF) in lower
normal form (1st and 2nd) because higher normal forms are
so costly to use, thats why we use denormalization to
reduce the cost of normalization.

Question { Satyam, 9800 }

What is the difference between test case result and a bug?

Answer

Test case are creat by tester on the basis of available
requirements for particular system/ component . test case
is set cases of which define the set of steps on different
condition, environment what we fallows to test the each
componet or technology of the system .
when we have writen test cases , then we execute them to
validate those test case ,but when we get unexpected result
on execution then we find bug and to fix that bug we have
to sent all the details of that bug to developer so that
developer can easily understand and fix. this document is
called bug report.