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

What is DB Development software?

2113

---

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

2704

---

What is a database development?

1013

---

Explain about xml databases?

1112

---

Explain about relational database management systems?

1009

---

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

---

Who are end users in dbms?

1029

---

Explain about the hierarchical model of the database?

1163

---

How can you fix a poorly performing query?

1251

---

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

1052

---

What is dbms and its application?

1050

---

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

4053

---

Write short notes on manual refreshes.

2781

---

Explain about the database management systems.

1023

---

Explain the role of indexing in databases?

1184

---