Answer Posted / chandran.s

Table Name: Example

Name Age
chandran 23
ranjith 24
chandran 23

To delete one of the duplicate records use following query


delete from example where age in(select age from example
group by age having count>1)

What is a unique key constraint?

1032

---

Explain the properties of a relational table?

1027

---

How to provide default values to stored procedure parameters?

1069

---

How to use clusters?

961

---

How can you list all the columns in a database?

934

---

What is ssl in sql server?

1082

---

Can you always create a cache of a report?

174

---

How to convert a numeric expression from one data type to another?

1023

---

What is primary key index?

985

---

How is a full-text index updated?

959

---

Which sql server table is used to hold the stored procedure scripts?

1070

---

What does indexation mean?

982

---

What are subqueries in sql server? Explain its properties.

1025

---

What encryption security is available in sql azure?

101

---

Can you explain the disadvantages/limitation of the cursor?

992

---