Answer Posted / reddi

a view is a database object, that contains no data of its own.
it's used for to hide some confidential information.

What are ddl triggers and types of ddl trigger?

1092

---

How do we know if any query is retrieving a large amount of data or very little data?

1032

---

Write a query to find 5th highest amount paid from the customer table.

985

---

What is normalization according to you and explain its different levels?

993

---

What is sql server profiler?

1060

---

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., }

2410

---

Can you explain different types of locks in sql server?

992

---

Explain the properties of sub-query in sql server?

1067

---

What is a view and what are its advantages?

1167

---

What is partition, how will you implement it? : sql server analysis services, ssas

1097

---

What is the tcp/ip port on which sql server runs?

1235

---

Can you explain the disadvantages/limitation of the cursor?

1051

---

Is foreign key a primary key?

1174

---

Define inner join? Explain with an example?

1044

---

Differentiate between a local and a global temporary table?

996

---