单选题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?（）AThe set of statements contains an error and does not work.BIt 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.CIt 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.DIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.EIt creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.FIt creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
（ 38 ） SQL 的 DML 包括的语句有A ） ROLLBACK ， COMMITB ） CREATE ， DROP ， ALTERC ） GRANT ， REVOKED ） SELECT ， INSERT ， DELETE ， UPDATE
You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
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, user3B. CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C. CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D. 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;
SQL的DML包括的语句有______。A．ROLLBACK, COMMITB．CREATE, DROP, ALTERC．GRANT, REVOKED．SELECT, INSERT, DELETE, UPDATE
将表Emp的empname属性列的修改权限授予用户LIU，并允许LIU再将此权限转授其他人，实现的SQL语句是(48)。A．GRANT update on Emp TO LIU WITH CHECK OPTIONB．GRANT update(empname)on Emp TO LIU WITH CHECK OPTIONC．GRANT update on Emp TO LIU WITH GRANT OPTIOND．GRANT update(empname)on Emp TO LIU WITH GRANT OPTION
假设需要在数据库中创建角色test_role,可以使用如下()语句。 A.ALTER DATABASE ROLE test_roleB.CREATE ROLE test_roleC.UPDATE ROLE test_roleD.ALTER ROLE test_role
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.
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）A、MANAGER must be a role.B、It allows the MANAGER to pass the specified privileges on to other users.C、It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D、It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E、It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F、It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
下面哪些SQL命令向名为ACCTSUPER的用户授予系统权限（）A、GRANT INSERT ON emp TO acctsuperB、GRANT CREATE TABLE TO acctsuperC、GRANT SELECT ON emp TO acctsuperD、GRANT UPDATE ANY TABLE TO acctsuperE、GRANT CREATE SESSION TO acctsuper
SQL的DML包括的语句有（）。A、ROLLBACK，COMMITB、CREATE，DROP，ALTERC、GRANT，REVOKED、SELECT，INSERT，DELETE，UPDATE
把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是 （）A、GRANT GRADE ON SC TO ZHAOB、GRANT UPDATE ON SC TO ZHAOC、GRANT UPDATE (GRADE) ON SC TO ZHAOD、GRANT UPDATE ON SC (GRADE) TO ZHAO
假设需要在数据库中创建角色test_role，可以使用如下（）语句。A、ALTER DATABASE ROLE test_roleB、CREATE ROLE test_roleC、UPDATE ROLE test_roleD、ALTER ROLE test_role
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）A、GRANT select, insert, update ON student_grades TO managerB、GRANT select, insert, update ON student_grades TO ROLE managerC、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）A、grant CONNECT role to all of the three usersB、grant RESOURCE role to all of the three usersC、grant both CONNECT and RESOURCE role to all of the three usersD、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three usersE、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform?（）A、Create a database role named BankTerminals.B、Grant the BankTerminals role the Execute permission for the WoodgroveBanking database.C、Grant database access to the Windows Bank Terminals group， and add the group to the BankTerminals role.D、Grant the BankTerminals role the Execute permission for the Bank schema.E、Grant the Windows Bank Terminals group the Execute permission for the Bank schema.F、Grant the BankTerminals role the Execute permission for all stored procedures and user-defined functions in the Bank schema.
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）ACREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;BCREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;CGRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）ACREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;BCREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;CGRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
单选题You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.Which statement accomplishes this?（）AGRANT select, insert, update ON student_grades TO managerBGRANT select, insert, update ON student_grades TO ROLE managerCGRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;DGRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;EGRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;FGRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
单选题Examine the commands executed in the following sequence： 1：SQL CREATE ROLE mgrrole； 2：SQL GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL GRANT select，update ON sh.sales TO mgrrole； 4：SQL CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL GRANT ceo TO mgrrole； Which statement is true about the above commands（）AThe commands execute successfully.BCommand 6 produces an error because of circular role grant.CCommand 5 produces an error because a role cannot be granted to another role.DCommand 3 produces an error because the MGRROLE role already contains system privileges.EThe table created by HR remains and HR still has the CREATE TABLE system privilege.FThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL GRANT MGR_ROLE TO SKD WITH ADMIN OPTION； Which statement is true about the user SKD afterhe/she is granted this role（）A The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.B The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.C The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.D The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them
单选题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? （）AThe set of statements contains an error and does not work.BIt 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.CIt 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.DIt creates a role called REGISTRAR, adds the UPDATE privilege on the STUDENT_GRADES object to the role, and creates three users with the role.EIt creates a role called REGISTRAR, adds the UPDATE privilege on three users, and gives the REGISTRAR role to the STUDENT_GRADES object.FIt creates a role called STUDENT_GRADES, adds the UPDATE privilege on three users, and gives the UPDATE role to the registrar.
单选题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? （）ACREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3BCREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3CCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3DCREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;ECREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;
多选题Examine the code： CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ； CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ； CREATE OR REPLACE PROCEDURE app.chk_readwrite AUTHID CURRENT_USER IS ipchk STRING（30）； BEGIN IF sys_context（‘USERENV’，’ISDBA’）=’TRUE’ THEN DBMS_SESSION.SET_ROLE‘READWRITE’） ； ELSE DBMS_SESSION.SET_ROLE（‘READONLY’） ； END； / Which three statements correctly describe the Secure Application role definition？（）ANo user or application has to remember or hide a password.BIt prevents everyone except a true DBA session from acquiring the READWRITE role.Capp.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label.Dapp.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.
多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create tables that refer to the STUDENT_GRADES table.DIt allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.EIt allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.FIt allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.