Answer Posted / kannan

CREATE TABLE IF NOT EXISTS `emp` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) collate latin1_general_ci NOT NULL,
`dept_id` int(11) NOT NULL,
`mgr_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
)


SELECT e2.name Employee_name, e1.name Manager_name
FROM emp e1, emp e2
WHERE e2.mgr_id = e1.id

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2110

---

Explain about query and reporting.

2033

---

What is database design and development?

955

---

State the acid rules?

1075

---

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

965

---

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

2092

---

Explain about network model?

952

---

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

952

---

What are the main phases of database development?

923

---

What is a database development?

912

---

What are the three types of database design?

965

---

What is dbms explain in brief?

962

---

In which database can extended stored procedures be added?

860

---

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

960

---

How long can an error message be in raiseerror function?

952

---