在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）A.ALTER USER scott IDENTIFIED BY helloB.ALTER scott USER IDENTIFIED BY helloC.ALTER USER scott IDENTIFIED AS helloD.ALTER USER hello IDENTIFIED BY scott
在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）
A.ALTER USER scott IDENTIFIED BY hello
B.ALTER scott USER IDENTIFIED BY hello
C.ALTER USER scott IDENTIFIED AS hello
D.ALTER USER hello IDENTIFIED BY scott
相关考题：
在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）A.ALTER PROFILE USER scott otherprofileB.ALTER otherprofile USER scottPROFILEC.ALTER USER scott PROFILE otherprofileD.ALTER scott USER PROFILE otherprofile
YousettheundopoolresourceplandirectivefortheconsumergroupnamedDSS_USERSthatisassignedtotheDAY_SHIFTplan.Thedatabaseusers，SCOTTandBLAKE，belongtotheDSS_USERSresourcegroup.Theuser，SCOTT，initiatesadatabasesessionandexecutesabatchoperationthatinsertsmillionsofrowsintotheHISTORYtable.WhichtwooptionsaretrueifthetotalundospaceallocatedtotheDSS_USERSgroupexceedsthevaluespecifiedintheundopoolresourceplandirective？（）A.Thebatchoperationstartedbytheuser，SCOTT，terminateswithanerror.B.Thebatchoperationstartedbytheuser，SCOTT，hangsandyouarerequiredtoincreasetheundopoolresourceplandirective.C.Thebatchoperationstartedbytheuser，SCOTT，runsuninterruptedbecausethedatabaseusestheSYSTEMtablespacefortheundooperation.D.Theuser，BLAKE，cannotstartatransactionthatusesanyDMLoperationsuntilyouincreasethevalueoftheundopoolresourceplandirective.E.TheuserBLAKEcanstartatransactionthatusesanyDMLoperationsafterthebatchoperationstartedbytheuser，SCOTT，terminateswithanerror.
Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQLEXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）A.byusingtheDBMS_SESSIONpackageB.bygrantingtheDBAroleC.byusingtheDBMS_RESOURCE_MANAGERpackageD.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage
Youissuethefollowingcode:EXECDBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(’SCOTT’’GRP1’,TRUE);Whatwillbetheresultofexecutingtheabovecode?() A.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergrouptoGRP1.B.Theswitchprivilegewillbegrantedtotheuser，Scott，forchangingtheconsumergroupfromGRP1toanyothergroup.C.ThecodewillnotexecutesuccessfullybecausethereisnoGRANT_SWITCH_CONSUMER_GROUPprocedureintheDBMS_RESOURCE_MANAGER_PRIVSpackage.D.Thecodewillexecutesuccessfullybutnoprivilegewillbegrantedtotheuser，Scott.
WhatwillbetheresultofusingtheSQL>DROPUSERSCOTTCASCADE;command?() A.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andtheobjectsthatarealreadyintheRecycleBinaredropped.B.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaareplacedintheRecycleBin，andalltheobjectsintheRecycleBin，belongingtotheuserScott，arenotdropped.C.Theuser，Scott，isdropped，alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBin，belongingtotheuser，Scott，arenotdropped.D.Theuser，Scott，isdropped，alltheobjectsinScott’sschemaarenotplacedintheRecycleBin，andtheobjectsintheRecycleBinaredropped.
在oracle数据库下,在启用审计的数据库上执行下面的命令SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;有关此命令的影响描述正确的是?() A.每一个会话drop属于scott用户的表成功就会产生一条审计记录B.凡是每一个scott用户会话成功droptable操作，就会存在一条审计记录C.同一个scott会话中，drop一张或多张表成功就会产生一条审计记录D.scott用户授权给其它用户droptable权限时就会生成一条审计记录
在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的?()A、ALTER USER scott DEFAULT TABLESPACE data2_tsB、ALTER DEFAULT TABLESPACE data2_ts USER scottC、ALTER USER scott TABLESPACE DEFAULT data2_tsD、ALTER scott USER DEFAULT TABLESPACE data2_ts
在Oracle中，将当前系统所有角色都授予scott，除Payroll外，下列哪个是正确的?()A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT PayrollB、ALTER USER DEFAULT ROLLE ALL EXCEPT PayrollC、ALTER DEFAULT ROLLE ALL EXCEPT USER scottD、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll
当ORACLE9.2数据库服务器安装后,将自动创建两个具有超级权限的用户,并且要求设定这两个用户的口令,这两个用户是() A.SYSTEM和MANAGERB.SYS和SYSTEMC.SYS和SYSMAND.ROOT和SUPERMANE.SCOTT和TIGER