搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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）

查看正确答案
更多“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? （）”相关的问题
第1题
[单选题] 你定义了一个对象类型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  

点击查看答案
第2题
[单选题] 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  

点击查看答案
第3题
[单选题] 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  

点击查看答案
第4题
[] Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

A、A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp  B、B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1  C、C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp  D、D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom  

点击查看答案
第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题
[单选题] 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)  

点击查看答案
第7题
[] 下列哪个语句将赋予用户John向表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  

点击查看答案
第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;（） 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  

点击查看答案
第9题
[单选题] TabHost.newTabSpec（"tab1"）（）。

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

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

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