单项选择题
A.create a hash cluster to store the data
B.create an index cluster to store the data
C.create a partitioned table to store the data
D.create a sorted hash cluster to store the data
E.create a heap table with rowid to store the data
单项选择题 In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）
单项选择题 Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organizedtable（IOT）.YouwanttocreateabitmapindexontheJOB_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
单项选择题 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？（）