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 pl/sql language case sensitive?

1131

---

What does fetching a cursor do?

1094

---

What are the advantages of sql? Explain

1107

---

Why we use joins in sql?

986

---

Does mysql support pl sql?

1176

---

Why are cursors used?

1123

---

Why left join is used in sql?

983

---

What is file based approach?

945

---

Differentiate between pl/sql and sql?

1153

---

How can you fetch first 5 characters of the string?

1018

---

What is partition by in sql?

1071

---

Can we use two order by clause in query?

968

---

What is the use of & in pl sql?

1047

---

Is vs as in pl sql?

992

---

What do you mean by table in sql?

996

---