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.
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.
相关考题：
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.
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.
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.
Your Oracle Database 10g is online when you execute the following statement： SQLALTER 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
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.
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.
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.
In which of the following scenarios is a tablespace recovery required？（）A、 when recovering a lost read-only tablespace from a read-only tablespace backupB、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG modeC、 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 overwrittenD、 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
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 tablespaceD、TEST_TBS is a dictionary-managed tablespaceE、Threshold values for the TEST_TBS tablespace are not explicitly specified
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 errorD、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed
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 tablespaceB、 password fileC、 online redo log filesD、 the current control fileE、 archived redo log filesF、 the current server parameter fileG、 data files belonging to the USERS tablespace and all the default tablespaces
单选题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？（）AOnly bring the tablespace back online.BOnly recover the tablespace and then bring the tablespace back online.CShut down the database， recover the data file and then start up the database.DIssue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.ERecover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.
单选题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?（）ATEST_TBS is a small file tablespace BTEST_TBS is a bigfile tablespace (BFT)CTEST_TBS is the default temporary tablespaceDTEST_TBS is a dictionary-managed tablespaceEThreshold values for the TEST_TBS tablespace are not explicitly specified
多选题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（）AThe tablespace would require recovery to go back online.BA checkpoint is taken on all data files that are associated with the SALES tablespace.CThe sessions that subsequently try to access the objects in the SALES tablespace receive an error.DThe new status of the SALES tablespace is recorded in the control file when the database instance is closed.
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
单选题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？（）AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut 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. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题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?（）ATEST_TBS is a small file tablespace.BTEST_TBS is a bigfile tablespace (BFT).CTEST_TBS is the default temporary tablespace.DTEST_TBS is a dictionary-managed tablespace.
单选题Your Oracle Database 10g is online when you execute the following statement： SQLALTER 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
单选题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.
单选题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.
单选题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（）AThe MTTR Advisor is disabled.BThe database is in NOARCHIVELOG mode.CThe tablespace is already in backup mode.DThe Flash Recovery Area is not configured
单选题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.
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
多选题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（）AThe tablespace would require recovery to go back online.BA checkpoint is taken on all data files that are associated with the SALES tablespace.CThe sessions that subsequently try to access the objects in the SALES tablespace receive an errorDThe new status of the SALES tablespace is recorded in the control file when the database instance isclosed
单选题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.
多选题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？ （）AThe database is in NOMOUNT state.BThe database is in ARCHIVELOG mode and the tablespace is online.CThe database is in ARCHIVELOG mode and the tablespace is offline.DThe database is in NOARCHIVELOG mode and the tablespace is online.EThe database is in NOARCHIVELOG mode and the tablespace is offline.
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
单选题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？ （）AThe operation would fail if tbs_1 were a read-only tablespace.BThe operation would fail if tbs_1 were a read/write tablespace.CThe operation would fail if tbs_1 were the default tablespace for the database.DIf the above operation were successful， media recovery would be required to bring the tablespace online.EIf the above operation were successful， instance recovery would be required to bring the tablespace online.