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 |
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.
What is the difference between temp table and table variable?
What is a raid and what are different types of raid configurations?
what are the different types of replication you can set up in sql server? : Sql server database administration
What are the components of dbms?
Can we use where and having clause together?
What is indexing in sql server with example?
What is a trigger what are the advantages of trigger?
What is the significance of master, tempdb and model databases?
How do you Implement SSIS Packages in your Project?
What are the difference between data length and length in SQL Server-2008?
what is a deadlock? : Sql server database administration