- Oracle 11g OCP认证052考试题库（76）-CUUG内部学员版Which two are true about UNDO data ? A)Inactive UNDO cannot be overwritten until the elapsed time since becoming inactive exceeds UNDO_RETENTION. B)Active UNDO can never be overwritten. C)Act...[详细]
- Oracle 11g OCP认证052考试题库（75）-CUUG内部学员版Which two are true about UNDO segments and UNDO tablespaces in the same database and instance ? A)Multiple transactions may share a single UNDO segment. B)A database can have multiple active UN...[详细]
- Oracle 11g OCP认证052考试题库（74）-CUUG内部学员版Which three are true about UNDO segments and UNDO tablespaces in the same database and instance ? A)A database can have multiple UNDO tablespaces. B)UNDO segments are automatically dropped shor...[详细]
- Oracle 11g OCP认证052考试题库（73）-CUUG内部学员版Which four are true about UNDO ? A)Guaranteed UNDO retention prevents inactive and expired undo from being deleted. B)DML statements generate UNDO. C)Active UNDO is never deleted. D)Inactive ...[详细]
- Oracle 11g OCP认证052考试题库（72）-CUUG内部学员版Which three are true about UNDO data? A)It is used to rewind a database by using FLASHBACK DATABASE. B)It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP. C)It is ...[详细]
- Oracle 11g OCP认证052考试题库（71）-CUUG内部学员版Which four are true about transactions, undo segments, and undo tablespaces? A)undo tablespaces contain undo segments and Global Temporary Table Data. B)undo segments can be brought offline aut...[详细]
- Oracle 11g OCP认证052考试题库（70）-CUUG内部学员版Which two are true about transactions, UNDO segments, and UNDO tablespaces? A)UNDO tablespaces are created and dropped automatically. B)UNDO tablespaces are brought ONLINE or OFFLINE as require...[详细]
- Oracle 11g OCP认证052考试题库（69）-CUUG内部学员版Which three are true? A)Active UNDO might be retained for 15 or more minutes. B)Inactive UNDO might be retained for 15 or more minutes. C)The UNDO tablespace is guaranteed to be retained forev...[详细]
- Oracle 11g OCP认证052考试题库（68）-CUUG内部学员版Which two are true? A)Inactive expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace. B)The UNDO tablespace can grow automatically if th...[详细]
- Oracle 11g OCP认证052考试题库（67）-CUUG内部学员版Examine these SQL statements and their output: SQL select name,value 2 from v$parameter 3 where name like 'undo%'; NAME VALUE -------------------- ------------------- undo_management AUTO ...[详细]
- Oracle 11g OCP认证052考试题库（66）-CUUG内部学员版Which two are true? A)Transactions will wait until free space becomes available in the undo tablespace when they have failed to allocate space B)The undo tablespace will grow automatically if t...[详细]
