Answer / Arjun Tyagi

We need to use databases to store large amounts of data, manage relationships between different types of data, ensure data consistency and security, enable efficient retrieval of specific data, and support applications that rely on the data.

What is an optimization and performance tuning and how does it really work in practical projects?

1 Answers  

---

what are the acid properties in dbms?

1 Answers  

---

How rdbms is different from dbms?

1 Answers  

---

Why is database used?

1 Answers  

---

What does partition mean in database?

1 Answers  

---

How to Handle Missing Data in a Database?

1 Answers  

---

Is there a database program for mac?

1 Answers  

---

Why is the use of dbms recommended? Explain by listing some of its major advantages.

1 Answers  

---

Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

1 Answers  

---

user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?

1 Answers   HCL,

---

How to create a database from my program?

1 Answers  

---

what are the advantages of a client or server model ?

1 Answers  

---