The table contains a million rows for zonewise analysis in DSS system. You decide to prepare an index on zone column to enhance the performance of the queries on ZONE column. Which type of index would you select?
A.Bitmap index
B.Reverse key index
C.Compressed index
D.Normal B-Tree index
82. You need to create an index that will store only the unique portion of the key just once per leaf block, and groups the rowid for the rows with that key value. Which type of index would you create?
A.Bitmap index
B.Reverse key index
C.Compressed index
D.Normal B-tree index
83. You decide to create an index-organized table in your database. The table would hold a large number of rows and different departments would work only with the relevant rows in the table concurrently. Which statement regarding the above table can enhance performance?
A.It can be partitioned.
B.It can be added to a cluster.
C.It can be created without a primary key.
D.It can be stored using a bitmap structure.
B.The primary key requires more than 3,215 bytes of space. ANSWER: B ANSWER: D
84. The following statement that is used to create an index-organized table (IOT) failed with an error: What could be the reason?
A.A foreign key on another table is too long.
C.More than 3,215 columns are included in the composite Primary Key.
D.More than 3,215 bytes are needed for the aggregate of all the primary keys in the table.
85. You created a mapping table on an index-organized table (IOT). What could be the reason for creating a mapping table?
A.You want to add the IOT to a cluster.
B.You want to keep track of the overflowing segments.
C.You want to store all the non-key columns of the IOT.
D.You want to create a bitmapped secondary index on the IOT.
Tags:
Post comment:
◎welcome to give out your point。