单选题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（）.A add data files to the tablespace B identify the segments that you should shrink C modify the storage parame

第1题：

Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

• A、The retention period to support flashback
• B、The expected length of the longest-running query
• C、The number of undo tablespaces in the database
• D、The size of the Flash Recovery Area for the database instance

第2题：

You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

• A、 SQL scripts
• B、 Recovery Manager （RMAN） script
• C、 Data Pump
• D、 SQL*Loader
• E、 Flashback database

第3题：

第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？（）

• A、 SQL Tuning Advisor
• B、 SQL Access Advisor
• C、 Undo Advisor
• D、 Segment Advisor

第5题：

You lost the index tablespace in your database. You decided to re/x7fcreate the index tablespace and the indexes in the tablespace.  What methods can you use to re/x7fcreate the indexes？（）

• A、Data Pump
• B、SQL scripts
• C、SQL*Loader
• D、Flashback database
• E、Recovery Manager （RMAN） script

第6题：

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（）。

• 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

第7题：

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

• A、 the RMAN LIST command
• B、 the DBNEWID utility
• C、 the RMAN REPORT command
• D、 the RMAN BLOCKRECOVER command
• E、 the RMAN CROSSCHECK command
• F、 the ANALYZE command

第8题：

第9题：

Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

• A、The database remains open.
• B、The database gets dismounted.
• C、The database becomes read only.
• D、The database instance gets aborted.
• E、The database gets shut down automatically.
• F、The status of the database depends on the status of the USERS tablespace.

第10题：

View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

• A、The tablespace has two data files.
• B、An error is reported and tablespace creation fails.
• C、Data files are created with names generated by the instance.
• D、The tablespace can be extended without specifying the data file.
• E、Data files belonging to the USERS tablespace cannot be renamed.