多选题
A The application user has exceeded their undo quota.
B The FLASHBACK GUARANTEE option is set on the undo tablespace.
C The table is currently being queried by a Flashback Transaction Query operation.
D The table is currently being queried by a Flashback Versions Query operation.
E The RETENTION GUARANTEE option is set on the undo tablespace.
正确答案
答案解析
略
相似试题
Exhibit： View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace： SQL> ALTER TABLE trans SHRINK SPACE CASCADE； Which objects would be affected by this command？（）
多选题查看答案
Which statements are true regarding the USERS tablespace（）
多选题查看答案
Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.
单选题查看答案
View the Exhibit. Which statements are true regarding the USERS tablespace（）
多选题查看答案
View the Exhibit and examine the characteristics of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find information about table fragmentation？（）
单选题查看答案
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 （）
单选题查看答案
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？（）
单选题查看答案
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS； Which three types of files are backed up？ （）
多选题查看答案
You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）
多选题查看答案