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 difference between sql and excel?

0 Answers  

---

How to look at the current sql*plus system settings?

0 Answers  

---

Why do you partition data?

0 Answers  

---

What is a string data type in sql?

0 Answers  

---

Explain the purpose of %type and %rowtype data types?

0 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What are the two types of exceptions in pl/sql?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

How do you delete duplicates in sql query using rowid?

0 Answers  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

What is primary key secondary key alternate key candidate key?

0 Answers  

---

What is sql not null constraint?

0 Answers  

---