单选题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 p
题目
Index-organized table
Mapping Table
Clustered Table
Journal Table
相似考题
参考答案和解析
更多“单选题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 pe”相关问题
-
第1题：
You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）
- A、 Rebuild the index.
- B、 Coalesce the index.
- C、 Drop and re-create the index in the new tablespace.
- D、 Relocate the index using the ALTER INDEX...MOVE statement.
正确答案:A -
第2题：
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
- A、 Drop and re-create the inbox.
- B、 Coalesce the ORDERS_IND index.
- C、 Coalesce the INDEXES tablespace.
- D、 Drop and re-create the ORDERS table.
- E、 Rebuild the index online and move it to another tablespace.
正确答案:B,E -
第3题：
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
- A、drop and re-create the index
- B、coalesce the ORDERS_IND index
- C、coalesce the INDEXES tablespace
- D、drop and re-create the ORDERS table
- E、rebuild the index online and move it to another tablespace
正确答案:B,E -
第4题：
You issued the following statement to monitor the usage of the index： SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）
- A、 INDEX_STATS
- B、 DBA_INDEXES
- C、 DBA_IND_COLUMNS
- D、 V$OBJECT_USAGE
正确答案:D -
第5题：
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 -
第6题：
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL> CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）
- A、 PCTFREE
- B、 MAXTRANS
- C、 PCTINCREASE
- D、 INITIAL
- E、 NOLOGGING
- F、 PARALLEL
正确答案:E,F -
第7题：
单选题Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）AOracle Data Pump.
BAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
CAn ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
DOnline Table Redefinition.
EEdition-Based Table Redefinition.
正确答案： D解析： 暂无解析 -
第8题：
单选题You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）AThe index tablespace contains bitmap indexes.
BThe index tablespace contains more than one data file.
CThe index tablespace supports only complete recovery.
DThe index tablespace is not a dictionary-managed tablespace.
EThere is a dependency relationship between a table and its indexes.
正确答案： A解析： 暂无解析 -
第9题：
单选题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？（）AExport and import the mapping table.
BDrop and re-create the mapping table.
CTruncate the mapping table and reinsert the values.
DUse the ALTER TABLE .. REBUILD command to defragment the mapping table.
正确答案： B解析： 暂无解析 -
第10题：
单选题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？（）AIndex-organized table
BMapping Table
CClustered Table
DJournal Table
正确答案： C解析： 暂无解析 -
第11题：
单选题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；
正确答案： C解析： 暂无解析 -
第12题：
单选题You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）AThe index can be changed from NOLOGGING to LOGGING
BThe index cannot be recovered even in the ARCHIVELOG mode.
CThe index can only be created if the base table is created with the NOLOGGING option.
DThe index can be recovered if you perform a backup after the CREATE INDEX statement.
正确答案： D解析： 暂无解析 -
第13题：
You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）
- A、 INDEX_STATS
- B、 DBA_INDEXES
- C、 DBA_IND_COLUMNS
- D、 V$OBJECT_USAGE
正确答案:A -
第14题：
In which scenarios would you rebuild an index？（）
- A、 when you need to disable the index usage
- B、 when you need to change storage options
- C、 when you need to enable index monitoring
- D、 when you need to move the index to another tablespace
正确答案:B,D -
第15题：
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）
- A、 The index tablespace contains bitmap indexes.
- B、 The index tablespace contains more than one data file.
- C、 The index tablespace supports only complete recovery.
- D、 The index tablespace is not a dictionary-managed tablespace.
- E、 There is a dependency relationship between a table and its indexes.
正确答案:E -
第16题：
当需要重建某个索引ix_customername，可以使用（）方式。
- A、ALTER INDEX ix_customername REBUILD
- B、ALTER INDEX ix_customername BUILD
- C、UPDATE INDEX ix_customername BUILD
- D、UPDATE INDEX ix_customername REBUILD
正确答案:A -
第17题：
Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strategy available in Oracle9i？（）
- A、Rebuild the index using the online option.
- B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
- C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
- D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
正确答案:C -
第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？（）Aexport and import the mapping table
Bdrop and re-create the mapping table
Ctruncate the mapping table and reinsert the values
Duse the ALTER TABLE···REBUILD command to defragment the mapping table
正确答案： B解析： 暂无解析 -
第19题：
单选题At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）AStart the database in OPEN mode， and create a new index tablespace.
BStart the database in OPEN mode， and drop the lost index tablespace from the database.
CStart the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.
DStart the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
正确答案： A解析： 暂无解析 -
第20题：
单选题You are a DBA of your company. You created a database named SALES on an Oracle 10g instance. You have defined an index named INDEX1 on the database table named INVENTORY. Users are complaining that queries accessing the INVENTORY table are running slow. Upon investigation you determine that the tablespace where the index is located is experiencing high I/O and you decide to relocate the index to another tablespace. Which of these will be the best way to accomplish this objective？（）ARebuild the index.
BCoalesce the index.
CDrop and re-create the index in the new tablespace.
DRelocate the index using the ALTER INDEX...MOVE statement.
正确答案： A解析： 暂无解析 -
第21题：
多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）ADrop and re-create the inbox.
BCoalesce the ORDERS_IND index.
CCoalesce the INDEXES tablespace.
DDrop and re-create the ORDERS table.
ERebuild the index online and move it to another tablespace.
正确答案： E,A解析： 暂无解析 -
第22题：
单选题You issued the following statement to monitor the usage of the index： SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）AINDEX_STATS
BDBA_INDEXES
CDBA_IND_COLUMNS
DV$OBJECT_USAGE
正确答案： B解析： 暂无解析 -
第23题：
多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）Adrop and re-create the index
Bcoalesce the ORDERS_IND index
Ccoalesce the INDEXES tablespace
Ddrop and re-create the ORDERS table
Erebuild the index online and move it to another tablespace
正确答案： B,E解析： 暂无解析 -
第24题：
单选题You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）AINDEX_STATS
BDBA_INDEXES
CDBA_IND_COLUMNS
DV$OBJECT_USAGE
正确答案： D解析： 暂无解析