Answer Posted / vijayan.t

A table join to itself is known as self join.


select e1.empid,e1.empname,e1.empmgrname where empmgrid =
empid;

here in a single table e1 having three fields(employee id,
employee name,manager id)one employee's manager id is
another one employee's employee id so compare that 2 ids and
we can get the particular employee's manager name...

What is data modeling with example?

932

---

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?

2386

---

What are the constraints on severity level in raiseerror?

951

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2173

---

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

933

---

Explain the cube operator?

955

---

Which four data types cannot be used as a return type from a user-defined function?

981

---

Explain what a database is?

999

---

How can you fix a poorly performing query?

1125

---

How is data stored in dbms?

904

---

How you can make a parameterized view?

973

---

Who are naive users?

966

---

How to use online Backups?

2170

---

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?

1034

---

What are the 18 schemas?

1069

---