000-543 試験問題を無料オンラインアクセス

Given the table COURSES shown below: COURSES
ID CODE NAME
1 ECE100 Operating Systems
2 ECE101 Programming Languages
3 ECE102 Intro to Databases
User USER1 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
SELECT max(ID) FROM session.tempcourses;
Assuming autocommit is on, which result will user USER1 obtain?

• A.value 3
• B.value 1
• C.value 2
• D.no value

Which condition will prevent a developer from using the DB2 Call Level Interface in an application?

• A.The application must create an external scalar function with the CREATE FUNCTION statement.
• B.The DECLARE CURSOR statement needs to be used.
• C.The developer must control the cursor names to comply with company naming standards.
• D.An SQL precompiler is not available to the developer.

For which two database objects can an ALIAS be created? (Choose two.)

• A.schema
• B.module
• C.trigger
• D.sequence

What are two valid values for the PARAMETER STYLE clause in the CREATE PROCEDURE statement? (Choose two.)

• A.C
• B.JAVA
• C.SQL WITH NULLS
• D.GENERAL WITH NULLS

Given the SQL statement shown below:
UPDATE employee SET lastname = CAST(? AS VARCHAR(12))
WHERE empno = ?00050??
What does CAST(? AS VARCHAR(12)) represent?

• A.a typed host variable
• B.a null indicator variable
• C.a host parameter descriptor
• D.a typed parameter marker