Answer / akoman

D) EXPLAIN

Answer / raj kumar

Explain

explain will give the optimizer plan for the query

explain select * from .......etc

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

0 Answers  

---

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

0 Answers  

---

Explain entity type?

0 Answers  

---

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

2 Answers   Accenture,

---

List some advantages of dbms.

0 Answers  

---

Which database does facebook use?

0 Answers  

---

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

0 Answers   3i Infotech,

---

define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,

---

What are different types of blocks used in stored procedure?

0 Answers   C DAC, CDAC,

---

Which is the best sorting method if i have to sort the students of Harvard University according to their first name?

1 Answers   CybAge,

---

What is a Transformation?

0 Answers   Informatica,

---

What is difference between data and database?

0 Answers  

---