当前位置:1Z0-060题库

问题:

[多选]

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.

You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?()  RBAL。  CKPT。  SMON。  PMON。  MMON。  CTWR。  DBWR。 在电子认证活动中,认证机构由于不可抗力因素而暂停或终止全部或部分证书服务的,应当() 承担全部违约责任。 部分免除违约责任。 全部免除违约责任。 部分或全部免除违约责任。 Which new key architectural element introduced in WebLogic Server l2c should you take  advantage of when designing Disaster Recovery Centers with active - passive mode?() MAN Clusters, because they would allow you to synchronously replicate state in low latency networks 。 WAN Clusters, because they would allow you to asynchronously replicate state in nonlow latency networks.  。 Transaction Log in the database, because you could avoid synchronizing two replication technologies (database and file)  。 Data Guard, because it is the most effective way to replicate a state across locations。 GoldenGate, because it is the most effective way to replicate a state across locatio。 施工组织总设计的主要内容包括()。 建设项目的工程概况。 施工方案的选择。 各项资源需求量计划。 施工总进度计划。 You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()  Enable Flashback Data Archive for the tables.。  Specify undo retention guarantee for the database.。  Enable supplemental logging for the database.。  Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.。  Create Flashback Data Archive on the tablespace on which the tables are stored.。

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?()

参考答案:

  参考解析

本题暂无解析

在线 客服