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 rollup operator?

1086

---

What are the key features of dbms?

1004

---

How to customize error conditions.

2158

---

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

2176

---

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

1130

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

2065

---

How to combine two function together?

2140

---

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

2503

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2033

---

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?

1003

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2229

---

Where is dbms used?

1090

---

What is normalization? Explain different levels of normalization?

63165

---

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

984

---

Explain about the relational database?

1087

---