You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? ()A. CREATE ROLL registrar; GRANT MODIFY ON student_grant TO r

题目
You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? ()

A. CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

B. CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3

C. CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3

D. CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;

E. CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

相似考题

1.Your little girl is becoming very rude. You ________ scold her.A.mayB.canC.ought toD.need

2.Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt－inscanyouuse?()A.CREATE_GROUPB.ADD_GROUP_NOWC.POPULATE_GROUPD.ADD_GROUP_COLUMNE.CREATE_GROUP_FROM_QUERY

3.______A．SET 价格='价格*1.03'B．Modify 价格='价格*1.03'C．SET 价格=价格*1.03D．Modify 价格=价格+1.03A．B．C．D．

4.May I take this book out of the reading room? No,you . You read it in here. ( )A. mightn’tB. won’tC. need’tD. mustn’t

更多“You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table. Which set of statements accomplishes this? () ”相关问题

  • 第1题：

    You‘re the systems administrator at Testing, and you create the following access control lists.You then enter the command "ip access-group 101 in" to apply access control list 101 to router TK1s e0 interface.Which of the following Telnet sessions will be blocked as a result of your access lists?（）

    A. Telnet sessions from host A to host 5.1.1.10

    B. Telnet sessions from host A to host 5.1.3.10

    C. Telnet sessions from host B to host 5.1.2.10

    D. Telnet sessions from host B to host 5.1.3.8

    E. Telnet sessions from host C to host 5.1.3.10

    F. Telnet sessions from host F to host 5.1.1.10


    参考答案：D, F

  • 第2题：

    下列哪个选项不符合RESTful设计？

    A．GET /users/1234

    B．GET /deleteUser/1234

    C．GET /users？role=admin

    D．GET /users？pageSize=25&pageStartIndex=50


    GET /deleteUser/1234

  • 第3题：

    你最好控制一下上网聊天的时间。（汉译英）

    A．You'd better set a limit for your online chat time.

    B．You'd better set a limit on your online chat time.

    C．You'd better set a limit on your online chatting time.

    D．You'd better set a limit for your online chatting time.


    You'd better set a limit on your online chatting time.

  • 第4题：

    5、下列哪个选项不符合RESTful设计？

    A．GET /users/1234

    B．GET /deleteUser/1234

    C．GET /users？role=admin

    D．GET /users？pageSize=25&pageStartIndex=50


    B

  • 第5题：

    以下对于列表的相关操作中哪些项有正确的输出结果？

    A.＞＞＞ language = list('PHP'); ＞＞＞ language[1:] = 'ython'; ＞＞＞ print(language) ['P', 'y', 't', 'h', 'o', 'n']#B.＞＞＞ print(list('Life is short, you need Python.').count('is')) 1#C.＞＞＞ x = [2, 3, 0, 4, 1] ＞＞＞ x.sort() ＞＞＞ print(x) [0, 1, 2, 3, 4]#D.＞＞＞ words = ['Life', 'is', 'short', 'you', 'need', 'Python'] ＞＞＞ words.index('you') 4
    ＞＞＞ language = list('PHP'); ＞＞＞ language[1:] = 'ython'; ＞＞＞ print language ['P', 'y', 't', 'h', 'o', 'n'];＞＞＞ x = [2, 3, 0, 4, 1]＞＞＞ x.sort()＞＞＞ print x[0, 1, 2, 3, 4]

  • 第6题：

    以下对于列表的相关操作中哪些项有正确的输出结果？

    A.＞＞＞ language = list('PHP'); ＞＞＞ language[1:] = 'ython'; ＞＞＞ print language ['P', 'y', 't', 'h', 'o', 'n']#B.＞＞＞ print list('Life is short, you need Python.').count('is') 1#C.＞＞＞ x = [2, 3, 0, 4, 1] ＞＞＞ x.sort() ＞＞＞ print x [0, 1, 2, 3, 4]#D.＞＞＞ words = ['Life', 'is', 'short', 'you', 'need', 'Python'] ＞＞＞ words.index('you') 4
    ＞＞＞ language = list('PHP'); ＞＞＞ language[1:] = 'ython'; ＞＞＞ print language ['P', 'y', 't', 'h', 'o', 'n'];＞＞＞ x = [2, 3, 0, 4, 1]＞＞＞ x.sort()＞＞＞ print x[0, 1, 2, 3, 4]

相关内容