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 the maximum length of an extended property?

921

---

What is DB Development software?

1997

---

Explain about xml databases?

1000

---

Explain about the relational database?

992

---

What is dbms explain in brief?

953

---

Explain about post-relational databases?

950

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2153

---

What is dbms and its application?

939

---

Explain the rollup operator?

990

---

How can I detect whether a given connection is blocked?

979

---

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

947

---

State the acid rules?

1067

---

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?

2359

---

Who are end users in dbms?

914

---

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

998

---