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

What are the constraints on severity level in raiseerror?

1046

---

What are the key features of dbms?

1041

---

How to customize error conditions.

2197

---

fact table and dimension table containg one to many relationship or many to one relastionship

2546

---

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

2263

---

What are the three types of database design?

1080

---

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

1170

---

Which data type cannot be used as a parameter in a udf?

1020

---

What is dbms explain in brief?

1078

---

How to combine two function together?

2200

---

What are the three basic rules which are to be followed for the relational model of the database?

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?

2467

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2468

---

Explain the role of indexing in databases?

1184

---

Explain about the hierarchical model of the database?

1165

---