Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
000-730 Real Tests (May 2017)

[Free] 2017(May) Ensurepass Pass4sure IBM 000-730 Real Tests 141-150

May 4, 2017

Ensurepass
2017 May IBM Official New Released 000-730 Q&As
100% Free Download! 100% Pass Guaranteed!
http://www.ensurepass.com/000-730.html

DB2 9 Family Fundamentals

QUESTION 141

The opening of cursor CSR01 produces the following result set:

 

STUDENT LASTNM FIRSTNM CLASSNO

 

123 Brown John T100

 

213 Bailey James T100

 

312 Carter Arlene T210

 

465 Chas Devon T305

 

546 Davis Steven T405

 

If this Fetch statement is executed:

 

FETCH csr01 INTO :studnum, :firstname, :lastname, :class

 

Which of the following DELETE statements will cause this row to be deleted?

 

A.

DELETE ALL FROM tab01 FOR CURRENT OF csr01

B.

DELETE FROM tab01 FOR CURRENT csr01 WITH RS

C.

DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS

D.

DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR

 

Correct Answer: D

 

 

 

 

QUESTION 142

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,PLATINUM

5,ERROR

3,GOLD

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,GOLD

5,SILVER

3,ERROR

1,PLATINUM

 

Correct Answer: B

 

 

QUESTION 143

Given the following expression:

 

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?

 

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, PLATINUM

5, ERROR

3, GOLD

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, GOLD

5, SILVER

3, ERROR

1, PLATINUM

 

Correct Answer: B

 

 

QUESTION 144

Which of the following queries will correctly return the manager information sorted by the manager’s last name, department and project name?

 

A.

SELECT lastname, dept, projname, manager, startdate

FROM (SELECT name, dept, proj AS projname, manager, startdate

FROM employee, project

WHERE empno = empno) AS empproj

ORDER BY name, dept, projname

B.

SELECT lastname, dept, projname, manager, startdate

FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate

FROM employee, project

WHERE empno = mgrno) AS empproj

SORT BY lastname, firstname, dept, projname

C.

SELECT lastname, dept, projname, manager, startdate

FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate

FROM employee, project

WHERE empno = mgrno) AS empproj

ORDER BY lastname ASC

SORT BY dept, projname DESC

D.

SELECT lastname, dept, projname, manager, startdate

FROM (SELECT name AS lastname, dept, proj AS projname, manager, startdate

FROM employee, project

WHERE empno = mgrno) AS empproj

ORDER BY lastname, dept, projname

 

Correct Answer: D

QUESTION 145

Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available?

 

A.

SELECT * FROM tab1 FIND FIRST 50 ROWS

B.

SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY

C.

SELECT * FROM tab1 WHILE ROW_NUM < 50

D.

SELECT * FROM tab1 MAXROWS 50

 

Correct Answer: B

 

 

QUESTION 146

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, department d

WHERE e.deptid = d.id AND 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 RIGHT OUTER JOIN department d

ON e.deptid = d.id

WHERE 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 INNER JOIN department d

ON e.deptid = d.id

WHERE d.id = ’20’

 

Correct Answer: AE

 

 

QUESTION 147

Given the following queries:

 

SELECT c1 FROM tab1;

 

SELECT c1 FROM tab2;

 

Which of the following set operators can be used to produce a result data set that contains only records that are not found in the result data set produced by each query after duplicate rows have been eliminated?

 

A.

UNION

B.

INTERSECT

C.

EXCEPT

D.

MERGE

 

Correct Answer: D

 

 

QUESTION 148

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 INNER JOIN points p ON n.name = p.name

B.

SELECT p.name, n.number, p.points FROM names n LEFT OUTER 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

 

Correct Answer: C

 

 

QUESTION 149

Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

 

A.

%

B.

*

C.

?

D.

\

 

Correct Answer: A

 

 

QUESTION 150

Given the following tables:

 

YEAR_2006

 

EMPID NAME

—- —————

 

1 Jagger, Mick

 

2 Richards, Keith

 

3 Wood, Ronnie

 

4 Watts, Charlie

 

5 Jones, Darryl

 

6 Leavell, Chuck

 

YEAR_1962

 

EMPID NAME

 

—- —————

 

1 Jagger, Mick

 

2 Richards, Keith

 

3 Jones, Brian

 

4 Wyman, Bill

 

5 Watts, Charlie

 

6 Stewart, Ian

 

If the following SQL statement is executed, how many rows will be returned?

 

SELECT name FROM year_2007

 

UNION ALL

 

SELECT name FROM year_1962

 

A.

6

B.

9

C.

10

D.

12

 

Correct Answer: D

100% Free Download!
—Download Free Demo:000-730 Demo PDF
100% Pass Guaranteed!
Download 2017 Ensurepass 000-730 Full Exam PDF and VCE Q&As:303
—Get 10% off your purchase! Copy it:TJDN-947R-9CCD [2017.05.01-2017.05.31]

Ensurepass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF + VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Ensurepass IT Certification PDF and VCE