You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

Which two roles or privileges must you have to export tables owned by another user？（）

多选题查看答案

You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）

多选题查看答案

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）.

单选题查看答案

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

单选题查看答案

You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

单选题查看答案

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

单选题查看答案

You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

单选题查看答案

As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

单选题查看答案

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

单选题查看答案

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）  

单选题查看答案