What is an Index Segment ?

Answers were Sorted based on User's Feedback



What is an Index Segment ?..

Answer / orawhiz

Each Index has an Index segment that stores all of its data

Is This Answer Correct ?    0 Yes 0 No

What is an Index Segment ?..

Answer / nishi

Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

how to make an oracle object

0 Answers  


How to recover a dropped table in oracle?

0 Answers  


What is difference between SUBSTR and INSTR?

1 Answers  


HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 Answers  


I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  


I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  


How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,


What to do if the startbd.bat failed to start the xe instance?

0 Answers  


Explain alias?

0 Answers  


What is oracle server autotrace in oracle?

0 Answers  


A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

1 Answers   IBM,


What are the varoius components of physical database structure of oracle database?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)