大數(shù)據(jù)就業(yè)實(shí)戰(zhàn)培訓(xùn) Oracle就業(yè)實(shí)戰(zhàn)培訓(xùn)
OCP 19c 1Z0-082認(rèn)證考試題庫(第5題)-CUUG內(nèi)部學(xué)員版082題庫解析
5.A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?
A. in the undo tablespace
B. in the SYSAUX tablespace
C. in the SGA
D. in the PGA
E. in the temporary tablespace
Answer: E
(解析:temporary undo 是 12c 的一個(gè)新特性,目的是為了減少對正常 undo 表空間的使用造成的影響。)