最新的高品質 C2090-543 考試練習題庫

IBM C2090-543 考試概覽:

IBM C2090-543 考試大綱主題:

最新的 IBM certifications I C2090-543 免費考試真題：

問題 #1

Which two SQL statements demonstrate the correct usage of a parameter marker? (Choose two.)

A. SELECT ? FROM employee
B. VALUES(?) INTO :hvar1
C. DELETE FROM employee WHEREempno = ?
D. SET CURRENT SQLID = ?

問題 #2

Click the Exhibit button.
CONNECT TO test;
CREATE TABLE colors(id INT NOT NULL PRIMARY KEY,
descVARCHAR(12));
CREATE TABLE objects(desc VARCHAR(12),
c_idINT REFERENCES colors (id)
ON UPDATE NO ACTION);
INSERT INTO colors VALUES (1, 'Red'), (2, 'Blue'), (3, 'Yellow'), (4, 'Green');
INSERT INTO objects VALUES ('Fire Engine', 1), ('Grass', 4), ('Banana', 3);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
The statement shown below is executed:
UPDATE colors SET id = id + 1;
How many records will be modified?

A. 1
B. 0
C. 3
D. 2

問題 #3

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, 'CALL multiResults()');
How can you fetch all of the result sets from $stmt?

A. Call db2_next_result($stmt) for each result set.
B. Call db2_fetch_object($stmt) for each result set.
C. Call db2_fetch_object($stmt) for the first result set; call db2_next_result($stmt) for more result sets.
D. Call db2_next_result($stmt) for each result set; call db2_fetch_object($stmt) for each row in the result set.

問題 #4

Which SQL procedure will retrieve all the rows from table T1 and make those rows available to the invoker as a result set?

A. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR WITH RETURN FOR SELECT * FROM t1;
OPEN c1;
END
B. CREATE PROCEDURE proc1() DYNAMIC RESULTS SET 1 LANGUAGE SQL SELECT * FROM t1
C. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR FOR SELECT * FROM t1;
RETURN c1;
END
D. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
RETURN (SELECT * FROM t1)

問題 #5

A library keeps digital copies of books in the table shown below:
CREATE TABLE library.collection (
bookidINTEGER NOT NULL PRIMARY KEY,
ebook_contentBLOB(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.)

A. SQLGetData()
B. SQLFetchNext()
C. SQLGetSubString()
D. SQLGetLength()

問題與答案：