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 |
Do you know what is fill factor and pad index?
What is the difference between temp table and table variable?
I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.
Explain about link server in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
hi i gone though satyam interview. what is Acid Properties?
How do you know which index a table is using?
What is data compression?
What is primary key index?
What is the difference between a fill factor of 100 and 0?
Explain the concept of recursive stored procedure.
When would you use it?
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)