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.

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

1051

---

Where is dbms used?

1009

---

Explain about the hierarchical model of the database?

1054

---

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

1966

---

Explain about the database management systems.

912

---

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

2075

---

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

945

---

What are the constraints on severity level in raiseerror?

930

---

State the acid rules?

1067

---

Why does this query return 0?

965

---

What is the database development process?

1146

---

What is database design and development?

950

---

In which table collections errors are stored.

2336

---

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

---

What is DB Development software?

1998

---