Answer Posted / sushant more (sybase dba)

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)

GO

INSERT INTO EMPLOYEE VALUES(101,'Mary',102)

INSERT INTO EMPLOYEE VALUES(102,'Ravi',NULL)

INSERT INTO EMPLOYEE VALUES(103,'Raj',102)

INSERT INTO EMPLOYEE VALUES(104,'Pete',103)

INSERT INTO EMPLOYEE VALUES(105,'Prasad',103)

INSERT INTO EMPLOYEE VALUES(106,'Ben',103)


select e1.NAME from EMPLOYEE e1,EMPLOYEE e2
where e1.EMPLOYEE_ID = e2.MANAGER_ID

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

1080

---

Explain about a primary key?

988

---

Write short notes on manual refreshes.

2736

---

Explain the role of indexing in databases?

1134

---

Explain about the relational database?

1080

---

Explain about the database management systems.

976

---

Explain about xml databases?

1077

---

How to use online Backups?

2202

---

What is dbms and its application?

1006

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1003

---

How to customize error conditions.

2152

---

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

2207

---

What is normalization? Explain different levels of normalization?

63125

---

How long can an error message be in raiseerror function?

1006

---

How would you design a database for an online site, which would average a million hits a day?

1013

---