Answer Posted / ghous

in rdbms we have relations of tables say primary
key ,foreign keys relation ,,that involves refrential
integrity and normalication like concepts
where as
dbms is just collection of tables that dont have relations
and dependencies

Explain isolation levels that sql server supports?

1023

---

Can you pass expressions to function parameters?

1085

---

Difference between LEN() and DATALENGTH() in sql server ?

1087

---

Do you know sql server 2008 backup compression?

950

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

938

---

Why Master database is required?

1115

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1182

---

Explain the different types of backups available in sql server? : sql server database administration

902

---

What is the report model project?

141

---

What is reference section?

985

---

What is a join in sql?

1069

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1085

---

How to perform backup for certificates in sql server? : sql server security

1071

---

What are the different types of normalization?

1139

---

Tell me what is normalization? Explain different forms of normalization?

1018

---