Answer / Km Anjali Chaudhry

Database normalization is used to eliminate data redundancy and dependencies, improving data integrity, consistency, and ease of management. Normalized databases are easier to maintain, update, and ensure accuracy.

What is the importance of database in an organization?

1 Answers  

---

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

0 Answers  

---

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  

---

What are five advantages of a database?

1 Answers  

---

What is the use of CONSTRAINTS option in EXP command ?

1 Answers  

---

What are the different types of modeling?

1 Answers  

---

What is a RADIO GROUP ?

1 Answers  

---

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

1 Answers  

---

Explain the main control blocks available in ims db?

1 Answers  

---

What are the different modes of mounting a Database with the Parallel Server ?

1 Answers  

---

What is a deadlock and mention how it can be resolved?

1 Answers  

---

What is create database?

1 Answers  

---