There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers  

---

Explain about cursors?

0 Answers  

---

How to Ensure Data Integrity in a Relational Database?

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,

---

What is an artificial (derived) primary key? When should it be used?

0 Answers  

---

What is string in database?

0 Answers  

---

Where is the data stored in a database?

0 Answers  

---

Explain ddl interpreter?

0 Answers  

---

Explain the types of database normalization?

0 Answers  

---

What is flag in database?

0 Answers  

---

What is end users in dbms?

0 Answers  

---

What is the easiest database to learn?

0 Answers  

---