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 are sql procedures?

0 Answers  

---

What are stored procedures in mysql?

0 Answers  

---

what is an associative array with example?

1 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

What does data normalization mean?

0 Answers  

---

What do you know by pl/sql cursors?

0 Answers  

---

How do you update a table in sql?

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

What is the usage of nvl function?

0 Answers  

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

What are the parts of a sql statement?

0 Answers  

---

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

---