Answer Posted / subbu

suppose if we write a trigger on the table on insert or
delete or update

on insertion of record into that table,
inserted table will create automatically by database,

on deletion of record from that table,
deleted table will create automatically by database,

This two tables inserted and deleted are called magic
tables.

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

991

---

Explain Geography datatype in SQL Server

1129

---

What to check if a User database is locked?

1071

---

What is self contained sub query?

1057

---

What the class forname () does?

1063

---

What is the difference between a clustered index and a non-clustered index?

991

---

What are the different authentication modes in sql server?

1118

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2344

---

How many columns can we include on clustered index ?

990

---

What are xml indexes?

952

---

How to compare the top two records using sql?

1342

---

What is shared lock?

901

---

How to see the event list of an existing trigger using sys.trigger_events?

1073

---

Write a program to fetch first 10 records from a file?

1011

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

950

---