多选题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？ （）ARestore t

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

相似考题

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 lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

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. The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

更多“You lost a data file that belongs to an index tablespace in ”相关问题

  • 第1题：

    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第2题：

    When performing an incomplete recover of the whole database， which data files must you restore？ （）

    • A、Only the damaged or lost data files.
    • B、All of the data files of the database.
    • C、Only the data files belonging to the SYSTEM tablespace.
    • D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

    正确答案:B

  • 第3题：

    Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

    • A、 The queries that are currently executing will abort and an error message will be returned to the user.
    • B、 The queries that are currently executing will execute normally but future queries will not executed.
    • C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
    • D、 The currently executing and future queries will execute normally， but will be slower

    正确答案:D

  • 第4题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第5题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


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

  • 第6题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第7题：

    单选题
    When performing an incomplete recover of the whole database， which data files must you restore？ （）
    A

    Only the damaged or lost data files.

    B

    All of the data files of the database.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    The data files belonging to the SYSTEM tablespace and the damaged or lost data files.


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

  • 第8题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


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

  • 第9题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第10题：

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


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

  • 第11题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

    • A、Add a data file to the SMD tablespace.
    • B、Add a data file to the temporary tablespace associated with the user HR.
    • C、Resize the data file associated with the SMD tablespace to make it larger.
    • D、Alter the data file associated with the SMD tablespace to grow automatically.
    • E、Change the segment space management for the SMD tablespace to automatic

    正确答案:A,C,D

  • 第16题：

    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）

    • A、 You find that one of the redo log members in each redo log group is lost.
    • B、 You find that a data file that belongs to the USERS tablespace is damaged.
    • C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.
    • D、 You find that the current redo log group is damaged and is not available for recovery.
    • E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.

    正确答案:D,E

  • 第17题：

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


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

  • 第18题：

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

  • 第19题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


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

  • 第20题：

    多选题
    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）
    A

    You find that one of the redo log members in each redo log group is lost.

    B

    You find that a data file that belongs to the USERS tablespace is damaged.

    C

    You find that a data file that belongs to the SYSTEM tablespace is damaged.

    D

    You find that the current redo log group is damaged and is not available for recovery.

    E

    You realized while performing a recovery that an archived redo log file needed for recovery is lost.


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

  • 第21题：

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


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

  • 第22题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.


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

  • 第23题：

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


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

  • 第24题：

    多选题
    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
    A

    Restore the data file and perform incomplete recovery.

    B

    Restore the data file and perform point-in-time recover.

    C

    Drop the tablespace and lose all data in the tablespace.

    D

    Restore the database and lose all data since the last backup.


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

相关内容