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 modes of parameters that can be passed to a procedure ?

3 Answers  

---

What is a scalar value in sql?

0 Answers  

---

what is a constraint? : Sql dba

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

How to write a query to show the details of a student from students table whose

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

What is a merge query?

1 Answers  

---

What is pl/sql and what is it used for?

4 Answers  

---

What if we write return in procedure?

0 Answers  

---

What is triggering circuit?

0 Answers  

---

what is try_catch block in procedure

0 Answers  

---

How do you delete a table?

0 Answers  

---