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 the demerits of sql?

1 Answers  

---

Enlist the data types that can be used in pl/sql?

0 Answers  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

---

What is execution plan in sql?

0 Answers  

---

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

0 Answers  

---

What are tables in sql?

0 Answers  

---

How to make a copy values from one column to another in sql?

0 Answers  

---

Does mysql support pl sql?

0 Answers  

---

define data blocks ? : Sql dba

0 Answers  

---

Explain what is dbms?

0 Answers  

---