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 a dynamic query?

1006

---

What schema means?

874

---

how to select first 5 records from a table? : Sql dba

962

---

Why use triggers in sql?

928

---

What are all the different normalization?

1023

---

Can you have a foreign key without a primary key?

937

---

What is the difference between sql and isql*plus?

1070

---

Why stored procedure is faster than query?

1034

---

Can dml statements be used in pl/sql?

1060

---

How do you rank data in sql?

982

---

What operators deal with null?

1083

---

Is sql workbench free?

969

---

What is asqueryable?

947

---

What is the difference between view and stored procedure?

949

---

Show code of a cursor for loop.

1043

---