What is Index Segmentation ?
A segment is a part of relational data base and consists of
one or more extents. Each extent is further divided into
blocks. Every segment has an index for holding all of its
data for quick data retrieval. Index segments can be created
explicitly by using the CREATE INDEX command. Storage
parameters for the extents of the index segment can be
specified along with this command.
| Is This Answer Correct ? | 4 Yes | 1 No |
What are mdf,ndf,ldf files and how to see the data in those files?
Explain Active/Active and Active/Passive cluster configurations?
what is the sql equivaent of the dataset relation object ?
Explain how to integrate the ssrs reports in application?
In what version of sql server were synonyms released?
can an order by clause be used in a creation of a view?
What are the steps to follow to configure SQL*Net?
What is the standby server?
How you can find out if an index is useful to the optimizer?
explain the type of contraints
What is row_number function?
What is a filestream?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)