首页 > Linux操作系统 > Linux操作系统 > 043-102


原创 Linux操作系统 作者:jbymy2000 时间:2012-03-08 09:02:08 0 删除 编辑
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)
Answer: D
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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-101
下一篇: 043-103
请登录后发表评论 登录


  • 博文量
  • 访问量