What is the appropriate number of test cases that you can
write on a database?
Answers were Sorted based on User's Feedback
Answer / 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 |
How can you swap values between two rows in a table using single- SQL statement?
1 Answers Tavant Technologies, Virtusa,
What is GUID in sql server?
What is update_statistics command?
How you would rewrite the sql query to return the customerid sorted numerically?
What does null mean?
How can I check that whether automatic statistic update is enabled or not?
How to find the login name linked to a given user name?
How do I find the query plan in sql server?
What is the user of Primary key?
What are the main control-of-flow T-SQL constructs?
How to make a column nullable?
Why use view instead of a table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)