[Free] 2017(May) Ensurepass Pass4sure IBM 000-610 Real Tests 31-40

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

DB2 10.1 Fundamentals

QUESTION 31

Which command is used to back out a subset of database changes that have been made within a unit of work?

 

A.

COMMIT

B.

ROLLBACK

C.

COMMIT TO SAVEPOINT

D.

ROLLBACK TO SAVEPOINT

Correct Answer: D

 

 

QUESTION 32

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:

 

clip_image001

 

How can this function be used to convert average temperature (AVG_TEMP) data stored in a table called CLIMATE_INFO?

 

A.

CALL conv_temp(climate_info.avg_temp);

B.

CALL convert_ftoc(climate_info.avg_temp);

C.

SELECT conv_temp(avg_temp) FROM climate_info;

D.

SELECT convert_ftoc(avg_temp) FROM climate_info;

 

Correct Answer: C

 

 

QUESTION 33

If a table named MY_TAB contains 100 rows and the following statement is executed:

 

clip_image002

 

What will happen?

 

A.

The last 5 rows in the table will be deleted.

B.

The first 5 rows in the table will be deleted.

C.

The statement will fail because a subquery cannot be used with a DELETE statement.

D.

The statement will fail because a table name was not specified with the DELETE statement.

 

Correct Answer: A

 

 

QUESTION 34

Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?

 

A.

SELECT employees.name, sales.revenue

FROM employees

INNER JOIN sales ON employees.id = sales.emp_id

B.

SELECT employees.name, sales.revenue

FROM employees

INNER JOIN sales ON sales.emp_id = employees.id

C.

SELECT employees.name, sales.revenue

FROM sales

LEFT OUTER JOIN employees ON employees.id = sales.emp_id

D.

SELECT employees.name, sales.revenue

FROM sales

RIGHT OUTER JOIN employees ON employees.id = sales.emp_id

 

Correct Answer: D

 

 

QUESTION 35

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose two.)

 

A.

CALL statements.

B.

External file access.

C.

Use of a scratch pad.

D.

COMMIT statements.

E.

SQL control statements.

 

Correct Answer: AE

 

 

QUESTION 36

Which command will delete all rows from a table without generating log records?

 

A.

TRIM

B.

DROP

C.

DELETE

D.

TRUNCATE

 

Correct Answer: D

 

 

QUESTION 37

Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?

 

A.

XMLTABLE

B.

XMLPARSE

C.

XMLEXISTS

D.

XMLATTRIBUTES

 

Correct Answer: A

 

 

QUESTION 38

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:

 

clip_image004The employee’s hire date (HIREDATE) is before 1999 and the employee’s salary (SALARY) is less than $40,000.00 a year.

clip_image004[1]The employee has attended university

Which SQL statement will accomplish this?

 

A.

SELECT * FROM employee

WHERE (hiredate < ‘1999-01-01’ AND salary < 40000)

OR (education = ‘Uni
versity’)

B.

SELECT * FROM employee

WHERE (hiredate < ‘1999-01-01’) OR (salary < 40000)

OR (education = ‘University’)

C.

SELECT * FROM employee

WHERE (hiredate < ‘1999-01-01’ OR (salary < 40000

AND (education = ‘University’)

D.

SELECT * FROM employee

WHERE (hiredate < ‘1999-01-01’ AND salary < 40000

AND (education = ‘University’)

 

Correct Answer: A

 

 

QUESTION 39

Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?

 

A.

SELECT empno, hiredate, salary

FROM employee

FOR hiredate < ‘1998-01-01’ AND salary < 35000

B.

SELECT empno, hiredate, salary

FROM employee

WHERE hiredate < ‘1998-01-01’ AND salary < 35000

C.

SELECT empno, hiredate, salary

FROM employee

WHERE hiredate < ‘1998-01-01’ OR salary < 35000

D.

SELECT empno, hiredate, salary

FROM employee

FOR hiredate < ‘1998-01-01’ OR salary < 35000

 

Correct Answer: B

 

 

QUESTION 40

If the following result set is desired:

 

clip_image005

 

Which SQL statement must be executed?

 

A.

SELECT lastname, firstnme, salary, job

FROM employee

ORDER BY 3

FETCH FIRST 5 ROWS ONLY

B.

SELECT lastname, firstnme, salary, job

FROM employee

ORDER BY 3 DESC

FETCH FIRST 5 ROWS ONLY

C.

SELECT lastname, firstnme, salary, job

FROM employee

ORDER BY 3

FETCH FIRST 5 ROWS

D.

SELECT lastname, firstnme, salary, job

FROM employee

ORDER BY 3 DESC

FETCH FIRST 5 ROWS

 

Correct Answer: B

100% Free Download!
—Download Free Demo:000-610 Demo PDF
100% Pass Guaranteed!
Download 2017 Ensurepass 000-610 Dumps Q&As:138
—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