Oracle 11G OCP 1Z0-053 214

(214)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 remainas the default but must have no active sort operations.

答案:(A)

解析:

本地管理的临时表空间才支持空间收缩到指定尺寸

请使用浏览器的分享功能分享到微信等