102. While designing the database for one of your online transaction
processing (OLTP) applications, you want to achieve the following:
a) high availability of data
b) faster primary key access to the table data
c) compact storage for the table
Which type of tables would you use to achieve these objectives?
A. heap tables
B. object tables
C. partitioned tables
D. index-organized tables (IOTs)
Index-organized tables provide faster access to table rows by the
primary key or any key that is a valid prefix of the primary key.
Because rows are stored in primary key order, a significant amount of
additional storage space savings can be obtained through the use of key
Use of primary-key based logical rowids, as opposed to physical rowids,
in secondary indexes on index-organized tables allows high availability.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718015/，如需转载，请注明出处，否则将追究法律责任。