Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / shalini

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

How to handle errors in Stored Procedures.

2 Answers   Accenture,

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

What happens if null values are involved in datetime operations?

0 Answers  

What is a data source file?

0 Answers  

Explain powershell included in sql server 2008?

0 Answers  

How much does sql server 2016 cost?

0 Answers  

How many full-text indexes can a table have?

0 Answers  

Explain about unique identifier data type in sql server?

0 Answers  

What are the purpose of Normalisation?

0 Answers   HCL,

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

0 Answers   MCN Solutions,

How sql server executes a statement with nested subqueries?

0 Answers  

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories