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 op

题目

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）
相似考题

1.（ 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" 篮球 *"

2.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

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

4.在下列查询语句中，与 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 "篮球*"

更多“Table TAB1 was ”相关问题

  • 第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


    参考答案：C

  • 第2题：

    tr的英文全称是（）。

    • A、table row
    • B、table date
    • C、table header
    • D、table

    正确答案:A

  • 第3题：

    If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）

    • A、COL1 will accept NULL values and can be referenced in another table's foreign key specification.
    • B、COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.
    • C、COL1 will not accept NULL values and can be referenced in another tables foreign key specification.
    • D、COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.

    正确答案:C

  • 第4题：

    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

    正确答案:D

  • 第5题：

    Which action(s) will cause a compression dictionary to be removed from a table?（）

    • A、Set the table COMPRESS attribute to NO.  
    • B、Set the table COMPRESS attribute to NO; run REORG against the table.  
    • C、Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table.  
    • D、Set the table COMPRESS attribute to NO; run RUNSTATS against the table.

    正确答案:B

  • 第6题：

    单选题
    If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）
    A

    COL1 will accept NULL values and can be referenced in another table's foreign key specification.

    B

    COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.

    C

    COL1 will not accept NULL values and can be referenced in another tables foreign key specification.

    D

    COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    在下列查询语句中，与SELECT TAB1.* 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*篮球*


    正确答案： D
    解析：
    InStr（String1，String2）函数返回一个整数，该整数指定第二个字符串String2在第一个字符串String1中的第一个匹配项的起始位置。此题中表示的是“篮球”在“简历”字段中出现的位置，即简历中包含篮球两个字的记录，C项正确。

  • 第8题：

    单选题
    下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）
    A

    GRANT ADD ON TABLE tab1 TO John

    B

    GRANT INSERT ON tab1 TO John

    C

    GRANT ADD ON TABLE tab1 TO USER John

    D

    GRANT INSERT ON TABLE tab1 TO USER John


    正确答案： D
    解析： 暂无解析

  • 第9题：

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

    B

    GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

    C

    GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

    D

    GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）
    A

    ALTER TABLE SPLIT PARTITION

    B

    ALTER TABLE MERGE PARTITION

    C

    ALTER TABLE TRUNCATE PARTITION

    D

    ALTER TABLE ADD PARTITION

    E

    ALTER TABLE DROP PARTITION

    F

    ALTER TABLE MOVE PARTITION


    正确答案： A,C
    解析： 暂无解析

  • 第11题：

    多选题
    Which two operations can be performed on an external table（）
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command


    正确答案： E,F
    解析： 暂无解析

  • 第12题：

    单选题
    Which syntax turns an existing constraint on?（）
    A

    ALTER TABLE table_name   ENABLE constraint_name;

    B

    ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;

    C

    ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;

    D

    ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;

    E

    ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;


    正确答案： B
    解析： 暂无解析

  • 第13题：

    In what location are EIGRP successor routes stored?()

    A. In the routing table only.

    B. In the neighbor table only.

    C. In the topology table only.

    D. In the routing table and neighbor table.

    E. In the routing table and topology table.

    F. In the topology table and neighbor table.


    参考答案：E

  • 第14题：

    In what location are EIGRP successor routes stored?（）

    • A、In the routing table only.
    • B、In the neighbor table only.
    • C、In the topology table only.
    • D、In the routing table and neighbor table.
    • E、In the routing table and topology table.
    • F、In the topology table and neighbor table.

    正确答案:E

  • 第15题：

    Which syntax turns an existing constraint on?（）

    • A、ALTER TABLE table_name   ENABLE constraint_name;
    • B、ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;
    • C、ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;
    • D、ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;
    • E、ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;

    正确答案:C

  • 第16题：

    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

  • 第17题：

    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

    正确答案:D

  • 第18题：

    单选题
    In what location are EIGRP successor routes stored?（）
    A

    In the routing table only.

    B

    In the neighbor table only.

    C

    In the topology table only.

    D

    In the routing table and neighbor table.

    E

    In the routing table and topology table.

    F

    In the topology table and neighbor table.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）
    A

    TRIG_A

    B

    TRIG_B

    C

    TRIG_C

    D

    TRIG_D


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    你定义了一个对象类型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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    Which two operations can be performed on an external table（）
    A

    Create a view on the table.

    B

    Create an index on the table.

    C

    Create a synonym on the table.

    D

    Add a virtual column to the table.

    E

    Update the table using the UPDATE statement.

    F

    Delete rows in the table using the DELETE command.


    正确答案： F,B
    解析： 暂无解析

  • 第23题：

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

    INSERT INTO tab1 SELECT cx, cy FROM tab2

    B

    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)


    正确答案： B
    解析： 暂无解析

相关内容