Answer Posted / subhash vandewar

Normalizatiin is the scientific method of breaking down
complex table sturcture into simple table structure by
using certain rules.using this method you can reduce
redundency in a table and eliminate the problem of
inconsisteny and disk space usage.

First Normal Form(1NF):
a table is said to be in first normal form when each
cell of the table prcisely contain one value.

Second Normal Form (2NF):
a table is said to be in second normal form when it is
in 1NF and every attribute in the row in functionaly
dependent upon whole key and not just a part of key.
Third Normal Form (3NF):
a table is said to be in second normal form when it is 2NF
and every non key attribute is functionaly dependent only
on the primary key.

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2374

---

Can an extended stored procedure be called from inside a user-defined function?

1009

---

How to use online Backups?

2156

---

What are the constraints on severity level in raiseerror?

938

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

951

---

Write short notes on manual refreshes.

2685

---

fact table and dimension table containg one to many relationship or many to one relastionship

2448

---

I have a few records all are same structures data, I want to store data in multiple targets how

2594

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

904

---

What are the 18 schemas?

1055

---

Explain the cube operator?

940

---

Explain about query and reporting.

2032

---

Explain about a primary key?

934

---

Explain about network model?

952

---

Which data type cannot be used as a parameter in a udf?

915

---