网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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, 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)” 相关考题
考题
（ 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 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
考题
你定义了一个对象类型myOBJ,要基于该类型来创建表tab1,语句为()。
A.CREATE TABLE tab1 OF myOBJB.CREATE TABLE myOBJ OF tab1C.CREATE TABLE tab1 AS myOBJD.CREATE TABLE tab1 TYPE OF myOBJ
考题
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.
考题
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.
考题
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.
考题
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;
考题
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 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
考题
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.
考题
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
考题
单选题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.
考题
单选题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.
考题
单选题在下列查询语句中，与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*篮球*
考题
单选题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)
考题
单选题下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）A
GRANT ADD ON TABLE tab1 TO JohnB
GRANT INSERT ON tab1 TO JohnC
GRANT ADD ON TABLE tab1 TO USER JohnD
GRANT INSERT ON TABLE tab1 TO USER John
考题
单选题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_AB
TRIG_BC
TRIG_CD
TRIG_D
考题
单选题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
考题
单选题你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。A
CREATE TABLE tab1 OF myOBJB
CREATE TABLE myOBJ OF tab1C
CREATE TABLE tab1 AS myOBJD
CREATE TABLE tab1 TYPE OF myOBJ
考题
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.
考题
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command
考题
单选题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 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)
考题
单选题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;
热门标签
最新试卷
