搜题

【单选题】

SELECT*FROMLOGIN_TABLEWHERE USERNAME=‘SUPERADM’的含义是：（）。

A、显示表LOGIN_TABLE的所有USERNAME等于SUPERADM的所有记录的所有字段的信息

B、显示表USERNAME的所有LOGIN_TABLE等于SUPERADM的所有记录的所有字段的信息

C、显示表LOGIN_TABLE的所有记录的所有字段的信息

D、显示表LOGIN_TABLE的所有USERNAME等于SUPERADM的所有记录的字段USERNAME的信息

查看正确答案

更多“SELECT*FROMLOGIN_TABLEWHERE USERNAME=‘SUPERADM’的含义是：（）。”相关的问题

第1题

[单选题] Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which 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

点击查看答案

第2题

[单选题] 给定下列表：下列哪一个语句会产生所需结果？（）

A、SELECT UNIQUE * FROM tab1 B、SELECT DISTINCT * FROM tab1 C、SELECT UNIQUE（*） FROM tab1 D、SELECT DISTINCT（*） FROM tab1

点击查看答案

第3题

[单选题] Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）

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

点击查看答案

第4题

[单选题] 给定下列两个表：（）。

A、SELECT * FROM tab1 INNER JOIN tab2 ON col_1 = col_a B、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 = col_a C、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 = col_a D、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 = col_a

点击查看答案

第5题

[] Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（） Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）

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)

点击查看答案

第6题

[单选题] Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）

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

点击查看答案

第7题

[] 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;（） 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、A.3 B、B.2 C、C.1 D、D.0

点击查看答案

第8题

[单选题] 在Windows95中，应用程序窗口间的切换可按（）键。

A、<tab><tab><tab><ALT>+<TAB> B、<TAB> C、<CTRL>+<TAB> tab>tab>tab> D、<tab><tab><tab><ESC> tab>tab>tab>

点击查看答案

第9题

[单选题] TabHost.newTabSpec（"tab1"）（）。

A、为tab页创建标题为tab1 B、为tab页创建ID为tab1 C、为tab页创建内容 D、为tab页创建新空格

点击查看答案

账号：登录

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服