Answer Posted / rohit

MySQL does not support the use of CHECK constraint

What is transaction server distributed transaction?

978

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

885

---

What are the different type of replication in sql server?

935

---

What is the exact numeric data type in sql?

962

---

How to use subqueries with the exists operators in ms sql server?

1060

---

How to stop a loop early with break statements in ms sql server?

976

---

How to set a database state to offline in ms sql server?

968

---

What does indexation mean?

916

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

893

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

974

---

Explain the difference between cross join and full outer join?

925

---

What is sql service broker?

931

---

What is difference between delete and truncate commands?

997

---

What function does a database engine serve in the sql server?

988

---

Write an sql query for deleting duplicate rows?

955

---