You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?

2 Answers  

---

Explain data dictionary.

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,

---

Define database system.

0 Answers  

---

How do you open .db files?

0 Answers  

---

What is db dialect?

0 Answers  

---

Compare non-clustered and clustered index

0 Answers  

---

Differentiate between nested loop, hash loop and merge join.

0 Answers  

---

Define cursor.

0 Answers  

---

Where is database used?

0 Answers  

---

Can we save file in database?

0 Answers  

---

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 Answers  

---