Answer Posted / ramya

CREATE TABLE EMPLOYEE(

[EMPLOYEE_ID] INT PRIMARY KEY,

[NAME] NVARCHAR(50),

[MANAGER_ID] INT

)



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.employee_id,e1.name,e1.manager_id,e2.name from
employee e1 join employee e2
on e1.employee_id = e2.manager_id

How can you log an error to the server event log from a stored procedure?

1111

---

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

2858

---

What are the 18 schemas?

1123

---

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?

1068

---

Write short notes on manual refreshes.

2742

---

What is normalization? Explain different levels of normalization?

63140

---

What are the three types of database design?

1026

---

How is data stored in dbms?

965

---

In which table collections errors are stored.

2418

---

What are the key features of dbms?

997

---

What are the main phases of database development?

983

---

Explain the role of indexing in databases?

1136

---

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

2209

---

Explain about post-relational databases?

1030

---

How you can make a parameterized view?

1022

---