单选题Which object privileges can be granted on a view? （）A noneB DELETE, INSERT,SELECTC ALTER, DELETE, INSERT, SELECTD DELETE, INSERT, SELECT, UPDATE
题目
none
DELETE, INSERT,SELECT
ALTER, DELETE, INSERT, SELECT
DELETE, INSERT, SELECT, UPDATE
相似考题
更多“单选题Which object privileges can be granted on a view? （）A noneB DELETE, INSERT,SELECTC ALTER, DELETE, INSERT, SELECTD DELETE, INSERT, SELECT, UPDATE”相关问题
-
第1题：
在下列的SQL语句中，属于数据控制语句的是哪些? Ⅰ．CREATE Ⅱ．SELECT Ⅲ．UPDATE Ⅳ．GRANT Ⅴ．DROP Ⅵ．DELETE Ⅶ．ALTER Ⅷ．INSERT Ⅸ．REVOKE
A．Ⅰ、Ⅴ、Ⅵ和Ⅶ
B．Ⅳ和Ⅸ
C．Ⅱ、Ⅲ、Ⅵ和Ⅷ
D．Ⅰ、Ⅴ和Ⅶ
正确答案：B
解析：CREATE是建立基本表，属于定义语句。SELECT是查询、UPDATE是数据更新、DROP是把做删除标记的记录删除、DELETE是删除、ALTER是修改、INSERT是插入，这些属于数据操纵功能。GRANT和 REVOKE是授予和回收权限，属于数据控制语句。 -
第2题：
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.
参考答案：B, E
-
第3题：
在下列的SQL语句中，属于数据控制语句的是( )。
Ⅰ．CREATE
Ⅱ．SELECT
Ⅲ．UPDATE
Ⅳ．GRANT
Ⅴ．DROP
Ⅵ．DELETE
Ⅶ．ALTER
Ⅷ．INSERT
Ⅸ．REVOKE
A．Ⅰ、Ⅴ、Ⅵ、Ⅶ
B．Ⅳ、Ⅸ
C．Ⅱ、Ⅲ、Ⅵ、Ⅷ
D．Ⅰ、Ⅴ、Ⅶ
正确答案：B
-
第4题：
SQL语言的数据操纵语句包括SELECT，INSERT，UPDATE和DELETE等。其中最重要的，也是使用最频繁的语句是______。
A．SELECT
B．INSERT
C．UPDATE
D．DELETE
正确答案：A
-
第5题：
INFORMIX的环境下,下边描述不正确的有:()。A.在对表进行INSERT、DELETE或UPDATE操作时，可以定义一些触发器使数据库服务器自动调用存储过程（或SQL语句）
B.触发器只对操作员进行INSERT、DELETE或UPDATE操作起作用
C.触发器是一种特殊类型的存储过程，它在INSERT、DELETE或UPDATE特定表中数据时起作用
D.触发器只对程序进行INSERT、DELETE或UPDATE操作起作用
参考答案：B, D
-
第6题：
用来插入数据、更新的命令分别是（）。
- A、DELETE，UPDATE
- B、INSERT，UPDATE
- C、CREATE，INSERT INTO
- D、UPDATE，INSERT
正确答案:B -
第7题：
SQL语言的数据操作语句包括SELECT、INSERT、UPDATE和DELETE等。其中最重要的，也是使用最频繁的语句是（）
- A、SELECT
- B、INSERT
- C、UPDATE
- D、DELETE
正确答案:A -
第8题：
关于HQL与SQL，以下说法正确的是（）
- A、HQL与SQL没什么差别
- B、HQL面向对象，而SQL操纵关系数据库
- C、在HQL与SQL中，都包含select，insert，update，delete语句
- D、HQL仅用于查询数据，不支持insert，update和delete语句
正确答案:B -
第9题：
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 manager
- B、GRANT select, insert, update ON student_grades TO ROLE manager
- C、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;
正确答案:D -
第10题：
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
正确答案:B -
第11题：
单选题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.
正确答案： C解析： 暂无解析 -
第12题：
单选题关于HQL与SQL，以下说法正确的是（）AHQL与SQL没什么差别
BHQL面向对象，而SQL操纵关系数据库
C在HQL与SQL中，都包含select，insert，update，delete语句
DHQL仅用于查询数据，不支持insert，update和delete语句
正确答案： A解析： 暂无解析 -
第13题：
在SQL中,对基本表进行插入和修改记录的命令为( )。A、insert和delete
B、update和delete
C、delete和select
D、insert和update
参考答案:D
-
第14题：
SQL的DML包括的语句有______。
A．ROLLBACK, COMMIT
B．CREATE, DROP, ALTER
C．GRANT, REVOKE
D．SELECT, INSERT, DELETE, UPDATE
正确答案：D
解析：SQL语言的数据操纵(DML)功能包括SELECT、INSERT、DELETE和UPDATE四个语句，即查询和修改(包括插入、删除、更新)两部分功能。 -
第15题：
SQL语言的数据操纵语句包括SELECT、INSERT、UPDATE、DELETE等。其中最重要的，也是使用最频繁的语句是（ ） 。
A. SELECT B. INSERT
C. UPDATE D. DELETE
正确答案：
-
第16题：
下列的SQL语句中，属于数据控制语句的是______。
Ⅰ．CREATE
Ⅱ．SELECT
Ⅲ．UPDATE
Ⅳ．GRANT
Ⅴ．DROP
Ⅵ．DELETE
Ⅶ．ALTER
Ⅷ．INSERT
Ⅸ．REVOKE
A．Ⅰ、Ⅴ、Ⅵ和Ⅶ
B．Ⅳ和Ⅸ
C．Ⅱ、Ⅲ、Ⅵ和Ⅷ
D．Ⅰ、Ⅴ和Ⅶ
正确答案：B
-
第17题：
UPDATE、INSERT和DELETE都可引发触发器代码的执行。
A对
B错
对
略 -
第18题：
功能最强也是最复杂的SQL语句是（）。
- A、Insert语句
- B、Select语句
- C、Update语句
- D、Delete语句
正确答案:B -
第19题：
SQL的DML包括的语句有（）。
- A、ROLLBACK，COMMIT
- B、CREATE，DROP，ALTER
- C、GRANT，REVOKE
- D、SELECT，INSERT，DELETE，UPDATE
正确答案:D -
第20题：
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
正确答案:D -
第21题：
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.
正确答案:A -
第22题：
删除存储过程使用的语句是（）
- A、ALTER PROCEDURE
- B、DROP PROCEDURE
- C、INSERT PROCEDUE
- D、DELETE PROCEDUE
正确答案:B -
第23题：
单选题Which object privileges can be granted on a view? （）Anone
BDELETE, INSERT,SELECT
CALTER, DELETE, INSERT, SELECT
DDELETE, INSERT, SELECT, UPDATE
正确答案： B解析： 暂无解析 -
第24题：
单选题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 manager
BGRANT select, insert, update ON student_grades TO ROLE manager
CGRANT 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;
正确答案： E解析： 暂无解析