单项选择题
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
单项选择题 Inyourdatawarehousingapplication,yougeneratereportsfrequently.Thedataisstaticinthetablesbeingusedtogeneratereports.Youarecurrentlyusingjoins,resultinginalargeperformanceoverhead.Whatkindofdatabasestructurewouldyouusetoreducetheresponsetimeofthequery?()
单项选择题 Whiledesigningyourdatabase,youhavecreatedtheEMPLOYEEStableasanindexorganizedtable(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?()