EnsurePass
2017 Nov IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 1

N NO:149

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

  1. %

  2. *

  3. ?

  4. \

Answer: A

Question No: 2

Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?

  1. DB2 for z/OS

  2. DB2 Run-Time Client for z/OS

  3. DB2 Connect Enterprise Edition for z/OS

  4. z/OS Application Connectivity to DB2 for z/OS and OS/390

Answer: A

Question No: 3

Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?

  1. Visual Explain

  2. Activity Monitor

  3. SQL Performance Monitor

  4. DB2 Performance Monitor

Answer: C

Question No: 4

Given the following function:

CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6)

, firstname VARCHAR(12)

, lastname VARCHAR(15) ) LANGUAGE SQL

BEGIN ATOMIC RETURN

SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE

WHERE WORKDEPT IN (#39;A00#39;, #39;B00#39;); END

How can this function be used in an SQL statement?

  1. SELECT TABLE(EMPLIST()) FROM EMPLOYEE

  2. SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

  3. SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

  4. SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

Answer: D

Question No: 5

A sequence was created with the DDL statement shown below:

CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10

User USER1 successfullyexecutes the following statements in the order shown: VALUES NEXT VALUE FOR my_seq INTO :hvar;

VALUES NEXT VALUE FOR my_seq INTO :hvar;

User USER2 successfully executes the following statements in the order shown:

ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5; VALUES NEXT VALUE FOR my_seq INTO :hvar;

After users USER1 and USER2 are finished, user USER3 executes the following query: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1

What value will be returned by the query?

  1. 5

  2. 10

  3. 20

  4. 30

Answer: D

Question No: 6

In which situation is shredding XML data recommended?

  1. When the data is naturally tabular

  2. When the number of nodes are volatile

  3. When the data by nature has sparse attributes

  4. When the data is of low volumeand requires a complex star-schema topology

Answer: A

Question No: 7

Application A wants to read a subset of rows from table TAB1 multiple times. Which of the following isolation levels should Application A use to prevent other users from making modifications and additions to table TAB1 that will affect the subset of rows read?

  1. Repeatable Read

  2. Read Stability

  3. Cursor Stability

  4. Uncommitted Read

Answer: A

Question No: 8

Given the following stored procedure:

CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) )

SETp_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept); How can this stored procedure be called from the Command Line Processor?

  1. CALL increase_salary(#39;A00#39;)

  2. VALUES increase_salary(#39;A00#39;)

  3. CALL increase_salary(#39;A00#39;, ?)

  4. VALUES increase_salary(#39;A00#39;, ?)

Answer: A

Question No: 9

Which of the following statements will catalog the database MYDB on the node MYNODE and assign it the alias MYNEWDB?

  1. CATALOG DATABASE mynewdb AT NODE mynode

  2. CATALOG DATABASE mynewdb AS mydb AT NODE mynode

  3. CATALOGDATABASE mydb AT NODE mynode

  4. CATALOG DATABASE mydb AS mynewdb AT NODE mynode

Answer: D

Question No: 10

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?

  1. After a ROLLBACK is issued

  2. After the sequence is altered

  3. After the sequence is dropped

  4. After the current session ends

Answer: A

100% Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-730 Full Exam PDF and VCE

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