PHYSICAL OR LOGICAL LISTING OF COLUMN TO SPEEDUP THE SEARCH IN A TABLE OR

What is Index and different types of Indexes?

Question Posted / manvendra

7 Answers
36188 Views
I also Faced
E-Mail Answers

Answer Posted / manvendra

PHYSICAL OR LOGICAL LISTING OF COLUMN TO SPEEDUP THE SEARCH
IN A TABLE OR VIEW IS CALLED INDEX.

FUNCTION BASED INDEX
HASH INDEX
BITMAP INDEX
COMPOSIT INDEX
B TREE INDEX

Is This Answer Correct ?

8 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the limitations of check constraint?

1022

How to define an oracle cursor variable?

1021

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2167

Explain an extent?

1092

How to write text literals in oracle?

1061

What is an Oracle Instance?

1113

interview questions with answer for cts

2578

Write a syntax for update query in oracle?

1024

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2822

What are named parameters?

1086

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2135

How to get maxsal , minsal, ename department wise in single query

1544

What is partitioned table in Oracle?

1181

What are a collation and state the different types of collation sensitivity?

1163

What is the sid in oracle?

961