Answer Posted / deepak v

candidate key:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be a primary key.

alternate key:-In the candidate key the key which is not
primary key is the alternate key.

composite key:- A key formed bythe combination of 2 or more
columns is the composite key.

Explain the role of indexing in databases?

1064

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2805

---

What is DB Development software?

1997

---

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

945

---

explain detail about ftp in datastage?

2180

---

Explain about relational operator join?

975

---

In which database can extended stored procedures be added?

853

---

Write short notes on manual refreshes.

2676

---

Explain the cube operator?

931

---

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?

2367

---

Explain about network model?

941

---

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?

997

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

945

---

Explain the process of the user request and data generating?

1027

---

Which four data types cannot be used as a return type from a user-defined function?

959

---