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.

How to replace not in with not exist?

2079

---

How to customize error conditions.

2140

---

What is dbms and its application?

999

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

994

---

How you can make a parameterized view?

1007

---

Who are end users in dbms?

978

---

What is an application role and explain a scenario when you would use one?

1004

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2201

---

Explain about the hierarchical model of the database?

1109

---

How long can an error message be in raiseerror function?

999

---

Explain the cube operator?

997

---

In which database can extended stored procedures be added?

898

---

State the acid rules?

1127

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1059

---

How can you log an error to the server event log from a stored procedure?

1099

---