C2090-730：最新的IBM認證C2090-730考題，DB2 9 Family Fundamentals認證

問題1
Which two of the following are optional and do not have to be specified when creating a table?

A. Table name

B. Column data type

C. Default constraint

D. NOT NULL constraint

E. Column name

正確答案: C,D

問題2
Given the following two tables:
NAMES NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11 POINTS NAME POINTS
Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players that have scored points?

A. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name

B. SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = p.name

C. SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name

D. SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name

正確答案: C

問題3
Given the following table:
TEMP_DATA
TEMP DATE
45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006
And the following SQL statement:
CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END
Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?

A. VALUESdegf_to_c(32)

B. CALLdegf_to_c(32)

C. VALUESdegf_to_c(32) AS temp_c

D. SELECT date,degf_to_c(temp) AS temp_c FROM temp_data

E. SELECT * FROMTABLE(degf_to_c(temp)) AS temp_c

正確答案: A,D

問題4
Given the following table definition:
STOCK:
item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2)
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?

A. UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%

B. UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%

C. UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'

D. UPDATE stock SET (status, quantity,price) = (NULL, 0, 0) WHERE item LIKE S%

正確答案: D

問題5
If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?

A. Send a message to let the administrator know of the situation and decide which application or applications should be terminated.

B. Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

C. Rollback the transaction in one of the two applications.

D. Rollback the transaction in both applications.

正確答案: C

問題6
The following statements:
CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY (col1));
CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2),
FOREIGN KEY (col1) REFERENCES t1 (col1)
ON DELETE CASCADE ON UPDATE RESTRICT);
CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),
FOREIGN KEY (col1) REFERENCES t1 (col1)
ON DELETE NO ACTION ON UPDATE RESTRICT);
INSERT INTO t1 VALUES (1), (2);
INSERT INTO t2 VALUES (1, 'a'), (1, 'b'), (2,'c');
INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);
How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE
col1 = 1;

A. 4

B. 0

C. 1

D. 3

正確答案: B

問題7
Given the following two tables:
EMPLOYEE
ID NAME DEPTID
01 Mick Jagger 10 02 Keith Richards 20 03 Ronnie Wood 20 04 Charlie Watts 20 05 Bill Wyman 30 06 Brian Jones
DEPARTMENT
ID DEPTNAME
10 Executive Staff 20 Sales 30 Marketing 40 Engineering 50 Human Resources
Which two of the following queries will display the employee name and department name for all employees that are in Sales?

A. SELECT e.name,d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

B. SELECT e.name,d.deptname FROM employee e FULL OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

C. SELECT e.name,d.deptname FROM employee e, department d WHERE e.deptid = d.id AND d.id = '20'

D. SELECT e.name,d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE d.id = '20'

E. SELECT e.name,d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id
WHERE d.id = '20'

正確答案: A,D

問題8
What does the following statement do? GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

A. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

B. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

C. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.

D. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

正確答案: D

問題9
Given the following query:
SELECT quantity,
CASE WHEN itemcode = '099' THEN 'SILVER'
WHEN itemcode = '788' THEN 'GOLD'
WHEN itemcode = '899' THEN 'PLATINUM'
ELSE 'ERROR'
END
FROM supplier
What will be the result of the query if the following data is evaluated by the CASE expression?
SUPPLIER
QUANTITY ITEMCODE 3 099 4 099 1 788 1 899 5 009 3 788 1 899

A. 3,SILVER 4,GOLD 1,SILVER 1,GOLD 5,PLATINUM 3,SILVER 1,GOLD

B. 3,SILVER 4,SILVER 1,GOLD 1,GOLD 5,SILVER 3,ERROR 1,PLATINUM

C. 3,SILVER 4,SILVER 1,PLATINUM 1,ERROR 5,SILVER 3,GOLD 1,PLATINUM

D. 3,SILVER 4,SILVER 1,GOLD 1,PLATINUM 5,ERROR 3,GOLD 1,PLATINUM

正確答案: D

問題10
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?

A. ALTER

B. REFERENCES

C. SELECT

D. UPDATE

正確答案: A

問題11
Given the following SQL statements:
CREATE TABLE tab1 (col1 INTEGER) INSERT INTO tab1 VALUES (NULL) INSERT INTO tab1 VALUES (1) CREATE TABLE tab2 (col2 INTEGER) INSERT INTO tab2 VALUES (NULL) INSERT INTO tab2 VALUES (1) INSERT INTO tab2 VALUES (2)
What will be the result when the following statement is executed?
SELECT * FROM tab1 WHERE col1 IN (SELECT col2 FROM tab2)

A. COL1
-1 2 record(s) selected.

B. COL1
1
1 record(s) selected.

C. COL1
NULL 1 2 record(s) selected.

D. COL1
-
1 record(s) selected.

正確答案: B

問題12
User USER1 wants to utilize an alias to remove rows from a table. Assuming USER1 has no authorities or privileges, which of the following privileges are needed?

A. DELETE privilege on the alias; REFERENCES privilege on the table

B. DELETE privilege on the alias

C. REFERENCES privilege on the alias; DELETE privilege on the table

D. DELETE privilege on the table

正確答案: D

問題13
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?

A. Command Line Processor

B. Developer Workbench

C. Command Editor

D. Task Center

正確答案: C

問題14
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 ASretval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2

B. SELECT DISTINCT r1 ASretval FROM tab1, tab2 WHERE r1 <> r2

C. SELECT r1 ASretval FROM tab1 UNION SELECT r2 AS retval FROM tab2

D. SELECT r1 ASretval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2

正確答案: D

問題15
A declared temporary table is used for which of the following purposes?

A. Backup purposes

B. Staging area for load operations

C. Sharing result data sets between applications

D. Storing intermediate results

正確答案: D

最新的IBM DB2 9 Family Fundamentals - C2090-730免費考試真題

專業認證

品質保證

輕松通過

免費試用