You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（

题目

You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

C. Data is never redacted for the EMP_V.SAL column.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

相似考题

1.How long() you() a member of the club?A.have,,joinedB.have,,beenC.has,,joinedD.has,,been

2.Why()the old block of flats()demolished next month?A、are…beingB、is…beingC、has…beenD、have…been

3.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

4.Where ________ you ________?A.are/beB.have/beC.is/beD.have/been

更多“You execute the following piece of code with appropriate privileges: User SCOTT has been g ”相关问题

  • 第1题：

    Whichfouraretrue?()

    A.Has-arelationshipsshouldneverbeencapsulated.

    B.Has-arelationshipsshouldbeimplementedusinginheritance.

    C.Has-arelationshipscanbeimplementedusinginstancevariables.

    D.Is-arelationshipscanbeimplementedusingtheextendskeyword.

    E.Is-arelationshipscanbeimplementedusingtheimplementskeyword.

    F.Anarrayoracollectioncanbeusedtoimplementaone-to-manyhas-arelationship.

    G.TherelationshipbetweenMovieandActressisanexampleofanis-arelationship.


    参考答案：C, D, E, F

  • 第2题：

    请选出创建用户ID是200，组ID是1000，用户主目录为/home/user01的新用户user01的正确命令.()

    A.adduser-u:200-g:1000-h:/home/user01user01

    B.adduser-u=200-g=1000-d=/home/user01user01

    C.useradd-u200-g1000-d/home/user01user01

    D.useradd-u200-g1000-h/home/user01user01


    正确答案：C

  • 第3题：

    Whichofthefollowingrolesprovidestheprivilegestomaintainandquerytherecoverycatalogschema?()

    A.EXECUTE_CATALOG_ROLE

    B.CONNECT

    C.RESOURCE

    D.RECOVERY_CATALOG_OWNER

    E.RECOVERY_CATALOG_USER


    参考答案：D

  • 第4题：

    出创建用户ID是200，组ID是1000，用户主目录为/home/user01的新用户user01的正确命令()

    A.adduser-u:200-g:1000-h:/home/user01user01

    B.adduser-u=200-g=1000-d=/home/user01user01

    C.useradd-u200-g1000-d/home/user01user01

    D.useradd-u200-g1000-h/home/user01user01


    正确答案：C

  • 第5题：

    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, D

  • 第6题：

    RADIUS协议中,CODE=1报文里可能携带的属性包括()。

    A.User-Name

    B.FrameD.Protocol

    C.FrameD.IP-Address

    D.Filter-ID


    参考答案：A, B, C

相关内容