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: 61 – (Topic 2)

In a PHP script, which ibm_db2 functions should be used if the user wants to retrieve a row in a result set as an array, indexed by column name?

  1. db2_fetch_both()

  2. db2_fetch_array()

  3. db2_fetch_object()

  4. db2_fetch_assoc()

Answer: D

Question No: 62 – (Topic 2)

In a PHP script, which ibm_db2 functions can be used to retrieve the result set of a query executed against a database table?

  1. db2_next_result()

  2. db2_fetch_array()

  3. db2_execute()

  4. db2_result()

Answer: B

Question No: 63 – (Topic 2)

Which statement(s) will create and bind the package for the program myprogram.sqc?

  1. BIND myprogram.bnd

  2. PRECOMPILE myprogram.sqc

  3. gcc myprogram.sqc -o myprogram BIND myprogram.bnd

  4. gcc myprogram.sqc -o myprogram REBIND myprogram.sqc

Answer: B

Question No: 64 – (Topic 2)

Click the Exhibit button.

UPDATE DBM CFG USING FEDERATED YES;

db2stop; db2start;

CONNECT TO test;

CREATE WRAPPER oledb LIBRARY #39;db2oledb#39;; CREATE SERVER nwind

WRAPPER oledb

OPTIONS (CONNECTSTRING #39;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=f:Northwind.mdb;#39;, COLLATING_SEQUENCE #39;Y#39;); CREATE FUNCTION nwind.customers()

RETURNS TABLE (customerid CHAR(5), companyname VARCHAR(40), contactname VARCHAR(30),

contacttitle VARCHAR(30), address VARCHAR(60), city VARCHAR(15),

region VARCHAR(15), postalcode VARCHAR(15), country VARCHAR(24),

phone VARCHAR(24), fax VARCHAR(24)) LANGUAGE OLEDB

EXTERNAL NAME #39;nwind!customers#39;; COMMIT;

CONNECT RESET;

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

Which statement can be used to verify that an OLE DB table function designed to retrieve data from the CUSTOMERS table of the NORTHWIND Microsoft Access database was created successfully?

  1. SELECT companyname FROM nwind.customers()

  2. SELECT companyname FROM TABLE (nwind.customers()) AS t

  3. SELECT companyname FROM oledb.nwind.customers()

  4. SELECT companyname FROM TABLE (oledb.nwind.customers()) AS t

Answer: B

Question No: 65 – (Topic 2)

A CLI/ODBC application uses the SQL FetchScroll() API to retrieve an updatable row set with five rows of data. Each column of the row set is bound to an array of application memory. The API is called with the SQL_FETCH_NEXT

FetchOrientation option and returns SQL_SUCCESS_WITH_INFO. Diagnostics show a truncation SQLSTATE of quot;01004quot;.

Which API call correctly identifies the record with the failure?

  1. SQLGetDiagField( hStmt, SQL_DIAG_ROW_COUNT, amp;(intVal) );

  2. SQLGetDiagField( hStmt, SQL_DIAG_ROW_NUMBER, amp;(intVal) );

  3. SQLGetDescField( hStmt, SQL_DESC_COUNT, amp;(intVal) );

  4. SQLGetDescField( hStmt, SQL_DESC_ARRAY_SIZE, amp;(intVal) );

Answer: B

Question No: 66 – (Topic 2)

What is the final result of executing the statements shown below? CREATE SEQUENCE order_seq

START WITH 100

INCREMENT BY 25

MAXVALUE 150 CYCLE;

VALUES NEXT VALUE FOR order_seq; VALUES NEXT VALUE FOR order_seq; VALUES NEXT VALUE FOR order_seq; VALUES NEXT VALUE FOR order_seq;

A. 100

B. 125

C. 150

D. 175

Answer: A

Question No: 67 – (Topic 2)

Click the Exhibit button.

lt;personinfogt;

lt;namegt;John Smithlt;/namegt;

lt;address type=quot;privatequot;gt;

lt;citygt;New Yorklt;/citygt;

lt;countrygt;USlt;/countrygt;

lt;phonegt;850-734-6672lt;/phonegt;

lt;/addressgt;

lt;phone type=quot;mobilequot;gt;796-858-1272 lt;/phonegt;

lt;phone type=quot;securityquot;gt;646-252-1053lt;/phonegt;

lt;/personinfogt;

The table PERSON is declared as shown below: CREATE TABLE person (id BIGINT, info XML)

The document shown in the exhibit is successfully inserted into the table. How many rows will be returned for the following statement?

SELECT t.* FROM

xmlapp.PERSON, XMLTABLE (

#39;$INFO/personinfo#39; COLUMNS

name VARCHAR(30) PATH #39;./name#39;, phone VARCHAR(30) PATH #39;./phone#39;

) AS t

  1. 2

  2. 4

  3. 6

  4. 0

Answer: D

Question No: 68 – (Topic 2)

Which return codes will be returned by SQLFetch() when there are no more records to be retrieved in a result data set?

  1. SQL_SUCCESS

  2. SQL_NO_DATA_FOUND

  3. SQL_WARNING

  4. SQL_NO_MORE_DATA

Answer: B

Question No: 69 – (Topic 2)

Which three are required for a global transaction? (Choose three.)

  1. Client Application

  2. Transaction Manager

  3. Workload Manager

  4. Application Coordinator

  5. Resource Manager

Answer: A,B,E

Question No: 70 – (Topic 2)

Given the SQL statement shown below:

UPDATE employee SET lastname = CAST(? AS VARCHAR(12)) WHERE empno = ?00050??

What does CAST(? AS VARCHAR(12)) represent?

  1. a typed host variable

  2. a typed parameter marker

  3. a null indicator variable

  4. a host parameter descriptor

Answer: 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.