Answer / guest

cant say depends

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.

Explain primary key in sql server?

0 Answers  

---

How to rebuild all indexes on a single table?

0 Answers  

---

How to create and drop temp table in sql server?

0 Answers  

---

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

---

What are “lost updates”?

0 Answers  

---

---

Where is my database stored on the hard disk in ms sql server?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is a join and their types?

2 Answers   Challenger Financial,

---

What is the order by used for?

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

What is difference statement and preparedstatement?

0 Answers  

---