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)

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1049

---

How will you go about resolving deadlocks?

1033

---

How to set database to be read_only in ms sql server?

1052

---

What is it’s similarity with sql server?

160

---

How to create user defined functions with parameters?

1296

---

What are three major types of constraints?

1174

---

Do you know what is user defined datatypes and when you should go for them?

1007

---

Explain the phases a transaction has to undergo?

1111

---

Explain about unique identifier data type in sql server?

976

---

What is the purpose of grouping data in a report?

1013

---

Difference between primary key and clustered index?

1061

---

Can a database be shrunk with users active?

1194

---

Explain the collation?

1146

---

What is snapshot parameter in ssrs?

155

---

How to create nested stored procedure?

1071

---