题目内容

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?()

A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

查看答案
更多问题

蓄电池车辆()。

A. 能平稳起动
B. 不能平稳起动
C. 耐振动
D. 加速慢

简述灭火作战预案的内容。

要在Excel 2010单元格中,提供下拉式选单菜单让使用者从已设置的多个选项中选择,下列最适宜的作法是()。

A. 设置“数据有效性”方式为单元格内允许“序列”
B. 设置“数据有效性”方式为单元格内允许“自定义”
C. 在单元格中插入“下拉式菜单”表单控件
D. 在单元格中插入“列表框”Activex控件

位于县城的某运输公司为增值税一般纳税人,具备国际运输资质, 2015年7月经营业务如下: (1)国内运送旅客,按售票统计取得价税合计金额177.6万元;运送旅客至境外,按售票统计取得价税合计金额53.28万元。 (2)运送货物,开具增值税专用发票注明运输收入金额260万元、装卸收入金额18万元。 (3)提供仓储服务,开具增值税专用发票注明仓储收入金额70万元、装卸收入金额6万元。 (4)修理、修配各类车辆,开具普通发票注明价税合计金额31.59万元。 (5)销售使用过的未抵扣进项税额的货运汽车6辆,开具普通发票注明价税合计金额24.72万元。 (6)进口轻型商用客车3辆自用,经海关核定的成交价共计57万元、运抵我国境内输入地点起卸前的运费6万元、保险费3万元。 (7)购进小汽车4辆自用,每辆单价16万元,取得销售公司开具的增值税专用发票注明金额64万元、税额10.88万元:另支付销售公司运输费用,取得运输业增值税专用发票注明运费金额4万元、税额0.44万元。 (8)购进汽油取得增值税专用发票注明金额10万元、税额1.7万元,90%用于公司运送旅客,10%用于公司接送员工上下班;购进矿泉水一批,取得增值税专用发票注明金额2万元、税额0.34万元,70%赠送给公司运送的旅客,30%用于公司集体福利。(其他相关资料:假定进口轻型商用客车的关税税率为20%、消费税税率5%) 计算该公司7月应向主管税务机关缴纳的增值税。

答案查题题库