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
);

What is the difference between a database and a relational database?

1094

---

What is the difference between join and natural join?

924

---

Is sql a backend?

1009

---

What is rowtype?

1009

---

Is sql scripting language?

1047

---

How to run sql statements through the web interface?

1033

---

What is schema in sql example?

1172

---

What is sql data?

984

---

What is application trigger?

990

---

What is difference between sql function and stored procedure?

1002

---

Can we use ddl commands in pl sql?

1149

---

How to prepare for oracle pl sql certification?

1055

---

What is a unique key and primary key and foreign key?

967

---

What are the benefits of stored procedures?

1057

---

What are joins in sql?

1039

---