What kind of index does CREATE TABLE generally yield? What kind of index does CREATE INDEX generally create? What is the advantage of the former kind of index over the latter kind?
What will be an ideal response?
Integrated, clustered, main index.
Separate, unclustered, secondary index.
Avoids an indirection (1 fewer page), allows to use sparse index, allows efficient range search, supports partial key searches.
You might also like to view...
A constructor is a method that __________.
a. returns an object of the class b. never receives any arguments c. performs initialization or setup operations d. removes the object from memory
The ________ sign should be put around dates so that Access knows they are dates
Fill in the blank(s) with correct word
The current directory is the root directory. To remove the Util directory from drive C, enter
A) ERA C:\UTIL B) DEL C:\UTIL C) RD C:\UTIL D) RD C:\
?Interface design should call for attention to the interface, rather than facilitating design objectives.
Answer the following statement true (T) or false (F)