单选题Which object privileges can be granted on a view? ()AnoneBDELETE, INSERT,SELECTCALTER, DELETE, INSERT, SELECTDDELETE, INSERT, SELECT, UPDATE
单选题
Which object privileges can be granted on a view? ()
A
none
B
DELETE, INSERT,SELECT
C
ALTER, DELETE, INSERT, SELECT
D
DELETE, INSERT, SELECT, UPDATE
参考解析
解析:
暂无解析
相关考题:
SQL语言的数据操纵语言包括SELECT,INSERT,UPDATE和DELETE等,其中最重要的也是使用最频繁的语句是()。 A.SELECTB.INSERTC.UPDATED.DELETE
( 38 ) SQL 的 DML 包括的语句有A ) ROLLBACK , COMMITB ) CREATE , DROP , ALTERC ) GRANT , REVOKED ) SELECT , INSERT , DELETE , UPDATE
在下列的SQL语句中,属于数据控制语句的是哪些? Ⅰ.CREATE Ⅱ.SELECT Ⅲ.UPDATE Ⅳ.GRANT Ⅴ.DROP Ⅵ.DELETE Ⅶ.ALTER Ⅷ.INSERT Ⅸ.REVOKEA.Ⅰ、Ⅴ、Ⅵ和ⅦB.Ⅳ和ⅨC.Ⅱ、Ⅲ、Ⅵ和ⅧD.Ⅰ、Ⅴ和Ⅶ
Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH 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的DML包括的语句有______。A.ROLLBACK, COMMITB.CREATE, DROP, ALTERC.GRANT, REVOKED.SELECT, INSERT, DELETE, UPDATE
在下列的SQL语句中,属于数据控制语句的是( )。Ⅰ.CREATEⅡ.SELECTⅢ.UPDATEⅣ.GRANTⅤ.DROPⅥ.DELETEⅦ.ALTERⅧ.INSERTⅨ.REVOKEA.Ⅰ、Ⅴ、Ⅵ、ⅦB.Ⅳ、ⅨC.Ⅱ、Ⅲ、Ⅵ、ⅧD.Ⅰ、Ⅴ、Ⅶ
SQL语言的数据操纵语句包括SELECT、INSERT、UPDATE、DELETE等。其中最重要的,也是使用最频繁的语句是( ) 。A. SELECT B. INSERTC. UPDATE D. DELETE
SQL语言的数据操纵语句包括SELECT,INSERT,UPDATE和DELETE等。其中最重要的,也是使用最频繁的语句是______。A.SELECTB.INSERTC.UPDATED.DELETE
下列的SQL语句中,属于数据控制语句的是______。Ⅰ.CREATEⅡ.SELECTⅢ.UPDATEⅣ.GRANTⅤ.DROPⅥ.DELETEⅦ.ALTERⅧ.INSERTⅨ.REVOKEA.Ⅰ、Ⅴ、Ⅵ和ⅦB.Ⅳ和ⅨC.Ⅱ、Ⅲ、Ⅵ和ⅧD.Ⅰ、Ⅴ和Ⅶ
INFORMIX的环境下,下边描述不正确的有:()。 A.在对表进行INSERT、DELETE或UPDATE操作时,可以定义一些触发器使数据库服务器自动调用存储过程(或SQL语句)B.触发器只对操作员进行INSERT、DELETE或UPDATE操作起作用C.触发器是一种特殊类型的存储过程,它在INSERT、DELETE或UPDATE特定表中数据时起作用D.触发器只对程序进行INSERT、DELETE或UPDATE操作起作用
SQL语言的数据操作语句包括SELECT、INSERT、UPDATE和DELETE等。其中最重要的,也是使用最频繁的语句是()A、SELECTB、INSERTC、UPDATED、DELETE
SQL的DML包括的语句有()。A、ROLLBACK,COMMITB、CREATE,DROP,ALTERC、GRANT,REVOKED、SELECT,INSERT,DELETE,UPDATE
关于HQL与SQL,以下说法正确的是()A、HQL与SQL没什么差别B、HQL面向对象,而SQL操纵关系数据库C、在HQL与SQL中,都包含select,insert,update,delete语句D、HQL仅用于查询数据,不支持insert,update和delete语句
Which object privileges can be granted on a view? ()A、noneB、DELETE, INSERT,SELECTC、ALTER, DELETE, INSERT, SELECTD、DELETE, INSERT, SELECT, UPDATE
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 execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?()A、INSERT B、SELECT C、UPDATE D、DELETE
单选题You execute the following commands to audit database activities: SQL ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?()AOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.BOne audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.COne audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.DOne audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.EOne audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
单选题Which object privileges can be granted on a view? ()AnoneBDELETE, INSERT,SELECTCALTER, DELETE, INSERT, SELECTDDELETE, INSERT, SELECT, UPDATE
单选题关于HQL与SQL,以下说法正确的是()AHQL与SQL没什么差别BHQL面向对象,而SQL操纵关系数据库C在HQL与SQL中,都包含select,insert,update,delete语句DHQL仅用于查询数据,不支持insert,update和delete语句
单选题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;