单选题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

题目内容(请给出正确答案)

单选题

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

add data files to the tablespace

identify the segments that you should shrink

modify the storage parameters for the tablespace

automatically shrink the segments with unused space

check the alerts generated for the tablespace that is running low on space

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题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？（）AThe database will open，and the tablespace automatically comes out of the backup mode.BThe database will be mounted，and recovery must be performed on the USERS tablespace.CThe database will be mounted，and data files in the USERS tablespace must be taken out of the backup mode.DThe database will not be mounted，and you must restore all the data files for the USERS tablespace from the backup，and perform recovery.

点击查看答案
第2题

单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A Take the USERS tablespace offline and re-create the lost data file.B Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

点击查看答案
第3题

多选题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（）AThe retention period to support flashbackBThe expected length of the longest-running queryCThe number of undo tablespaces in the databaseDThe size of the Flash Recovery Area for the database instance

点击查看答案
第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？（）ASQL Tuning AdvisorBSQL Access AdvisorCUndo AdvisorDSegment Advisor

点击查看答案
第5题

单选题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 DBNEWID utilityB the ANALYZE commandC the RMAN LIST commandD the RMAN REPORT commandE the RMAN CROSSCHECK commandF the RMAN BLOCKRECOVER command

点击查看答案
第6题

单选题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 terminate 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.

点击查看答案
第7题

单选题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 parameters for the tablespace D automatically shrink the segments with unused space E check the alerts generated for the tablespace that is running low on space

点击查看答案

单选题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题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容