Answer Posted / divya

candidate key: is a column in a table which has thhe ability
to become a primary key.

alternate key:any of the candidate key that is not part of
the primary key.

What are the three basic rules which are to be followed for the relational model of the database?

927

---

Explain the role of indexing in databases?

1063

---

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

1027

---

Explain the rollup operator?

989

---

Who are naive users?

947

---

Explain the cube operator?

930

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2096

---

How would you design a database for an online site, which would average a million hits a day?

942

---

What is database design and development?

950

---

How to use timestamp datatypes

1963

---

How can you fix a poorly performing query?

1100

---

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

997

---

Write the fastest query to find out how many rows exist in a table?

1050

---

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

2440

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3940

---