Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
);
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is pl/sql language case sensitive?
What does fetching a cursor do?
What are the advantages of sql? Explain
Why we use joins in sql?
Does mysql support pl sql?
Why are cursors used?
Why left join is used in sql?
What is file based approach?
Differentiate between pl/sql and sql?
How can you fetch first 5 characters of the string?
What is partition by in sql?
Can we use two order by clause in query?
What is the use of & in pl sql?
Is vs as in pl sql?
What do you mean by table in sql?
