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

Answers were Sorted based on User's Feedback



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

Answer / guest

cant say depends

Is This Answer Correct ?    6 Yes 0 No

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

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

Post New Answer

More SQL Server Interview Questions

What is database isolation in sql server? : sql server database administration

0 Answers  


i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,


How would you choose between a clustered and a non-clustered index?

0 Answers  


How to create an index on a view?

0 Answers  


What is standby servers? Explain types of standby servers.

0 Answers  






How you can get a list of all the table constraints in a database?

0 Answers  


How to use “drop” keyword in sql server and give an example?

0 Answers  


Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,


How to retrieve field values using mssql_result()?

0 Answers  


What is ems sql management studio? : sql server management studio

0 Answers  


How can you insert null values in a column while inserting the data?

0 Answers  


What is the maximum size per database for sql server express?

0 Answers  


Categories