Answer Posted / raju

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.

What are the three types of database design?

1081

---

State the acid rules?

1178

---

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

2583

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

1016

---

What are data modelling techniques?

1023

---

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

1110

---

Explain about the database management systems.

1023

---

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?

1111

---

How can you fix a poorly performing query?

1253

---

Write short notes on manual refreshes.

2782

---

What is normalization? Explain different levels of normalization?

63395

---

Explain about xml databases?

1113

---

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

---

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

1170

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2467

---