DB2 9.7 Application Development v6.0

Given the two tables shown below:

COUNTRIES -
----------

COUNTRY CONTINENT_ID -

Greece 1 -

Germany 1 -

Canada 2 -

CONTINENTS -
-----------

ID CONTINENT -
1 Europe
2 North America
3 Asia
A user wants the following result:

COUNTRY CONTINENT -

Greece Europe -
Which query should the user submit to achieve the result?

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

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?

Which standard is used for XML document validation in DB2?

In a query, which clause can reference a CLOB data type?

Given the SQL statement shown below:
UPDATE address SET number_street =
(SELECT address FROM employee
WHERE address.empid = employee.empid)

WHERE number_street IS NULL -
Which comment is true?

Which type of join condition specifies that the result table will contain a row for each row from the Table to the left, concatenated with each row from the table to the right?

Click the Exhibit button.
CREATE TABLE s1.mytab (col1 INTEGER GENERATED ALWAYS AS IDENTITY, col2
INTEGER, col3 INTEGER, CHECK (col1+col3 < 500) CREATE VARIABLE s1.var1
INTEGER DEFAULT (99) CREATE FUNCTION s1.add100 (p1 INT, p2 INT) RETURNS
INTEGER LANGUAGE SQL DETERMINISTIC NOT FENCED BEGIN SET p1= p2+100;

RETURN p1;END -
Given the table, variable, and function definitions shown in the exhibit, which two statements contain a valid invocation of the add100 function? (Choose two.)

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), (1), (2), (2);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in the exhibit was executed successfully.
If the statement shown below is executed:
UPDATE tab_a SET col1 = 10 WHERE col1 IN (SELECT * FROM tab_b);
How many rows in table TAB_A will be modified?

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?

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?

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?

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.)

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?