SQL Tuning Advisor
SQL Access Advisor
Undo Advisor
Segment Advisor
第1题：
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that. So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task? （）
A. A
B. B
C. C
D. D
第2题：
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）
第3题：
A. There is demand for space from the new table从
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space
第4题：
You find pockets of empty space in the USER_DATA tablespace due to a lot of DML operations on the objects in the USER_DATAtablespace. The pockets of empty spaces are too small to be reused individually. This is leading to wastage of space. You decide to perform the shrink operation to reclaim the wasted space. Which advisor will you use to determine the objects in the USER_DATA tablespace that are good candidates for the shrink operation？（）
第5题：
You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）
第6题：
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
第7题：
The user HR receives the following error while inserting data into the TTK table： ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）
第8题：
A. identify the segments that you should shrink
B. modify the storage parameters for the tablespace
C. automatically shrink the segments with unused space
D. check the alerts generated for the tablespace that is running low on space
第9题：
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）
第10题：
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）