Answer / Shubhangi

Indexing is a process of creating additional structures to speed up data retrieval within a database. An index is similar to an index at the end of a book, allowing the user to quickly find the required information without searching through the entire document. For example, creating an index on the 'Name' column of a Customer table would allow faster querying based on the customer name.

What are the importance of partitioning in dbms?

1 Answers  

---

Explain the terms specialization and generalization.

1 Answers  

---

What do you mean by buffer manager?

1 Answers  

---

What is query in rdbms?

1 Answers  

---

What are stand-alone procedures?

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,

---

Why is maintaining a database important?

1 Answers  

---

Explain what are the two types of oltp?

1 Answers  

---

What is database management system(dbms)?

1 Answers  

---

Compare a hierarchical and network database model?

1 Answers  

---

How data are stored in database?

1 Answers  

---

Why rdbms is not suitable for big data?

1 Answers  

---