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
Why use identity in sql server?
What is SQL Azure Fabric?
Do you have any idea about the tcl commands?
Write the SQL query to drop, truncate and delete table.
What number aggregate functions are accessible there in sql?
What is a system database and what is a user database?
What is a trace frag?
Can we call future method from queueable?
What is the difference between sdf and mdf?
What are the methods used to protect against sql injection attack?
Mention the differences between local and global temporary tables.
What is store procedure? How do they work?
Do you know the cursor types?
Define indexes?
How to select all columns of all rows from a table with a select statement in ms sql server?