最新的IBM DB2 9.7 Application Development - 000-543免費考試真題
Table T1 and view V1 were created by executing the statements shown below:
CREATE TABLE t1 (c1 INT CHECK (c1 < 275), c2 CHAR(3));
CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 > 250
WITH LOCAL CHECK OPTION;
Which statement will execute successfully?
CREATE TABLE t1 (c1 INT CHECK (c1 < 275), c2 CHAR(3));
CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 > 250
WITH LOCAL CHECK OPTION;
Which statement will execute successfully?
正確答案: C
A CLI/ODBC application contains the lines of code shown below:
SQLHANDLE hstmt; /* statement handle */
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
SQLSMALLINT parameter1=5;
Which CLI/ODBC API will use the current value of PARAMETER1?
SQLHANDLE hstmt; /* statement handle */
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
SQLSMALLINT parameter1=5;
Which CLI/ODBC API will use the current value of PARAMETER1?
正確答案: C
The table shown below exists within a database:
CREATE TABLE s1.t1 ( c1 INTEGER NOT NULL PRIMARY KEY, c2 CLOB( 2G ) )
A CLI/ODBC application uses the SQLGetSubString() API to retrieve the first 1024 and last 1024
bytes of data from column C2.
Which mechanism is used to minimize the amount of data sent to the client for this operation?
CREATE TABLE s1.t1 ( c1 INTEGER NOT NULL PRIMARY KEY, c2 CLOB( 2G ) )
A CLI/ODBC application uses the SQLGetSubString() API to retrieve the first 1024 and last 1024
bytes of data from column C2.
Which mechanism is used to minimize the amount of data sent to the client for this operation?
正確答案: D
Given the SQL statement shown below:
UPDATE employee SET lastname = CAST(? AS VARCHAR(12))
WHERE empno = ?00050??
What does CAST(? AS VARCHAR(12)) represent?
UPDATE employee SET lastname = CAST(? AS VARCHAR(12))
WHERE empno = ?00050??
What does CAST(? AS VARCHAR(12)) represent?
正確答案: C
A stored procedure is invoked that can return multiple result sets.
After processing the first result set, which CLI/ODBC API can be used to determine if another
result set exists?
After processing the first result set, which CLI/ODBC API can be used to determine if another
result set exists?
正確答案: C
What are two valid connection options that you can use while creating a connection in PHP using the IBM_DB2 extension? (Choose two.)
正確答案: C,D
A PHP script calls a stored procedure that returns more than one result set.
After the rows from the first result set are fetched, which function should be used to retrieve the
subsequent result sets?
After the rows from the first result set are fetched, which function should be used to retrieve the
subsequent result sets?
正確答案: D
An application must insert values into a column that has a TIMESTAMP data type. What is a valid string representation of a TIMESTAMP?
正確答案: B
Which set of SQL statements must be run prior to the EXECUTE statement shown below so that
the
INSERT statement can be executed successfully?
EXECUTE s1 USING :v1;
the
INSERT statement can be executed successfully?
EXECUTE s1 USING :v1;
正確答案: D
Click the Exhibit button.
CREATE TABLE gradereport(sid INTEGER, info XML);
INSERT INTO gradereport VALUES (1,
'<studentinfo sid="1">
<name>John Smith</name>
<honours>No</honours>
<grades>
<course><name>ECE100</name><grade>80</grade></course>
<course><name>CSC100</name><grade>70</grade></course>
<course><name>MAT100</name><grade>75</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, a user wishes to obtain the following result:
<student><name>John Smith</name><phone>416-333-8725</phone></student>
Which query can the user execute to achieve this?
CREATE TABLE gradereport(sid INTEGER, info XML);
INSERT INTO gradereport VALUES (1,
'<studentinfo sid="1">
<name>John Smith</name>
<honours>No</honours>
<grades>
<course><name>ECE100</name><grade>80</grade></course>
<course><name>CSC100</name><grade>70</grade></course>
<course><name>MAT100</name><grade>75</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, a user wishes to obtain the following result:
<student><name>John Smith</name><phone>416-333-8725</phone></student>
Which query can the user execute to achieve this?
正確答案: D