Answer Posted / hari krishna
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 |
Post New Answer View All Answers
What is 2nf in normalization?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the difference between update lock and exclusive lock?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Who is the owner of a schema in ms sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is data modification?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is a non clustered primary key?
Explain different types of lock modes in sql server 2000?
How do I create a stored procedure in dbml?
How to write a query with an inner join in ms sql server?
Do you know what are acid properties of transaction?
what's the difference between a primary key and a unique key? : Sql server database administration
How many types of schemas are there?