单选题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（）.Aadd data files to the tablespace Bidentify the segments that you should shrink Cmodify the storage parameters for the tablespace Dautomatically shrink the segments with unused space Echeck 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 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 create a Web application for your company‘s intranet. You want to enable users to customize their versions of the intranet home page. You create sections of content as Web Parts. You need to ensure that users can customize content at any time.Which two code segments should you use?（）A.B.C.D.
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 shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space
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 flashbackB、The expected length of the longest-running queryC、The number of undo tablespaces in the databaseD、The size of the Flash Recovery Area for the database instance
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 shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space
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 scriptsB、 Recovery Manager （RMAN） scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database
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 commandB、 the DBNEWID utilityC、 the RMAN REPORT commandD、 the RMAN BLOCKRECOVER commandE、 the RMAN CROSSCHECK commandF、 the ANALYZE command
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 PumpB、SQL scriptsC、SQL*LoaderD、Flashback databaseE、Recovery Manager （RMAN） script
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.
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 AdvisorB、 SQL Access AdvisorC、 Undo AdvisorD、 Segment Advisor
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.
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 modeB、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.
Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）A、Shut down the database, restore the two data files and then start up the database. B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）A、 Disable SQL tracing for the APPS tablespace.B、 Disable logging attributes for the APPS tablespace.C、 Modify the tablespace to be a dictionary-managed tablespace.D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）ASegment Advisor BSQL Tuning Advisor CSQL Access Advisor DSegment Resource Estimation EAutomatic Database Diagnostic Monitor (ADDM)
单选题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 shrinkB modify the storage parameters for the tablespaceC automatically shrink the segments with unused spaceD check the alerts generated for the tablespace that is running low on space
多选题Identify three situations in which you would NOT be able to drop a tablespace. （）Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
单选题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（）。Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically shrink the segments with unused spaceDcheck the alerts generated for the tablespace that is running low on space
多选题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
单选题While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
单选题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？（）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.
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
多选题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
单选题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 AdvisorB SQL Access AdvisorC Undo AdvisorD Segment Advisor
单选题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？（）Athe DBNEWID utilityBthe ANALYZE commandCthe RMAN LIST commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe RMAN BLOCKRECOVER command
单选题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?（）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.
单选题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（）.Aadd data files to the tablespace Bidentify the segments that you should shrink Cmodify the storage parameters for the tablespace Dautomatically shrink the segments with unused space Echeck the alerts generated for the tablespace that is running low on space