Answer / Navraj Singh Dharmshktu

"DBMS (Database Management System) offers several advantages:
1. Improved data integrity through ACID properties.
2. Scalability through horizontal and vertical scaling.
3. Efficient query performance due to indexing and optimization techniques.
4. Simplified data management tasks like backup, recovery, and security.
5. Facilitates collaboration among users by allowing concurrent access to data."

What is database optimization?

1 Answers  

---

How to drop all foreign keys in database?

1 Answers  

---

Enlist the types of cursor?

1 Answers  

---

Explain a tp monitor?

1 Answers  

---

what is the difference between two and three-tier architectures?

1 Answers  

---

What do you understand by intension and extension?

1 Answers  

---

Where does the LGWR process writes information?

1 Answers  

---

Explain Relational Algebra in RDBMS

1 Answers   Infosys,

---

How to select a random record from a table?

1 Answers  

---

What is the importance of query in database?

1 Answers  

---

What are the basic components of notification services?

1 Answers  

---

Can A column defined as PRIMARY KEY can have NULL values ?

2 Answers  

---