在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

相似考题

1.在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）A.ALTER PROFILE USER scott otherprofileB.ALTER otherprofile USER scottPROFILEC.ALTER USER scott PROFILE otherprofileD.ALTER scott USER PROFILE otherprofile

2.Youwanttoenabletheuser，Scott，tochangetotheGRP1consumergroupbyissuingthefollowingcode：SQL>EXECDBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP（’SCOTT’，’GRP1’，FALSE）；Howwillyougranttheswitchprivilegetotheuser，Scott？（）A.byusingtheDBMS_SESSIONpackageB.bygrantingtheDBAroleC.byusingtheDBMS_RESOURCE_MANAGERpackageD.byusingtheDBMS_RESOURCE_MANAGER_PRIVSpackage

3.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.

4.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.

参考答案和解析
正确答案：A
更多“在Oracle中,用ALTER将scott的口令改为hello,下列哪个是正确的?( )A.ALTER USER scott IDENTI ”相关问题

  • 第1题：

    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.


    参考答案：D

  • 第2题：

    在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的?()

    A、ALTER USER scott DEFAULT TABLESPACE data2_ts

    B、ALTER DEFAULT TABLESPACE data2_ts USER scott

    C、ALTER USER scott TABLESPACE DEFAULT data2_ts

    D、ALTER scott USER DEFAULT TABLESPACE data2_ts


    本题答案：A

  • 第3题：

    当ORACLE9.2数据库服务器安装后,将自动创建两个具有超级权限的用户,并且要求设定这两个用户的口令,这两个用户是()

    A.SYSTEM和MANAGER

    B.SYS和SYSTEM

    C.SYS和SYSMAN

    D.ROOT和SUPERMAN

    E.SCOTT和TIGER


    参考答案：B

  • 第4题：

    在oracle数据库下,在启用审计的数据库上执行下面的命令SQL>AUDITDROPANYTABLEBYscottBYSESSIONWHENEVERSUCCESSFUL;有关此命令的影响描述正确的是?()

    A.每一个会话drop属于scott用户的表成功就会产生一条审计记录

    B.凡是每一个scott用户会话成功droptable操作，就会存在一条审计记录

    C.同一个scott会话中，drop一张或多张表成功就会产生一条审计记录

    D.scott用户授权给其它用户droptable权限时就会生成一条审计记录


    参考答案：C

  • 第5题：

    在Oracle中，将当前系统所有角色都授予scott，除Payroll外，下列哪个是正确的?()

    A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT Payroll

    B、ALTER USER DEFAULT ROLLE ALL EXCEPT Payroll

    C、ALTER DEFAULT ROLLE ALL EXCEPT USER scott

    D、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll


    参考答案：D

相关内容