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 |
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Point out the difference between user tables and data dictionary?
How to delete multiple rows from a table in oracle?
How to call a sub procedure?
What is catalog in Oracle?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
what is dynamic SGA and static SGA
How to set a transaction to be read only in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
What is self-referential integrity constraint ?
How to view the data files in the current database?