Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）A、The set of statements contains an error and does not work.B、It creates a rol

题目

Examine these statements: CREATE ROLE registrar GRANT UPDATE ON dtudent_grades TO registrar; GRANT registrar to user1, user2, user3; What does this set of SQL statements do? （）

A、The set of statements contains an error and does not work.
B、It creates a role called REGISTRAR, adds the MODIFY privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
C、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and gives the REGISTRAR role to three users.
D、It creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.
E、It creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.
F、It creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.

参考答案和解析

正确答案:C

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Examine the SQL statements that creates ORDERS table:For which columns would an index be automatically created when you execute the above SQL statement? ()

A. SER_NO

B. ORDER_ID

C. STATUS

D. PROD_ID

E. ORD_TOTAL

F. Composite index on ORDER_ID and ORDER_DATE

参考答案：A, F

第2题：

Word processing software is used to creat edit,save and print (74)

A.photos

B.graphics

C.documents

D.spreadsheets

正确答案：C
文字处理软件用于建立、编辑、保存和打印文档。

第3题：

Examine the structure of the EMPLOYEES table:You issue these statements:At the end of this transaction, what is true?()

A. You have no rows in the table.

B. You have an employee with the name of James.

C. You cannot roll back to the same savepoint more than once.

D. Your last update fails to update any rows because employee ID 180 was already eleted.

参考答案：A

第4题：

每个系统的Creat Recovery media可以创建几套挽救介质（）

A、1
B、2
C、3
D、多次

正确答案:D

第5题：

SQL语句建索引的语句是（）

A、CREA TETABLE
B、CREA TEVIEW
C、CREAT EINDEX
D、ALTER TABLE

正确答案:D

第6题：

SQL命令中建立表的命令是______。

A．CREAT VIEW

B．CREAT LABEL

C．CREAT DABATE

D．CREAT TABLE

正确答案：D

第7题：

在Cisco路由器中增加用户的命令，错误的是（）。

A、creat user
B、adduser
C、useradd
D、user…password
E、user creat

正确答案:A,B,C,E

第8题：

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()