网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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)” 相关考题
考题
下面程序的运行结果是【】。 inChlde using namespace std; class count { static int n;
下面程序的运行结果是【 】。inChlde＜iOStream＞using namespace std；class count{static int n；public：count(){n++；}static int test(){for(int i=0：i＜4；i++)n++；return n；}}；int count::n=0；int main(){cout＜＜COUnt::test()＜＜" "；count c1, c2;cout＜＜count::test()＜＜end1;return 0;}
考题
以下语句错误的是( )A. alter table emp delete column addcolumn;B. alter table emp modify column addcolumn char(10);C.alter table emp change addcolumn addcolumn int;D. alter table emp add column addcolumn int;
考题
以下选项中不能正确把c1定义成结构体变量的是A．typedef struct {int red: int green: int blue; } COLOR; COLOR c1;B．struct color c1 {int red int green: int blue; };C．struct color {int red , int green : int blue : )cl;D．struct {int red; int green; int blue } c1 ;
考题
Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）A.B.C.D.
考题
以下选项中不能正确把c1定义成结构体变量的是A．typedef struct { int red； int green；； int blue； }COLOR； COLOR cl；B．struct color cl { int red； int green； int blue； };C．struet color { int red； int green； int blue； }c1；D．struct { int red； int green； int blue； }cl；
考题
请说出该程序段的功能。declare @e numeric(5,2)declare @ c1 int, @ c2 int, @ c3 int, @ c4 intset @ c1=0; set @ c2 =0; set @ c3=0; set @ c4=0declare xxx cursorfor select 成绩 from scoreopen xxxfetch xxx into @ cwhile @'@ fetch_status = 0beginif(@c ＞ =90) set @cl =@ e1 +1;else if( @ c ＞ =70) set @ c2 =@ c2 +1;else if(@ c＞ =60) set @ c3 =@ c3 +1;else set @ c4 = @ c4 + 1fetch from xxx into @ cendclose xxxdeallocate xxxprint 优秀生人数：'+sb(@ c1，5)；print食好生人数：'+str(@ c2，5)；print及格生人数：'+str(@ c3，5)；print及格生人数：'+sh(@ c4，5)
考题
以下选项中能正确把c1定义成结构体变量的是( )。A．typedef struct { int red； int red； int green； int blue； }COLOR； COLOR c1；B．struct color c1 { int red int red； int green int blue； }；C．stmctcolor { int red， int green； int blue； }c1；D．struct { int red； int green； int blue； }c1；
考题
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB.DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC.CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD.CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
考题
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
考题
TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab1(c1INT,c2INT,c3INT,c4INT,c5INT);IfcolumnC1isuniqueandqueriestypicallyaccesscolumnsC1andC2together,whichstatement(s)willcreateindex(es)thatwillprovideoptimalqueryperformance?（）A.CREATEUNIQUEINDEXxtab1ONtab1(c1)include(c2)B.CREATEUNIQUEINDEXxtab1ONtab1(c1);CREATEINDEXxtab2ONtab1(c3)INCLUDE(c2)C.CREATEUNIQUEINDEXxtab1ONtab1(c2,c1)D.CREATEUNIQUEINDEXxtab1ONtab1(c2)INCLUDE(c1）
考题
建立一个学生信息表student,要求它由学号sno,姓名sname,性别sex,年龄age,4个属性组成,其学号属性惟一,学号、姓名字段不能为空。下列语句正确的是A．CREATE TABLE student (sno char(5）NOT NULL sname char(8）NOT NULL sex char age int）;B．CREATE TABLE student (sno char(5）NOT NULL UNIQUE sname char(8) sex char age int）;C．CREATE TABLE (sno char(5）NOT NULL UNIQUE sname char(8）NOT NULL sex char age int）;D．CREATE TABLE student (sno char(5）NOT NULL UNIQUE sname char(8）NOT NULL sex char age int）;
考题
设有表T，现要在该表新增加一个列，列名为：c1，类型为int。下列能实现该功能的语句是（）。AALTER TABLE T ADD COLUMN c1 intBALTER TABLE T ADD （c1 int）CALTER TABLE T ADD COLUMN c1DALTER TABLE T ADD 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? （）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）
考题
Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）A、CREATE UNIQUE INDEX idx_partno ON parts(part_no)B、CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C、CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D、CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
考题
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
考题
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP 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
考题
单选题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)
考题
单选题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)
考题
单选题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
考题
单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）A
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEB
DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC
CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD
CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
热门标签
最新试卷