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)

Mention the differences between having and where clause.

999

---

define and explain the differences between clustered and non-clustered indexes.

1120

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

929

---

How do you identify a foreign key?

972

---

What are the types of dml?

931

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

916

---

What are the advantages dts has over bcp?

941

---

What is 2nf normalization?

970

---

Explain different types of locks in sql server.

1013

---

How to list all login names on the ms sql server?

1080

---

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

884

---

What are number line correlation administrators will use while working with a subquery?

1099

---

Write down the syntax and an example for create, rename and delete index?

925

---

How do I find the query plan in sql server?

909

---

New concepts of sql server 2005 use in your project.

2305

---