An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.  What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）  A、 TE

题目

An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.  What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）  

  • A、 TEST_TBS is a small file tablespace.
  • B、 TEST_TBS is a bigfile tablespace （BFT）.
  • C、 TEST_TBS is the default temporary tablespace.
  • D、 TEST_TBS is a dictionary-managed tablespace.
相似考题

1.An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）A. TEST_TBS is a small file tablespace.B. TEST_TBS is a bigfile tablespace (BFT).C. TEST_TBS is the default temporary tablespace.D. TEST_TBS is a dictionary-managed tablespace.

2. You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

3. Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

4. You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.

更多“An online tablespace，”相关问题

  • 第1题：

    Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）

    • A、The operation would fail if tbs_1 were a read-only tablespace.
    • B、The operation would fail if tbs_1 were a read/write tablespace.
    • C、The operation would fail if tbs_1 were the default tablespace for the database.
    • D、If the above operation were successful， media recovery would be required to bring the tablespace online.
    • E、If the above operation were successful， instance recovery would be required to bring the tablespace online.

    正确答案:D

  • 第2题：

    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

  • 第3题：

    An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）

    • A、TEST_TBS is a small file tablespace 
    • B、TEST_TBS is a bigfile tablespace (BFT)
    • C、TEST_TBS is the default temporary tablespace
    • D、TEST_TBS is a dictionary-managed tablespace
    • E、Threshold values for the TEST_TBS tablespace are not explicitly specified

    正确答案:D

  • 第4题：

    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

    • A、 all the data files belonging to the USERS tablespace
    • B、 password file
    • C、 online redo log files
    • D、 the current control file
    • E、 archived redo log files
    • F、 the current server parameter file
    • G、 data files belonging to the USERS tablespace and all the default tablespaces

    正确答案:A,D,F

  • 第5题：

    单选题
    An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
    A

    TEST_TBS is a small file tablespace 

    B

    TEST_TBS is a bigfile tablespace (BFT)

    C

    TEST_TBS is the default temporary tablespace

    D

    TEST_TBS is a dictionary-managed tablespace

    E

    Threshold values for the TEST_TBS tablespace are not explicitly specified


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

  • 第6题：

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

  • 第7题：

    单选题
    An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
    A

    TEST_TBS is a small file tablespace.

    B

    TEST_TBS is a bigfile tablespace (BFT).

    C

    TEST_TBS is the default temporary tablespace.

    D

    TEST_TBS is a dictionary-managed tablespace.


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

  • 第8题：

    单选题
    Why should you back up a duplicated tablespace after a TSPITR is complete？（）
    A

     The tablespace cannot be duplicated or restored to any point in time after the duplication. 

    B

     The tablespace cannot be duplicated or restored to the point in time before the duplication. 

    C

     The entire database cannot be restored after a TSPITR， so a backup is required.

    D

     You cannot bring the tablespace online until its been backed up.

    E

     There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.


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

  • 第9题：

    单选题
    You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）
    A

    The MTTR Advisor is disabled.

    B

    The database is in NOARCHIVELOG mode.

    C

    The tablespace is already in backup mode.

    D

    The Flash Recovery Area is not configured


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

  • 第10题：

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

  • 第11题：

    单选题
    In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）
    A

     The datafiles have an ONLINE status.

    B

     The datafiles have an OFFLINE status.

    C

     The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.

    D

     The datafiles have an OFFLINE status and are in hot backup mode for an online backup.

    E

     The datafiles are in STANDBY mode.


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

  • 第12题：

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

  • 第13题：

    In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）  

    • A、 The datafiles have an ONLINE status.
    • B、 The datafiles have an OFFLINE status.
    • C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
    • D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
    • E、 The datafiles are in STANDBY mode.

    正确答案:A

  • 第14题：

    In which of the following scenarios is a tablespace recovery required？（）

    • A、 when recovering a lost read-only tablespace from a read-only tablespace backup
    • B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
    • C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
    • D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

    正确答案:B

  • 第15题：

    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

    • A、The tablespace would require recovery to go back online.
    • B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
    • C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error
    • D、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

    正确答案:B,C

  • 第16题：

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

  • 第17题：

    多选题
    You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error.

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance is closed.


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

  • 第18题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


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

  • 第19题：

    单选题
    Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
    A

     The database does not record flashback logs for MY_TABLESPACE

    B

     The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.

    C

     All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.

    D

     None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE


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

  • 第20题：

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


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

  • 第21题：

    单选题
    You issued the following command：   ALTER TABLE SCOTT.EMP SHRINK SPACE；   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties：   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error：   ORA-10635： Invalid segment or tablespace type    What could be the reason for the failure of the command？（）
    A

     The tablespace， DATA1， is not read-only.

    B

     The tablespace， DATA1， is not autoextensible.

    C

     The tablespace， DATA1， is not offline.

    D

     The segment space management for the tablespace， DATA1， is manual.


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

  • 第22题：

    多选题
    You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）
    A

    The tablespace would require recovery to go back online.

    B

    A checkpoint is taken on all data files that are associated with the SALES tablespace.

    C

    The sessions that subsequently try to access the objects in the SALES tablespace receive an error

    D

    The new status of the SALES tablespace is recorded in the control file when the database instance isclosed


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

  • 第23题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第24题：

    单选题
    Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）
    A

    The operation would fail if tbs_1 were a read-only tablespace.

    B

    The operation would fail if tbs_1 were a read/write tablespace.

    C

    The operation would fail if tbs_1 were the default tablespace for the database.

    D

    If the above operation were successful， media recovery would be required to bring the tablespace online.

    E

    If the above operation were successful， instance recovery would be required to bring the tablespace online.


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

相关内容