Answer Posted / dhivya

lets take a table A which is joined to itself with its
alias is said to be self join.Most familiar example is
finding the manager of the employee..

select e1.emp_id manager_id,e2.emp_id employee_id from
employee e1,employee e2
where e1.emp_id=e2.emp_id

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

2117

---

Who are naive users?

958

---

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

1023

---

What is an application role and explain a scenario when you would use one?

967

---

How can you fix a poorly performing query?

1111

---

Explain about network model?

957

---

What are the types of database model?

1035

---

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?

1020

---

What is the maximum length of an extended property?

938

---

What is dbms and its application?

954

---

Explain what a database is?

989

---

I have a few records all are same structures data, I want to store data in multiple targets how

2600

---

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

924

---

What are the constraints on severity level in raiseerror?

943

---

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

1047

---