[单选]
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.

You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about theeffect of the command（） No flashback is possible to bring back the ITEM table.。 The ORDERS table is dropped along with the ITEM table.。 The dependent referential integrity constraints in the ORDERS table are disabled.。 The dependent referential integrity constraints in the ORDERS table are removed.。 The table definition of the ITEM table and associated indexes are placed in the recycle bi。何杰报告中强调教学法的运用，要了解学生的思维，（），倾听学生的声音，爱护学生的好奇心和求知欲是我们研究学生的基本出发点。 In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（） Oracle Migration Assistant。 Recovery Manager （RMAN）。 Oracle Data Pump Export and Import。 conventional Oracle Export and Import。 operating system utilities to copy the files to the ASM instance。铁路建设工程监理的主要依据是（）。国家有关法律、法规及铁道部有关规章、制度；国家和铁道部有关标准、规范、规程。国家和铁道部对本项目的批复文件。审核合格的施工图\本工程项目的委托监理合同、承包合同和材料设备供应合同。以上各项。 An administrator will be performing a PowerHA upgrade on a cluster from version 5.3 to version 5.5. Which ofthe following tasks will verify a successful migration？（） Use the clstat command and verify the cluster is in a stable state。 After each node is upgraded， run a verification and synchronization。 After all nodes are upgraded， run a verification and synchronization。 Take a snapshot of each node and verify the configuration is the same。

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? （）

参考答案：

● 参考解析

本题暂无解析

当前位置：数控车工综合练习题库

[单选] 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? （）

相关题目:

[单选]
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? （）