Answer / Sushma

1. Clustered Index: A type of index that determines how data is physically stored in a table. Each table can have only one clustered index. 2. Non-Clustered Index: An index that stores the indexed columns along with a pointer to the actual data rows. Multiple non-clustered indexes can be created on a single table. 3. Primary Key Index (Clustered): A special kind of clustered index where the primary key columns are used as the basis for sorting and organizing the data in the table. 4. Unique Index: An index that ensures no duplicate values among its indexed columns. 5. Full-Text Index: Used to search textual data in a column or multiple columns.

What are indexes, and what are the different types?

3 Answers  

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

What is the basic structure of PL/SQL ?

6 Answers  

---

How do you rename a table in sql?

1 Answers  

---

What is pl sql in dbms?

1 Answers  

---

What is sql trigger example?

1 Answers  

---

What is the difference between syntax error and runtime error?

1 Answers  

---

How do you use a while loop in pl sql?

1 Answers  

---

What is cross join sql?

1 Answers  

---

What is Raise_application_error ?

1 Answers  

---

What is sql catalog?

1 Answers  

---

What is your daily office routine?

0 Answers   Data Vision,

---