What is an Index Segment ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
Each Index has an Index segment that stores all of its data
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
How to delete an existing row from a table in oracle?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
can u call user defined functions in select statements
What happens if the update subquery returns multiple rows?
How to Truncate Table in Oracle
What are the different types of databases?
What is the maximum limit on the number of columns in a table?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is the difference between Delete, Truncate and Drop in Oracle?
What is a subquery?
What is ASM (Automatic Storage Management) in Oracle?
What is a deadlock in SQL? How can you prevent it?