Answer / Krishna Chandra Arya

In a database, an index is a data structure that improves the speed of data retrieval by allowing quicker access to specific records based on certain columns. Indexes can be categorized into two main types: Clustered Indexes (which determine the physical order of data in a table) and Non-Clustered Indexes (which store the indexed columns separately from the actual data). There are also other types like Unique Indexes, Composite Indexes, and Partial Indexes.

To manage and manipulate the test table what are the sql statements that you have used in database testing?

1 Answers  

---

What is the database trigger, how to verify the trigger is fired or not and can you invoke trigger on demand?

1 Answers  

---

What are the different types of database testing?

1 Answers  

---

How do you test whether the database is updated as and when an information are added in the front end?give me an example?

1 Answers  

---

What do you mean by index and explain different types of indexes?

1 Answers  

---

How to test a dts package created for data insert update and delete? What should be considered in the above case while testing it?

1 Answers  

---

What steps does a tester take in testing stored procedures?

1 Answers  

---

How do you test whether a database in updated when information is entered in the front end?

1 Answers  

---

What are the types of data-driven testing?

1 Answers  

---

What is retesting & how it is different from data driven testing?

1 Answers  

---

What rdbms stands for and what are the important rdmbs that sql use?

1 Answers  

---

What is the syntax to add record to a table?

1 Answers  

---