itgle.com

多选题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 s

题目
多选题
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.

相似考题

1.Which three operations can be performed as multipartition operations in Oracle?()A. Merge partitions of a list partitioned tableB. Drop partitions of a list partitioned tableC. Coalesce partitions of a hash-partitioned global index.D. Move partitions of a range-partitioned tableE. Rename partitions of a range partitioned tableF. Merge partitions of a reference partitioned index

2.Which is a restriction on a list partitioned table？（）A、You cannot create global range partitioned indexes on the table. B、The optimizer will not execute partition wise joins on the table’s partitions. C、You must include at least one element in the value list of each partition of the table, even if that element is the keyword NULL. D、Partition pruning will not occur during query optimizer if a range of values is included in the query predicate.

3.A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

4.You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）A、The Automatic Memory Manager (AMM)B、The SQL Tuning AdvisorC、The Segment AdvisorD、The SQL Access Advisor SQL

更多“多选题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 s”相关问题

  • 第1题：

    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.

    正确答案:B,C,F

  • 第2题：

    You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.  The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals： SQL> EXECUTE  DBMS_STATS.GATHER_TABLE_STATS（’SH’，’SALES’，GRANULARITY=>’GLOBAL’）；   You need statistics to be collected more quickly.  What can you do to achieve this？（）

    • A、 Set DYNAMIC_SAMPLING to level 4
    • B、 Set the STATISTICS_LEVEL parameter to BASIC
    • C、 Set the INCREMENTAL value to TRUE for the partition table
    • D、 Increase the value of STALE_PERCENT for the partition table

    正确答案:C

  • 第3题：

    You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

    • A、a table name which has 100s of records
    • B、a table name which has 10s of records
    • C、a table name which has empty records
    • D、a table name which has 1000s of records
    • E、never use a table name

    正确答案:C

  • 第4题：

    In which scenario will you create a sorted hash cluster？ （）

    • A、 if the application uses queries joining tables only occasionally
    • B、 if the full table scan is executed often on only one table of the clustered tables
    • C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
    • D、 when you want the data to be returned automatically in the chronological order

    正确答案:D

  • 第5题：

    You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

    • A、Monitor thealert.logfile
    • B、Enable server-side SQL tracing for user sessions
    • C、Enable fine-grained auditing for the customer table
    • D、Enable Fine-Grained Access Control （FGAC） for the customer table
    • E、Write a database trigger on the customer table on the SELECT event

    正确答案:D

  • 第6题：

    Which three operations can be performed as multipartition operations in Oracle?（）

    • A、Merge partitions of a list partitioned table
    • B、Drop partitions of a list partitioned table
    • C、Coalesce partitions of a hash-partitioned global index.
    • D、Move partitions of a range-partitioned table
    • E、Rename partitions of a range partitioned table
    • F、Merge partitions of a reference partitioned index

    正确答案:A,B,F

  • 第7题：

    单选题
    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
    A

    The Automatic Memory Manager (AMM)

    B

    The SQL Tuning Advisor

    C

    The Segment Advisor

    D

    The SQL Access Advisor


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
    A

    The Automatic Memory Manager (AMM)

    B

    The SQL Tuning Advisor

    C

    The Segment Advisor

    D

    The SQL Access Advisor SQL


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table.  Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent.    A strategy should be designed to have the performance of the queries on the table optimized.    Which action will you perform?（）
    A

    The clustered index of the Orders table should be dropped.

    B

    The clustered index of the Orders table offline should be rebuilt once a month.

    C

    The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.

    D

    The clustered index of the Orders table should be reorganized by reducing the fill factor.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    In which scenario will you create a sorted hash cluster？ （）
    A

     if the application uses queries joining tables only occasionally

    B

     if the full table scan is executed often on only one table of the clustered tables

    C

     if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

    D

     when you want the data to be returned automatically in the chronological order


    正确答案： D
    解析： 暂无解析

  • 第11题：

    多选题
    In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?（）
    A

    The partitions can be moved online to new tablespaces.

    B

    Global indexes must be rebuilt manually after moving the partitions.

    C

    The partitions can be compressed in the same tablespaces.

    D

    The partitions can be compressed in the new tablespaces.

    E

    Local indexes must be rebuilt manually after moving the partitions.


    正确答案： E,D
    解析： 暂无解析

  • 第12题：

    多选题
    Which three operations can be performed as multipartition operations in Oracle?（）
    A

    Merge partitions of a list partitioned table

    B

    Drop partitions of a list partitioned table

    C

    Coalesce partitions of a hash-partitioned global index.

    D

    Move partitions of a range-partitioned table

    E

    Rename partitions of a range partitioned table

    F

    Merge partitions of a reference partitioned index


    正确答案： C,B
    解析： 暂无解析

  • 第13题：

    Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

    • A、ALTER TABLE SPLIT PARTITION
    • B、ALTER TABLE MERGE PARTITION
    • C、ALTER TABLE TRUNCATE PARTITION
    • D、ALTER TABLE ADD PARTITION
    • E、ALTER TABLE DROP PARTITION
    • F、ALTER TABLE MOVE PARTITION

    正确答案:C,E

  • 第14题：

    The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）

    • A、B-tree
    • B、bitmap
    • C、reverse key
    • D、function based

    正确答案:B

  • 第15题：

    A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）

    • A、The keep pool is not configured.
    • B、Automatic Workarea Management is not configured.
    • C、Automatic Shared Memory Management is not enabled.
    • D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
    • E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

    正确答案:D

  • 第16题：

    In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?（）

    • A、The partitions can be moved online to new tablespaces.
    • B、Global indexes must be rebuilt manually after moving the partitions.
    • C、The partitions can be compressed in the same tablespaces.
    • D、The partitions can be compressed in the new tablespaces.
    • E、Local indexes must be rebuilt manually after moving the partitions.

    正确答案:A,B,D

  • 第17题：

    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

    • A、SQL Access Advisor
    • B、 Memory Advisor
    • C、SQL Tuning Advisor
    • D、 Segment Advisor

    正确答案:A

  • 第18题：

    You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

    • A、The Automatic Memory Manager (AMM)
    • B、The SQL Tuning Advisor
    • C、The Segment Advisor
    • D、The SQL Access Advisor

    正确答案:D

  • 第19题：

    单选题
    You have a very large table that your users access frequently.  Which of the following advisors will recommend any indexes to improve the performance of queries against this table？（）
    A

     The Automatic Memory Manager （AMM）

    B

     The SQL Tuning Advisor

    C

     The Segment Advisor

    D

     The SQL Access Advisor


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
    A

    SQL Access Advisor

    B

     Memory Advisor

    C

    SQL Tuning Advisor

    D

     Segment Advisor


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
    A

    ALTER TABLE SPLIT PARTITION

    B

    ALTER TABLE MERGE PARTITION

    C

    ALTER TABLE TRUNCATE PARTITION

    D

    ALTER TABLE ADD PARTITION

    E

    ALTER TABLE DROP PARTITION

    F

    ALTER TABLE MOVE PARTITION


    正确答案： A,C
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： B,C,F
    解析： 暂无解析

  • 第23题：

    单选题
    You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（）
    A

    DBMS_SERVER_ALERT

    B

    DBMS_ADVISOR

    C

    DBMS_RESOURCE_MANAGER

    D

    DBMS_REPAIR


    正确答案： D
    解析： 暂无解析

相关内容