Answer Posted / jeff

A candidate key is able to identify a unique tuple in a
relation through an attribute or attribute set.

A foreign key makes sure that a tuple in a relation does
not match a tuple in another relation which does not exist

How to replace not in with not exist?

2177

---

State the acid rules?

1181

---

Explain about the storage and physical database design?

969

---

I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

2902

---

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?

1112

---

What are data modelling techniques?

1026

---

Explain about the hierarchical model of the database?

1167

---

What is an application role and explain a scenario when you would use one?

1057

---

I have a few records all are same structures data, I want to store data in multiple targets how

2708

---

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?

2470

---

Who are naive users?

1048

---

What is dbms and its application?

1055

---

How you can make a parameterized view?

1070

---

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

2185

---

What is DB Development software?

2118

---