Answer Posted / mostafa

While reading the file with no lock, defined in the F spec
as I-Input, not U=Update, file can be updated.

After normalization, what are the conditions which have to keep in mind to de-normalize it?

1098

---

what is the full procedure for using store procedure in informatica7.1?

2307

---

Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

1945

---

Can you create a database in word?

1088

---

What happens when shared and exclusive locks are applied on data item?

1085

---

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2290

---

What is the best database?

1035

---

Explain transaction manager?

1120

---

List the properties of a transaction.

1114

---

What are different types of blocks used in stored procedure?

1172

---

What are indexes in oracle?

1129

---

What is the concept of Virtual field?

2096

---

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1975

---

What do you mean by database?

1148

---

5. Explain about relational algebra.

2233

---