最新のC2090-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. no value
• B. value 1
• C. value 2
• D. value 3

The table PERSON is declared as shown below:
CREATE TABLE xmltest (id BIGINT, info XML)
What is the column type for the result of the following statement?
SELECT t.* FROM
xmltest,
XMLTABLE (
'$INFO/question'
) AS t

• A. BLOB
• B. XML
• C. CLOB
• D. VARCHAR

Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3)) RETURNS TABLE (empno CHAR(6), firstnameVARCHAR(12), lastnameVARCHAR(15)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC RETURN SELECT empno, firstnme, lastname FROM employee WHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined function to return all of the employees that work in department D11?

• A. SELECT * FROMdeptemployees('D11')
• B. SELECT * FROM TABLE(deptemployees('D11'))
• C. SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
• D. SELECT * FROMdeptemployees('D11') AS D11dept

An application connecting to a DB2 database using the IBM Data Server Provider for .NET is
seeing
performance degradation after 100 active users.
Which Visual Basic .NET command string enables the re-use of the database connections?

• A. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd; Min Pool Size=10" Dim conn As DB2Connection = new SqlConnection(connectString)
• B. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd;Pooling=100;" Dim conn As DB2Connection = new DB2Connection(connectString)
• C. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd;Pooling=100;" Dim conn As DB2Connection = new SqlConnection(connectString)
• D. DimconnectString As String = "Database=SAMPLE;UID=admin;PWD=pwd; Min Pool Size=10" Dim conn As DB2Connection = new DB2Connection(connectString)

Which object can be created to group together related procedures and user-defined functions that are used for tax calculations?.

• A. collection
• B. routine space
• C. module
• D. routine