Youopenedtheencryptionwalletandthenissuedthefollowingcommand:SQL>CREATETABLESPACEsecurespaceDATAFILE’/home/user/oradata/secure01.dbf’SIZE150MENCRYPTIONUSING’3DES168’DEFAULTSTORAGE(ENCRYPT);Thenyouclosedthewallet.Later,youissuedthefollowingcommandtocreatet

题目

Youopenedtheencryptionwalletandthenissuedthefollowingcommand:SQL>CREATETABLESPACEsecurespaceDATAFILE’/home/user/oradata/secure01.dbf’SIZE150MENCRYPTIONUSING’3DES168’DEFAULTSTORAGE(ENCRYPT);Thenyouclosedthewallet.Later,youissuedthefollowingcommandtocreatetheEMPLOYEEStableintheSECURESPACEtablespaceandyouusetheNOSALToptionfortheEMPIDcolumn.Whatistheoutcome?()

A.Itcreatesthetableandencryptsthedatainit.

B.Itgeneratesanerrorbecausethewalletisclosed.

C.Itcreatesthetablebutdoesnotencryptthedatainit.

D.ItgeneratesanerrorbecausetheNOSALToptioncannotbeusedwiththeENCRYPToption.


相似考题
参考答案和解析
参考答案:B