违法和不良信息举报 联系客服
免费注册 登录

单选题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

题目
单选题
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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

表达式for（i<-1to3；for（j<-1to3；ifi!=j）print（（10*i+j））+""输出结果正确的是？（）

  • A、11；12；13；21；22；23；31；32；33
  • B、11；13；21；23；31；33
  • C、12；13；21；23；31；32
  • D、11；12；21；22；31；32

正确答案:C

第2题：

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）

  • A、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)
  • B、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1);  CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2) 
  • C、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)
  • D、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）

正确答案:A

第3题：

Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()

A.SELECT * FROM t1 UNION SELECT * FROM t2

B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

C.SELECT * FROM t1 INTERSECT SELECT * FROM t2

D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)


参考答案：C

第4题：

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

正确答案:B

第5题：

Which of the following ports is the default telnet port?（）

  • A、20
  • B、21
  • C、22
  • D、23

正确答案:D

第6题：

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）

  • A、CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)  
  • B、CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) 
  • C、CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)  
  • D、CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)

正确答案:B

第7题：

Which of the following is the default port for telnet？（）

  • A、20
  • B、21
  • C、22
  • D、23

正确答案:D

第8题：

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


参考答案：D

第9题：

Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）

  • A、SELECT * FROM T1 MINUS SELECT * FROM T2
  • B、SELECT * FROM T1 EXCEPT SELECT * FROM T2
  • C、SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
  • D、SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

正确答案:B

第10题：

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）

  • A、SELECT * FROM t1 UNION SELECT * FROM t2
  • B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
  • C、SELECT * FROM t1 INTERSECT SELECT * FROM t2
  • D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

正确答案:B

更多相关问题
相关内容