单选题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？（）AEXPORT with TABLES and IMPORT with the INDEX and IGNORE options.BALTER TABLE … COALESCE ；CALTER INDEX …REBUILD ONLINE；DCREATE TABLE …AS SELECT_ONLINE；
单选题
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；
参考解析
解析：
暂无解析
相关考题：
Many a player who had been highly thought of has () from the tennis scene. A. disposedB. discouragedC. disappearedD. discarded
Which statement is correct about the forwarding table?() A. The forwarding table is stored only on the PFEB. The forwarding table contains all known routesC. The forwarding table is stored on both the RE and PFED. The forwarding table is stored only on the RE
Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1() A.0B.1C.3D.6
The girl has awakened the feelings in him that his thought had been__________long ago.A．called upB．taken upC．stamped outD．handed in
Everyone has their embarrassing moments. Many celebrities say they__________in so many embarrassing situations over the years.A．had beenB．have beenC．wereD．are
The girl has awakened the feelings inhim that his thought had been __________long ago.A.called up B.taken upC.stamped out D.handed in
Which three statements are true about IP multicast configuration?（）A、PIM sparse - dense mode and PIM dense mode require an RP on the network.B、PIM sparse mode and PIM dense mode require an RP on the network.C、PIM sparse mode interfaces are always added to the multicast routing table in a router.D、PIM sparse mode and PIM sparse - dense mode require an RP on the network.E、PIM dense mode interfaces are always added to the multicast routing table in a router.F、PIM sparse - dense mode acts as PIM dense mode if an RP is not known.
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）A、if a table is not in a clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it
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.
Which statement is correct about the forwarding table?（）A、The forwarding table is stored only on the PFEB、The forwarding table contains all known routesC、The forwarding table is stored on both the RE and PFED、The forwarding table is stored only on the RE
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 tableB、drop and recreate the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table
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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table （IOT）
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.
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)
You work as a database administrator for Supportcenter.cn. 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 or tablespace type What could be the reason？ （）A、The table is partitionedB、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.
单选题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？（）AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.
单选题You work as a database administrator for Supportcenter.cn. 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 or tablespace type What could be the reason？ （）AThe table is partitionedBThe table name is wrong.CIt is an index-Organized table （IOT）DThe table is stored in locally managedtablespace.EThe table is stored in atablespacewhere segment space is managed manually.
单选题The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR;（）AYou obtain the results retrieved from the public synonym HR created by the database administrator.BYou obtain the results retrieved from the HR table that belongs to your schema.CYou get an error message because you cannot retrieve from a table that has the same name as a public synonym.DYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.EYou obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
单选题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 tableB Object tableC External tableD Clustered tableE Global temporary tableF Index-organized table （IOT）
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A The materialized view should have a complete refresh performed after the online table redefinition is completed.B The materialized view should have a fast refresh performed after the online table redefinition is completed.C The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
单选题Britain has recently had a high level of unemployment but the same is true _____ many other countries.Aat BofCfrom Dto
单选题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.
单选题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.
多选题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）Aif a table is not in a clusterBif a table has an active triggerCif a table has an encryptedDif a table has a column of data type LONG defined on itEif a table has a referential integrity constraint defined on it
单选题Britain has recently had a high level of unemployment but the same is true ______ many other countries.AatBofCfromDto
单选题Mother: You’re watching too much TV, Emily. Emily: Oh, come on, Mom. Mother: ________ And you’re eating too many snacks. Emily: I only had some popcorn and some potato chips.AI mean it.BYou’re excused.CWhere’s your radio?DI don’t want to know it.
单选题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？（）Aexport and import the mapping tableBdrop and re-create the mapping tableCtruncate the mapping table and reinsert the valuesDuse the ALTER TABLE···REBUILD command to defragment the mapping table