单选题An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）A EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.B

题目
单选题
An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）
A

EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.

B

ALTER TABLE … COALESCE ；

C

ALTER INDEX …REBUILD ONLINE；

D

CREATE TABLE …AS SELECT_ONLINE；

相似考题

1.For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables (IOT)

2.While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（） A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

3. 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？（） A、heap tablesB、object tablesC、partitioned tablesD、index-organized tables （IOTs）

4.While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

更多“单选题An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）A EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.B”相关问题

  • 第1题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index­organized table （IOT）

    正确答案:A

  • 第2题：

    You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（） 

    • A、 Index-organized table
    • B、 Mapping Table
    • C、 Clustered Table
    • D、 Journal Table

    正确答案:D

  • 第3题：

    The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）

    • A、Temporary tables 
    • B、Index-organized tables 
    • C、Cluster tables 
    • D、Standard Oracle tables 

    正确答案:D

  • 第4题：

    While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）

    • A、 A primary key must have been created.
    • B、 A mapping table must have been created.
    • C、 An overflow tablespace must have been specified.
    • D、 The PCTTHRESHOLD option must have been specified.

    正确答案:B

  • 第5题：

    For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)

    • A、views
    • B、fixed tables
    • C、heap tables
    • D、external tables
    • E、temporary tables
    • F、index-organized tables (IOT)

    正确答案:C,F

  • 第6题：

    An index-organized table （IOT） called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed， while minimizing the impact for users？（）

    • A、EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
    • B、ALTER TABLE … COALESCE ；
    • C、ALTER INDEX …REBUILD ONLINE；
    • D、CREATE TABLE …AS SELECT_ONLINE；

    正确答案:B

  • 第7题：

    单选题
    You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：  ERROR at Line 1：  ORA-10635： Invalid segment ortablespacetype What could be the reason？（）
    A

    The table is partitioned

    B

    The table name is wrong.

    C

    It is an index-Organized table （IOT）

    D

    The table is stored in locally managedtablespace.

    E

    The table is stored in atablespacewhere segment space is managed manually.


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

  • 第8题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

     Export and import the mapping table.

    B

     Drop and re-create the mapping table.

    C

     Truncate the mapping table and reinsert the values.

    D

     Use the ALTER TABLE .. REBUILD command to defragment the mapping table.


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

  • 第9题：

    单选题
    You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX：   SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE；   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）
    A

     Index-organized table

    B

     Mapping Table

    C

     Clustered Table

    D

     Journal Table


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

  • 第10题：

    单选题
    An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）
    A

    disabling the index

    B

    making the index invisible

    C

    making the index unusable

    D

    using the MONITORING USAGE clause for the index


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

  • 第11题：

    多选题
    Online index rebuild functionality has been extended to include which four index structures？（）
    A

    Bitmap indexes.

    B

    Reverse key indexes.

    C

    Function-based indexes.

    D

    Key-compressed indexes on regular tables.

    E

    Key-compressed indexes on IOT （including secondary indexes）


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

  • 第12题：

    单选题
    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？（）
    A

     heap tables

    B

     object tables

    C

     partitioned tables

    D

     index-organized tables （IOTs）


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

  • 第13题：

    In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

    • A、export and import the mapping table
    • B、drop and re­create the mapping table
    • C、truncate the mapping table and reinsert the values
    • D、use the ALTER TABLE .. REBUILD command to defragment the mapping table

    正确答案:B

  • 第14题：

    Online index rebuild functionality has been extended to include which four index structures？（）

    • A、Bitmap indexes.
    • B、Reverse key indexes.
    • C、Function-based indexes.
    • D、Key-compressed indexes on regular tables.
    • E、Key-compressed indexes on IOT （including secondary indexes）

    正确答案:B,C,D,E

  • 第15题：

    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

    • A、heap table
    • B、object table
    • C、external table
    • D、clustered table
    • E、global temporary table
    • F、index-organized table （IOT）

    正确答案:A

  • 第16题：

    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data？（） 

    • A、export and import the mapping table
    • B、drop and re-create the mapping table
    • C、truncate the mapping table and reinsert the values
    • D、use the ALTER TABLE···REBUILD command to defragment the mapping table

    正确答案:B

  • 第17题：

    You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows：  ERROR at Line 1：  ORA-10635： Invalid segment ortablespacetype What could be the reason？（）

    • A、The table is partitioned
    • B、The table name is wrong.
    • C、It is an index-Organized table （IOT）
    • D、The table is stored in locally managedtablespace.
    • E、The table is stored in atablespacewhere segment space is managed manually.

    正确答案:E

  • 第18题：

    单选题
    In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

    export and import the mapping table

    B

    drop and re-create the mapping table

    C

    truncate the mapping table and reinsert the values

    D

    use the ALTER TABLE···REBUILD command to defragment the mapping table


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

  • 第19题：

    单选题
    In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）
    A

     Heap table

    B

     Object table

    C

     External table

    D

     Clustered table

    E

     Global temporary table

    F

     Index-organized table （IOT）


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

  • 第20题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


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

  • 第21题：

    单选题
    In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）
    A

    export and import the mapping table

    B

    drop and re­create the mapping table

    C

    truncate the mapping table and reinsert the values

    D

    use the ALTER TABLE .. REBUILD command to defragment the mapping table


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

  • 第22题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


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

  • 第23题：

    单选题
    While designing your database， you have created the EMPLOYEEStable as an index-organized （IOT）. You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

     A primary key must have been created.

    B

     A mapping table must have been created.

    C

     An overflow tablespace must have been specified.

    D

     The PCTTHRESHOLD option must have been specified.


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

相关内容