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.

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

2069

---

Explain about relational operator join?

625

---

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

1662

---

What is the physical representation for a many-to-many relationship?

582

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3450

---

---

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?

532

---

State the acid rules?

692

---

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

2083

---

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

618

---

What are data modelling techniques?

532

---

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?

582

---

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).

1801

---

What is a database development?

528

---

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?

2000

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

556

---