最新的IBM 000-730免費考試真題

問題1

Given the following two tables:
TAB1
COL_1 COL_2
A 10 B 12 C 14
TAB2
COL_A COL_B
A 21 C 23 D 25
Assuming the following results are desired:
COL_1 COL_2 COL_A COL_B A 10 A 21 B 12 - C 14 C 23 - - D 25
Which of the following joins will produce the desired results?

A. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 =col_a

B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 =col_a

C. SELECT * FROM tab1 INNER JOIN tab2 ON col_1 =col_a

D. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 =col_a

正確答案: D

問題2

Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?

A. CREATE NICKNAME euro FOR DECIMAL (9,3)

B. CREATE DATA TYPE euro AS DECIMAL (9,3)

C. CREATE ALIAS euro FOR DECIMAL (9,3)

D. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)

正確答案: D

問題3

Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?

A. Configuration Assistant

B. Design Advisor

C. Visual Explain

D. Performance Advisor

正確答案: B

問題4

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 views, along with the ability to give this authority to other users and groups.

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

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

正確答案: C

問題5

Given the following table definitions:
TABLE1
ID INT NAME CHAR(30) PERSON INT CITIES INT TABLE2
ID INT
LASTNAME CHAR(30)
Which of the following statements will remove all rows in table TABLE1 that have matching
PERSONs in table TABLE2?

A. DELETE FROM table1 WHERE person IN (SELECT person FROM table2)

B. DELETE FROM table1 WHERE id IN (SELECT id FROM table2)

C. DELETE FROM table1 WHERE person IN (SELECT id FROM table2)

D. DELETE FROM table1 WHERE id IN (SELECT person FROM table2)

正確答案: C

問題6

Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?

A. Table

B. View

C. Package

D. Alias

正確答案: D

問題7

Which of the following privileges permits a user to update the comment on a sequence?

A. UPDATE

B. CONTROL

C. ALTER

D. USAGE

正確答案: C

問題8

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?

A. After the sequence is altered

B. After the current session ends

C. After the sequence is dropped

D. After a ROLLBACK is issued

正確答案: D

問題9

Given the following table definitions:
EMPLOYEES
EMPID INTEGER
NAME CHAR(20)
DEPTID CHAR(3)
SALARY DECIMAL(10,2)
COMMISSION DECIMAL(8,2)
DEPARTMENTS
DEPTNO INTEGER DEPTNAME CHAR(20)
Which of the following statements will produce a result data set that satisfies all of these conditions:
> Displays the total number of employees in each department >> Displays the corresponding department name for each department ID >> Sorted by department employee count, from greatest to least

A. SELECTdeptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 ASC

B. SELECTdeptname, COUNT(*) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2

C. SELECT *,COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC

D. SELECTdeptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC

正確答案: D

問題10

Given the following table:
TAB1
COL1 COL2
A 10 B 20 C 30
D 40
E 50
And the following SQL statements:
DECLARE c1 CURSOR WITH HOLD FOR
SELECT * FROM tab1 ORDER BY col_1;
OPEN c1;
FETCH c1;
FETCH c1;
FETCH c1;
COMMIT;
FETCH c1;
CLOSE c1;
FETCH c1;
Which of the following is the last value obtained for COL_2?

A. 30

B. 20

C. 40

D. 50

正確答案: C

問題11

Two applications have created a deadlock cycle in the locking subsystem. If lock timeout is set to 30 and both applications were started at the same time, what action will the deadlock detector take when it "wakes up" and discovers the deadlock?

A. Itwill rollback the current transactions of both applications

B. It will go back to sleep for 30 seconds, then if the deadlock still exists, it will randomly pick an application and rollback its current transaction

C. It will randomly pick an application and rollback its current transaction

D. It will wait 30 seconds, then rollback the current transactions of both applications if the deadlock has not been resolved

正確答案: C

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

聯系我們

站內鏈接

最新更新