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？（）
第1题：
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（）
第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？（）
第3题：
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Which methodswould you use to achieve this?（）
A. Use Data Pump to transfer the existing data to a new encrypted tablespace
B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
第4题：
You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
第5题：
You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）
第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？（）
第7题：
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement： ALTER TABLESPACE data1 BEGIN BACKUP； While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
第8题：
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（）
第9题：
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）
第10题：
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？（）