Answer Posted / sanchit aggarwal(oracle dev.)

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

Explain the rollup operator?

1068

---

Why does this query return 0?

1010

---

How you can make a parameterized view?

1006

---

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

2490

---

Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card

2155

---

What is normalization? Explain different levels of normalization?

63062

---

Write the fastest query to find out how many rows exist in a table?

1106

---

Explain about relational database management systems?

960

---

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

2847

---

What are the constraints on severity level in raiseerror?

980

---

Explain about xml databases?

1056

---

How to replace not in with not exist?

2075

---

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

1002

---

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?

1058

---

Write short notes on manual refreshes.

2725

---