A、INSERT INTO tab1 VALUES （0， ’a’）
B、INSERT INTO tab1 VALUES （NULL， ’abc’）
C、INSERT INTO tab1 VALUES （4， ’a’）
D、INSERT INTO tab1 VALUES （4， ’abcdefhijklmnopq’）
更多“ 如果使用下列语句创建TAB1<br /> <img src="https://nimg.ppkao.com/2018-09/tangxueping/2018091115373144572.jpg?sign=47f6e02009553272c10c9eb628b6acb7&t=62d51cde" /><br /> 下列哪个语句会将记录成功插入表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
A、SELECT UNIQUE * FROM tab1 B、SELECT DISTINCT * FROM tab1 C、SELECT UNIQUE（*） FROM tab1 D、SELECT DISTINCT（*） FROM tab1
A、A.GRANT ADD ON TABLE tab1 TO John B、B.GRANT INSERT ON tab1 TO John C、C.GRANT ADD ON TABLE tab1 TO USER John D、D.GRANT INSERT ON TABLE tab1 TO USER John
A、A.INSERT INTO tab1 SELECT cx, cy FROM tab2 B、B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy) C、C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2) D、D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
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
A、REVOKE SELECT FROM user2 ON TABLE org.tab1 B、REVOKE SELECT ON TABLE org.tab1 FROM user2 C、REVOKE READ ACCESS FROM user2 ON TABLE org.tab1 D、REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx B、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx C、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx D、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
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
客服
TOP
查看正确答案
