Answer Posted / s. raban

see my answers

What is the sql case statement used for?

1111

---

What is difference between rollback immediate and with no_wait during alter database?

1100

---

Can foreign key be duplicate?

1071

---

Why olap is used?

985

---

Explain transaction server auto commit?

1048

---

wat wil hapn if we give the both read and deny read permission to user?

2111

---

How to disconnect from a sql server using mssql_close()?

1120

---

What is normalization and its types?

1044

---

How to convert character strings into numeric values?

1111

---

how many clustered indexes can be created on a table? : Sql server database administration

1164

---

How to manipulate data from one table to another table ?

979

---

How to include text values in sql statements?

1051

---

What is acid properties?

1110

---

What is store procedure? When do you use?

945

---

What is etl - extraction, transformation, and loading?

926

---