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

Name the operator which is used in the query for pattern matching?

892

---

Explain the uses of a database trigger?

982

---

what is recursive stored procedure? : Sql dba

930

---

what is single byte over head in oracle..?

2339

---

Which are the different case manipulation functions in sql?

953

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1006

---

What are the advantages of pl sql?

1070

---

What is the syntax to add a record to a table?

1021

---

How do rank () and dense_rank () differ?

974

---

how to include comments in sql statements? : Sql dba

910

---

How much does sql certification cost?

1015

---

What is a natural join?

991

---

What is database white box testing and black box testing?

1046

---

how to create a table index in mysql? : Sql dba

986

---

Can you join a table to itself?

1030

---