Which object privileges can be granted on a view? ()A、noneB、DELETE, INSERT,SELECTC、ALTER, DELETE, INSERT, SELECTD、DELETE, 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

请把下划处的代码补充完整: ______ into student (s_name) ______(N’王大军’)A.update, valuesB.insert, valueC.insert, valuesD.delete, like

SQL语言的数据操纵语句包括:SELECT、INSERT、UPDATE和DELETE等。其中,最重要也是使用最频繁的语句是A.SELECTB.INSERTC.UPDATED.DELETE

用来插入数据的命令是( ),用于更新的命令是( )A.INSERT,UPDATEB.CREATE,INSERT INTOC.DELETE,UPDATED.UPDATE,INSERT

在下列的SQL语句中,属于数据控制语句的是哪些? Ⅰ.CREATE Ⅱ.SELECT Ⅲ.UPDATE Ⅳ.GRANT Ⅴ.DROP Ⅵ.DELETE Ⅶ.ALTER Ⅷ.INSERT Ⅸ.REVOKEA.Ⅰ、Ⅴ、Ⅵ和ⅦB.Ⅳ和ⅨC.Ⅱ、Ⅲ、Ⅵ和ⅧD.Ⅰ、Ⅴ和Ⅶ

SQL的数据更新功能主要包括INSERT、UPDATE和DELETE三个语句。()

在SQL中,对基本表进行插入和修改记录的命令为( )。 A、insert和deleteB、update和deleteC、delete和selectD、insert和update

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操作起作用

UPDATE、INSERT和DELETE都可引发触发器代码的执行。A对B错

在ADO.NET中,DataAdpter对象使用下列哪个Command属性从数据源中删除记录?()A、Insert CommandB、Update CommandC、Select CommandD、Delete Command

用来插入数据、更新的命令分别是()。A、DELETE,UPDATEB、INSERT,UPDATEC、CREATE,INSERT INTOD、UPDATE,INSERT

功能最强也是最复杂的SQL语句是()。A、Insert语句B、Select语句C、Update语句D、Delete语句

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语句

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

删除存储过程使用的语句是()A、ALTER PROCEDUREB、DROP PROCEDUREC、INSERT PROCEDUED、DELETE PROCEDUE

单选题Which object privileges can be granted on a view? ()AnoneBDELETE, INSERT,SELECTCALTER, DELETE, INSERT, SELECTDDELETE, INSERT, SELECT, UPDATE