Answer / Deepanshu Pathak

Denormalization is the process of intentionally duplicating data to eliminate or reduce the need for joining tables in a database. This can help improve performance, simplify queries, and reduce complexity by reducing the number of joins required. However, it may lead to data redundancy and inconsistency.

What is Restricted Mode of Instance Startup ?

1 Answers  

---

What integrity rules exist in the dbms?

1 Answers  

---

Define atomicity and aggregation.

1 Answers  

---

Enlist some commands of ddl?

1 Answers  

---

What do you mean by extension and intension?

1 Answers  

---

What information can be stored in a database?

1 Answers  

---

Why is data modelling important?

1 Answers  

---

What is the full meaning of dbms?

1 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,

---

what do u mean by implementation?

1 Answers  

---

What are the advantages of a database?

1 Answers  

---

What are the 5 major parts of a database system?

1 Answers  

---