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

第1题：

To accomplish user-managed backup for the USERS tablespace， you issued the following command to put the database in backup mode：   SQL> ALTER TABLESPACE users BEGIN BACKUP；   While copying the file to the backup destination a power outage caused the instance to te minate abnormally.  Which statement is true about the next database startup and the USERS tablespace？（）  

• A、 The database will open，and the tablespace automatically comes out of the backup mode.
• B、 The database will be mounted，and recovery must be performed on the USERS tablespace.
• C、 The database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.
• D、 The database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

第2题：

Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）

• A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
• B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
• C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
• D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.

第3题：

You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）

• A、 The command generates an error.
• B、 The command backs up the tablespace and creates a backup set of size 200 MB
• C、 The command backs up the tablespace and creates two backup sets of size 100 MB each.
• D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

第4题：

Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）

• A、The extents in the undo tablespace retain data until the next full database backup.
• B、The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
• C、The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
• D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.

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

第6题：

You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）  

• A、 alter tablespace MY_DATA begin backup
• B、 alter tablespace MY_DATA start backup
• C、 alter tablespace MY_DATA backup begin
• D、 alter MY_DATA begin backup
• E、 You cannot back up individual tablespaces

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

• A、The command must be issued in MOUNT state.
• B、The command succeeds only if the data file is offline.
• C、The command must be issued when the database is in the archivelog mode.
• D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

第14题：

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 NOARCHIVELOG mode and the tablespace is online.
• C、 The database is in NOARCHIVELOG mode and the tablespace is offline.
• D、 The database is in ARCHIVELOG mode and the tablespace is offline.
• E、 The database is in ARCHIVELOG mode and the tablespace is online.

第15题：

You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.

第16题：

You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL

第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 isclosed

第18题：

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

• A、The database will open, and the tablespace automatically comes out of the backup mode
• B、The database will be mounted, and recovery must be performed on the USERS tablespace.
• C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：