Explain what index types are supported by your local DBMS. Give the commands used to create each type.
What will be an ideal response?
Sybase supports B trees with the command:
```
create [unique] [clustered | nonclustered] index index_name
on table_name
(column_name [asc | desc] [, column_name [asc | desc]]...)
[with [fillfactor = pct | max_rows_per_page=num_rows ] ]
```
The unique option indicates that the search key is a key of the table (and hence duplicate values of the search key are not allowed). The asc | desc option speci?es whether index entries on the associated column are to be sorted in ascending or descending order. Either a ?ll factor or (not both) the maximum number of rows per page can be speci?ed. These constraints limit the number of rows on data pages or the number of index entries on the leaf pages of an unclustered index. The ?ll factor speci?es the initial percentage of the page that will be ?lled. However, the actual
percentage will change as the data changes. A speci?cation of the maximum number of rows per page, however, is maintained as the data changes.
You might also like to view...
A page break on a worksheet is indicated by a dotted line
Indicate whether the statement is true or false.
A _________________________ detector is a sensor that detects the infrared or ultraviolet light produced by an open flame.
Fill in the blank(s) with the appropriate word(s).
After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end.
Fill in the blank(s) with the appropriate word(s).
Web Forms controls map straight to HTML tags. There is a one-to-one correspondence between the controls and the tags generated.
Answer the following statement true (T) or false (F)