Answer Posted / 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.

What is difference between view and materialized view?

888

---

Explain indexing and what are the advantages of it?

962

---

What is 3nf normalization?

924

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

908

---

What is the return type of executeupdate ()?

857

---

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

944

---

What is explicit mode in sql server?

1016

---

What is a filestream?

941

---

In what sequence sql statement is processed?

953

---

What is sql server programming?

977

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1020

---

What is a natural primary key?

951

---

How do database indexes work?

952

---

Can a table be moved to different filegroup?

918

---

How can you know if the row fetched from cursor is still valid in underlying table?

953

---