下面的语句按顺序成功执行后 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 c1 FROM tab1可以选择出多少条记录？（）A．0B．1C．2D．3
下面的语句按顺序成功执行后 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 c1 FROM tab1可以选择出多少条记录？（）
A．0
B．1
C．2
D．3
参考答案和解析
5
相关考题：
（ 22 ）在下列查询语句中，与SELECT TABL* FROM TAB1 WHERE InStr([ 简历 ]," 篮球 ")0功能相同的语句是（ ） 。A ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like" 篮球 "B ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like"* 篮球 "C ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like"* 篮球 *"D ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like" 篮球 *"
在下列查询语句中，与 SELECTTAB1．*FROM TABl WHERE InStr([简历],"篮球")＜＞0 功能相同的语句是______。A．SELECT TAB1．*FROM TAB1 WHERE TAB1．简历Like "篮球"B．SELECT TAB1．*FROM TAB1 WHERE TAB1．简历Like "*篮球"C．SELECT TAB1．*FROM TAB1 WHERE TAB1．简历Like "*篮球*"D．SELECT TAB1．*FROM TAB1 WHERE TAB1．简历Like "篮球*"
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 appgrpB.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpD.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3
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.3B.2C.1D.0
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 tab2B.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)
你定义了一个对象类型myOBJ,要基于该类型来创建表tab1,语句为()。 A.CREATE TABLE tab1 OF myOBJB.CREATE TABLE myOBJ OF tab1C.CREATE TABLE tab1 AS myOBJD.CREATE TABLE tab1 TYPE OF myOBJ
客服业务受到SQL语句的影响非常大，以下哪些是执行效率比较低的SQL语句，可以进行优化（）A、select*from record where substrb（CardNo，1，4）=’5378’；B、表tab1中的列col1是字符型（char），执行select col1，col2 from tab1 where col1’10’；C、select count（*）from stuff where id_no in（’0’，’1’）；D、UPDATE SERVICEINFO SET STATE=0WHERE STATE0。
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)
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）
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 tab1B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
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 tab2B、SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2C、SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2D、SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval 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、3B、2C、1D、0
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=cxB、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxC、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxD、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。A、CREATE TABLE tab1 OF myOBJB、CREATE TABLE myOBJ OF tab1C、CREATE TABLE tab1 AS myOBJD、CREATE TABLE tab1 TYPE OF myOBJ
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）A、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);B、INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, 'ename', 'jobid', 2000, NULL, did IN (20,50));C、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);D、INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);E、INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, ename','jobid', 2000, NULL, did);
单选题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?（）AINSERT INTO tab1 SELECT cx, cy FROM tab2BINSERT INTO tab1 VALUES (tab2.cx, tab2.cy)CINSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)DINSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
单选题在下列查询语句中，与SELECT TAB1.* FROM TAB1 WHERE InStr（[简历，“篮球”）0功能等价的语句是（ ）。ASELECT TAB1.* FROM TAB1 WHERE TAB1.简历Like篮球BSELECT TAB1.* FROM TAB1 WHERE TAB1.简历Like*篮球CSELECT TAB1.* FROM TAB1 WHERE TAB1.简历Like*篮球*DSELECT TAB1.* FROM TAB1 WHERE TAB1.简历Like*篮球*
单选题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（）ASELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2BSELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2CSELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2DSELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
单选题Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）A0B1C2D3
单选题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?（）ACREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) BCREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) CCREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) DCREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
单选题下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）AGRANT ADD ON TABLE tab1 TO JohnBGRANT INSERT ON tab1 TO JohnCGRANT ADD ON TABLE tab1 TO USER JohnDGRANT INSERT ON TABLE tab1 TO USER John
单选题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?（）ASELECT * FROM tab1 INNER JOIN tab2 ON c1=cxBSELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxCSELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxDSELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
单选题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）AGRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpBGRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1CGRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrpDGRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
单选题你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。ACREATE TABLE tab1 OF myOBJBCREATE TABLE myOBJ OF tab1CCREATE TABLE tab1 AS myOBJDCREATE TABLE tab1 TYPE OF myOBJ
单选题Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）AREVOKE ADD, DELETE FROM USER tom ON TABLE tab1BREVOKE ADD, DELETE ON TABLE tab1 FROM USER tomCREVOKE INSERT, DELETE FROM USER tom ON TABLE tab1DREVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
单选题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?（）AINSERT INTO tab1 SELECT cx, cy FROM tab2BINSERT INTO tab1 VALUES (tab2.cx, tab2.cy)CINSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)DINSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)