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

第1题：

Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）

• A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
• B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
• C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
• D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

第2题：

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.

第3题：

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.

第4题：

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.

第5题：

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.

第6题：

You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace， you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting？（）

• A、configure a default device for RMAN backups
• B、temporarily disable the retention policy for RMAN backups
• C、configure automatic channel allocation for RMAN backups
• D、use the CONFIGURE command to reconfigure the recovery window to 60 days

第7题：

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.

第8题：

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.

第9题：

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.

第10题：

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.