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 |
How do you delete a trigger?
Explain few examples of RDBMS?
query processing
What do you mean by an execution plan? How would you view it?
Psudo colums
What is open database communication (odbc)?
What is the difference between for trigger and after trigger?
How to find the version of sql server? : sql server database administration
What are the different types of stored procedures?
Do you know what are pages and extents? : SQL Server Architecture
What stored by the msdb? : sql server database administration
What are the benefits and tasks of object explorer? : sql server management studio
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)