题目内容（请给出正确答案）

[主观题]

【C7】A．madeB．letC．sentD．urged

【C7】

A．made

B．let

C．sent

D．urged

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“【C7】A．madeB．letC．sentD．urged”相关的问题

第1题

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1？（）

A.REVOKE ADD, DELETE FROM USER tom ON TABLE tab1

B.REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

C.REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

D.REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

点击查看答案

第2题

Given the following statements:CREATE TABLE tab1 （col1 INT); CREATE TABLE tab2 （col1 INT);

Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query？ SELECT count(*) FROM tab2;（）

A.3

B.2

C.1

D.0

点击查看答案

第3题

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1？（）

A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

点击查看答案

第4题

Given the following two tables:TAB1 C1 C21 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX

CY5 Europe 6 North America 7 South AmericaWhich of the following SQL statements will insert all rows found in table TAB2 into table TAB1？（）

A.INSERT INTO tab1 SELECT cx, cy FROM tab2

B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)

D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

点击查看答案

第5题

你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。

A.CREATE TABLE tab1 OF myOBJ

B.CREATE TABLE myOBJ OF tab1

C.CREATE TABLE tab1 AS myOBJ

D.CREATE TABLE tab1 TYPE OF myOBJ

点击查看答案

第6题

If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1？（）

A.COL1 will accept NULL values and can be referenced in another table‘s foreign key specification.

B.COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.

C.COL1 will not accept NULL values and can be referenced in another tables foreign key specification.

D.COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.

点击查看答案

第7题

下面的语句按顺序成功执行后 CREATE TABLE tab1 （c1 CHAR（1)) INSERT INTO tab1 VALUES （'b') CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 ='a' INSERT INTO view1 VALUES （'a') INSERT INTO tab1 VALUES （'b') 执行SELECT

A．0

B．1

C．2

D．3

点击查看答案

第8题

Given the following two tables:TAB1 R1A A A B B C C D E TAB2 R2A A B B C C DWhich of the following queries returns the following result set？ RETVAL E（）

A.SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2

B.SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2

C.SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2

D.SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2

点击查看答案