Answer Posted / jeevan

Index is nothing but an identification of each row. It will be used for quick search.

Types Of Index:
---------------

Clustered Index:
Clustered index is a physical sorting of database table’s rows in a storage media. For this reason, each table may have one clustered index. If a primary key constraint is created for a table but no clustered index exists for a table, then SQL server automatically create a clustered index on a primary key.

Non Clustered Index:
Non clustered index are created outside of the table and contain a sorted list of references to a table itself. Maximum we can use 249 clustered indexes per table.

Note:
Only 1 clustered Index can be used per table.
Maximum 249 non clustered index can be used per table.

What is normalisation and its types?

997

---

What are primary key and foreign key and how they work?

973

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1011

---

How to select all records from the table?

1131

---

what are the differences among rownum, rank and dense_rank? : Sql dba

1036

---

What is vector point function?

1048

---

Is grant a ddl statement?

894

---

What is sql*plus?

1072

---

Is sqlite good enough for production?

990

---

Why we use join in sql?

960

---

How do sql triggers work?

1035

---

Why join is faster than subquery?

1104

---

What is character functions?

1059

---

What is percent sign in sql?

1281

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1031

---