Youopenedtheencryptionwalletandthenissuedthefollowingcommand:SQLCREATETABLESPACEsecurespaceDATAFILE’/home/user/oradata/secure01.dbf’SIZE150MENCRYPTIONUSING’3DES168’DEFAULTSTORAGE(ENCRYPT);Thenyouclosedthewallet.Later,youissuedthefollowingcommandtocreatetheEMPLOYEEStableintheSECURESPACEtablespaceandyouusetheNOSALToptionfortheEMPIDcolumn.Whatistheoutcome?()A.Itcreatesthetableandencryptsthedatainit.B.Itgeneratesanerrorbecausethewalletisclosed.C.Itcreatesthetablebutdoesnotencryptthedatainit.D.ItgeneratesanerrorbecausetheNOSALToptioncannotbeusedwiththeENCRYPToption.

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

A.Itcreatesthetableandencryptsthedatainit.

B.Itgeneratesanerrorbecausethewalletisclosed.

C.Itcreatesthetablebutdoesnotencryptthedatainit.

D.ItgeneratesanerrorbecausetheNOSALToptioncannotbeusedwiththeENCRYPToption.


相关考题:

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?()A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.