State three differences between Dbms and Rdbms?

0 Answers   BirlaSoft,

---

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

2 Answers   3i Infotech,

---

Define join and enlist its types.

0 Answers  

---

Is it possible to declare or create a cursor for update of table? If yes tell me how?

0 Answers  

---

what is postback trigger?

1 Answers  

---

Define database system.

0 Answers  

---

What is 2nf in the dbms?

0 Answers  

---

is it sufficient to normalize a database up to 3NF?

4 Answers  

---

What exactly is a database?

0 Answers  

---

Explain the Normalized Relations?

0 Answers  

---

Briefly describe the three types of sql commands.

0 Answers  

---

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,

---