Answer Posted / pawan378

above answers are correct.
let me add some thing.

Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.

What are recommended options to be used while using db mirroring? : sql server database administration

1152

---

What are the different acid properties?

1065

---

How to create a new schema in a database?

1145

---

Distinguish between nested subquery and correlated subquery?

1043

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1067

---

Can you please differentiate between a primary key and a unique key?

1006

---

can a table be moved to different filegroup? : Sql server administration

972

---

what are the new features in SSRS?

134

---

can you instantiate a com object by using t-sql? : Sql server database administration

998

---

How to delete multiple rows with one delete statement in ms sql server?

1024

---

What is the bookmark lookup and rid lookup?

997

---

What is partition index in sql server?

1118

---

what is the difference between Delete and Truncate command in SQL

1147

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1943

---

What is a subquery in a select query statement in ms sql server?

1131

---