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

Tell me what is de-normalization and what are some of the examples of it?

1010

---

Where cross join is used?

949

---

How would you use user_constraints table in DB?

998

---

Explain few examples of stored procedure over triggers?

1024

---

Explain about protocol layer present in SQL server?

1186

---

Write SQL queries on Self Join and Inner Join.

1145

---

Explain how you can deploy an SSRS report?

146

---

Difference between report and query parameter. Why do we need different type of parameter?

941

---

Can sql server be linked with other servers like oracle?

954

---

What is dimension table? : sql server analysis services, ssas

1010

---

How to rebuild master databse?

1071

---

Is sql different from sql server?

1068

---

Explain linked server in sql?

1204

---

What are the disadvantages of using querystrings to send data from one page to another?

990

---

How to convert a numeric expression from one data type to another?

1001

---