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.

how to include comments in sql statements? : Sql dba

962

---

What are the different schemas objects that can be created using pl/sql?

1031

---

Explain the purpose of %type and %rowtype data types?

930

---

Mention what are the benefits of pl/sql packages?

1084

---

How many primary keys can a table have?

1009

---

how to decrement dates by 1 in mysql? : Sql dba

1020

---

What are the possible values that can be stored in a boolean data field?

1002

---

What is dense_rank?

935

---

What are the different type of joins in sql?

956

---

what happens if you no create privilege in a database? : Sql dba

1002

---

Which join is default?

958

---

Write a query to find the names of users that begin with "um" in sql?

998

---

What are procedures used for?

986

---

What are sql indexes?

1004

---

What is sharding in sql?

990

---