Answer Posted / shreyas joshi

Candidate key- A candidate key is defined as an attribute or
set(combination) of attributes that no 2 tuples(rows) in a
relation hold duplicate values of it.or we can say that a
candidate key is a kind of superkey, if whose subset taken
than it cannot be said as a superkey..in otherwords consider
a customer table with attributes(cust_id,cust_name,cust_street).
than candidate key is (cust_name,cust_street)(combination)
Now this is sufficient to uniquely identify an entity in a
table.But if its subset taken i.e alone cust_name or
cust_street, they individually cannot identify uniquely a
tuple or entity..IN short a candidate key is a superkey with
no super key as it subsets.

Explain about xml databases?

1113

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1071

---

Explain about normal forms?

1106

---

Explain about the relational database?

1128

---

Explain about the database management systems.

1023

---

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

1169

---

What are the 18 schemas?

1185

---

How to read and create .LDC data files which are used by linguatic dictionary.

2583

---

How long can an error message be in raiseerror function?

1044

---

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

2546

---

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

1063

---

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

1110

---

What are the main phases of database development?

1027

---

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

2082

---

What is dbms and its application?

1051

---