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

Show Practically Sql Server Views are updatable?

785


What are user defined functions in ms sql server?

683


How to reaname table name without using sp_Rename in sql server..?

727


How to sort the query output with order by clauses in ms sql server?

815


How you can add messages to the nt event log from within a stored procedure?

776






Name and describe few console utilities for ssrs?

264


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

175


Explain isolation levels that sql server supports?

763


Why we use functions in sql server?

719


What is meant by indexing files?

778


Can you insert NULL in unique column?

830


How to create a new table in a given schema?

842


Why use view instead of a table?

710


what exactly sql injuction.how to overcome.....

2245


What is instead of dml trigger?

774