What is the appropriate number of test cases that you can
write on a database?

Answer Posted / subhash

In order to create database test cases you can have two
different aproaches performing both of them is advisable if
time permits.1) Testing each and every Trigger Cursor SP
used in the application.2) Testing the application w.r.t
functionality of the application like for example:Let's say
there are two web sites type 'ABC' records should be
displayed only in ABC websiteand type 'XYZ' records should
be displayed only in XYZ website. You can insert a new type
'ABC' record and see if it is displayed only on ABC website
and not on XYZ website.Both the websites are controlled by
the same company it just wants type I customers to have
acces to type I website and Type II customers have access to
type II website. This is a completely imaginary example
there can be any type of application or service
functionality which can be broken down in totest cases in
turn.Hope this from now on for anyone will be of good help.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of sql azure?

116


How to generate create view script on an existing view?

562


How to retrieve error messages using mssql_get_last_message()?

533


Can a table have 2 primary keys?

506


What is the current pricing model of SQL Azure?

90






How to make conditional sum in ssrs?

132


What is the importance of a recovery model?

611


What does sql server mean?

538


What are the types of joins in sql?

563


What are user defined functions in ms sql server?

510


How to check parameter value in stored procedure sql server?

464


Please differentiate between a local and a global temporary table?

570


Explain the concepts and capabilities of sql server?

545


Can you leave a union at any time?

541


Does sql server use t sql?

527