Answer Posted / reddibasha

Do you mean Composite Index?

Composite index is the index created on multiple columns of
a table. A maximum of 16 columns can be used as a composite
index. It can be created at table level only. Unique,
Primary Key and Foreign Key can be composite keys.

Ex:
Create table emp
(eno number,
ename varchar(5),
dob date,
sal number,
dno number,
Primary Key(eno, ename) -- Composite Index
);

how to escape special characters in sql statements? : Sql dba

1124

---

what is dbms? : Sql dba

1070

---

Is primary key clustered index?

1028

---

what is bcp? When does it used? : Sql dba

1065

---

what is collation? : Sql dba

1242

---

What is your daily office routine?

2353

---

What is the current version of sql?

1106

---

define sql insert statement ? : Sql dba

1110

---

Is primary key always clustered index?

1101

---

Can we rollback truncate?

1083

---

Does group by remove duplicates?

1120

---

Can we use distinct and group by together?

1147

---

Can delete statement be rollbacked?

1065

---

what is schema? : Sql dba

1163

---

how many tables will create when we create table, what are they? : Sql dba

1156

---