Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-543
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-543.html

DB2 9.7 Application Development

Question No: 41 – (Topic 1)

You have created a stored procedure (MULTIRESULTS()) on the server which will return multiple result sets. Whiledeveloping a PHP application using the IBM_DB2 extension, you want to call the stored procedure. The code shown below will execute the stored procedure:

$stmt = db2_exec($conn, #39;CALL multiResults()#39;); How can you fetch all of the result sets from $stmt?

  1. Call db2_fetch_object($stmt) for the first result set; call db2_next_result($stmt) for more result sets.

  2. Call db2_next_result($stmt) for each result set.

  3. Call db2_fetch_object($stmt) for each result set.

  4. Call db2_next_result($stmt) for each result set; call db2_fetch_object($stmt) for each row in the result set.

Answer: A

Question No: 42 – (Topic 1)

You have set your data types as CHAR(10), VARCHAR(20). Given the operation shown below: CHAR(10) UNION VARCHAR(20)What will be the final data type?

  1. CHAR(200)

  2. VARCHAR(30)

  3. VARCHAR(20)

  4. CHAR(30)

Answer: C

Question No: 43 – (Topic 1)

An application contains the statements shown below:

DECLARE csr1 CURSOR WITH HOLD FOR SELECT * FROM employee;

OPEN csr1; FETCH csr1;

DECLARE csr2 CURSOR FOR SELECT * FROM employee; OPEN csr2;

COMMIT; CLOSE csr1;

When will cursor CSR1 lose position?

  1. When the application issues the COMMIT statement.

  2. When the last row is read from the CSR1 result set.

  3. When cursor CSR2 is opened.

  4. When cursor CSR1 is closed.

Answer: D

Question No: 44 – (Topic 1)

A library keeps digital copies of books in the table shown below: CREATE TABLE library.collection (

bookid INTEGER NOT NULL PRIMARY KEY,

ebook_content BLOB(2G) )

A CLI/ODBC application is written that retrieves the EBOOK_CONTENT for a given BOOKID in 32K pieces.

Which two APIs can be used to perform the retrieval? (Choose two.)

  1. SQLGetLength()

  2. SQLGetData()

  3. SQLGetSubString()

  4. SQLFetchNext()

Answer: B,C

Question No: 45 – (Topic 1)

Click the Exhibit button. CONNECT TO test;

CREATE TABLE project (projno CHAR(6), deptno CHAR(3), projname VARCHAR(20)); CREATE TABLE employee (empno CHAR(6), lastname VARCHAR(25), deptno CHAR(3)); COMMIT;

CONNECT RESET;

A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit was executed successfully.

Which query will produce a list of all projects and all employees assigned to projects and also include employees that have not been assigned a project?

  1. SELECT empno, lastname, workdept, projname FROM employee RIGHT OUTER JOIN project

    ON employee.deptno = project.deptno

  2. SELECT empno,lastname, employee.deptno, projname FROM employee FULL OUTER JOIN project

    ON employee.deptno = project.deptno

  3. SELECT empno, lastname, employee.deptno, projname FROM employee LEFT OUTER JOIN project

    ON employee.deptno = project.deptno

  4. SELECT empno, lastname, employee.deptno, projname

FROM employee JOIN project ON employee.deptno = project.deptno

Answer: C

Question No: 46 – (Topic 1)

Which two techniques guarantee that XML document validation will be performed? (Choose two.)

  1. Implicit use of the XMLCHECK() function in the SQL statements.

  2. Use triggers for INSERT and UPDATE operations with the XMLVALIDATE() function.

  3. Implicit use of the XMLVALIDATE() function in SQL statements.

  4. Use triggers for INSERT and UPDATE operations with the XMLSERIALIZE() function.

Answer: B,C

Question No: 47 – (Topic 1)

Click the Exhibit button. CONNECT TO test;

CREATE TABLE tab_a (col1 INT); CREATE TABLE tab_b (col1 INT);

INSERT INTO tab_a VALUES (1), (2), (3), (4);

INSERT INTO tab_b VALUES (1), (2), (2), (3); CONNECT RESET;

A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit executed successfully.

If the statement shown below is executed:

DELETE FROM tab_a WHERE col1 IN (SELECT DISTINCT * FROM tab_b);

How many rows will be removed from table TAB_A?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: D

Question No: 48 – (Topic 1)

An application must perform maintenance on a table named EMPLOYEE.

Which SQL statement can be used to restrict all activity on the EMPLOYEE table during maintenance by the application?

  1. ALTER TABLE employee LOCK SIZE TABLE

  2. LOCK TABLE employee IN SHARE MODE

  3. ALTER TABLE employee LOCK SIZE ROWS

  4. LOCK TABLE employee IN EXCLUSIVE MODE

Answer: D

Question No: 49 – (Topic 1)

Given the application shown below:

DECLARE csr1 CURSOR WITH HOLD FOR SELECT * FROM employee;

OPEN csr1; FETCH csr1; COMMIT; CLOSE csr1;

How long does cursor CSR1 remain open?

  1. CSR1 remains open until a COMMIT is executed.

  2. CSR1 remains open until the last row is read from the result set.

  3. CSR1 remains open until CLOSE csr1 is executed.

  4. CSR1 remains open until a cursor with a different name is opened.

Answer: C

Question No: 50 – (Topic 1)

Which object can be invoked on a single invocation to return both output parameters and a result set back to the invoking application?

  1. procedure

  2. module

  3. table function

  4. method

Answer: A

Topic 2, Volume B

100% Ensurepass Free Download!
Download Free Demo:C2090-543 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-543 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.