单选题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 tha

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

相似考题

1.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？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.

2.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.

3.You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）A、 SQL scriptsB、 Recovery Manager （RMAN） scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database

4.You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）A、ONLINEB、REVERSEC、PARALLELD、COMPRESSE、NOLOGGINGF、COMPUTE STATISTICS

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

  • 第1题：

    You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes？（）

    • A、Data Pump
    • B、SQL scripts
    • C、SQL*Loader
    • D、Flashback database
    • E、Recovery Manager （RMAN） script

    正确答案:A,B

  • 第2题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

    • A、 Restore the lost data file from the backup， and then flash back the database.
    • B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
    • C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
    • D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
    • E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

    正确答案:B,E

  • 第6题：

    You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）

    • A、OPTIMAL 
    • B、INITIAL 
    • C、PCTINCREASE 
    • D、NEXT

    正确答案:A

  • 第7题：

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

     Start the database in OPEN mode， and create a new index tablespace.

    B

     Start the database in OPEN mode， and drop the lost index tablespace from the database.

    C

    Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.

    D

     Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.


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

  • 第8题：

    单选题
    You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime 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.


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

  • 第9题：

    多选题
    You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）
    A

    SQL scripts

    B

    Recovery Manager （RMAN） script

    C

    Data Pump

    D

    SQL*Loader

    E

    Flashback database


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

  • 第10题：

    单选题
    You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）
    A

    OPTIMAL 

    B

    INITIAL 

    C

    PCTINCREASE 

    D

    NEXT


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
    A

     by using the Flashback Database feature

    B

     by using RMAN incomplete recovery

    C

     by performing a user-managed incomplete recovery

    D

     by dropping and re-creating the index tablespace


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

  • 第13题：

    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

  • 第14题：

    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

    • A、 ONLINE
    • B、 REVERSE
    • C、 PARALLEL
    • D、 COMPRESS
    • E、 NOLOGGING
    • F、 COMPUTE STATISTICS

    正确答案:C,E

  • 第15题：

    You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime 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题：

    You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）

    • A、 by using the Flashback Database feature
    • B、 by using RMAN incomplete recovery
    • C、 by performing a user-managed incomplete recovery
    • D、 by dropping and re-creating the index tablespace

    正确答案:D

  • 第17题：

    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

    • A、 You cannot perform the TSPITR with the constraints enabled.
    • B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.
    • C、 You can perform TSPITR only on the USERS tablespace.
    • D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.
    • E、 The TSPITR will only be successful if the constraint is enabled.

    正确答案:B

  • 第18题：

    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

  • 第19题：

    多选题
    You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes？（）
    A

    Data Pump

    B

    SQL scripts

    C

    SQL*Loader

    D

    Flashback database

    E

    Recovery Manager （RMAN） script


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

  • 第20题：

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


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

  • 第21题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


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

  • 第22题：

    单选题
    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）
    A

     You cannot perform the TSPITR with the constraints enabled.

    B

     You must perform the TSPITR recovery of both tablespaces for it to be successful.

    C

     You can perform TSPITR only on the USERS tablespace.

    D

     RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.

    E

     The TSPITR will only be successful if the constraint is enabled.


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

  • 第23题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

  • 第24题：

    多选题
    You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）
    A

    ONLINE

    B

    REVERSE

    C

    PARALLEL

    D

    COMPRESS

    E

    NOLOGGING

    F

    COMPUTE STATISTICS


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

相关内容