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 loop through returning rows?

0 Answers  

Explain various data region available in ssrs with their use?

0 Answers  

Explain relational data?

0 Answers  

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

what is Archive old data?

1 Answers  

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

What is BLOCK statements in SQL?

0 Answers   HCL,

Define tool Manage Statistics in SQL Server 2000 query ?

0 Answers   NA,

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

Tell me can we use custom code in ssrs?

0 Answers  

How to perform backup for certificates in sql server? : sql server security

0 Answers  

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories