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

Answer / naren patidar

In cluster data of two table store in one object(cluster)
that generates a index that can identify rows of both of
table..



naren

What is auto increment in sql?

0 Answers  

---

What is composite data type in pl sql?

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

Does a primary key have to be a number?

0 Answers  

---

Is inner join faster than left join?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

Why is pl sql used?

0 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

Why do you partition data?

0 Answers  

---

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

---

What are operators available in sql?

0 Answers  

---