Who invented schema theory?

0 Answers  

---

If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains

2 Answers   Wipro,

---

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

0 Answers   Wipro,

---

What is database management definition?

0 Answers  

---

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 Answers  

---

---

Define database model.

0 Answers  

---

What is the purpose of a model?

0 Answers  

---

What is the use of drop command and what are the differences between drop, truncate and delete commands?

0 Answers  

---

Why is the use of dbms recommended? Explain by listing some of its major advantages.

0 Answers  

---

How many types of database language exist?

0 Answers  

---

Mention few case manipulation functions in sql

0 Answers  

---

Explain the Logical Schema of Database

0 Answers   HCL,

---