---

You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  
A: The tablespace must be locally managed.
B: The tablespace must have only one temp file.
C: The tablespace must be made nondefault and offline.
D: The tablespace can remain as the default but must have no active sort operations.

---

出自：Oracle认证

显示答案