최신 IBM certifications I C2090-543 무료샘플문제:

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

A) C
B) SQL WITH NULLS
C) GENERAL WITH NULLS
D) JAVA

2. Which two techniques guarantee that XML document validation will be performed? (Choose two.)

A) Implicit use of the XMLCHECK() function in the SQL statements.
B) Use triggers for INSERT and UPDATE operations with the XMLSERIALIZE() function.
C) Implicit use of the XMLVALIDATE() function in SQL statements.
D) Use triggers for INSERT and UPDATE operations with the XMLVALIDATE() function.

3. Table T1 and views V1 and V2 were created by executing the statements shown below:
CREATE TABLE t1 (c1 INT, c2 CHAR(3));
CREATE VIEW v1 AS SELECT c1, c2 FROM t1 WHERE c1 > 100;
CREATE VIEW v2 AS SELECT * FROM v1 WHERE c2 IS NULL WITH
CASCADED CHECK OPTION;
Which statement will execute successfully?

A) INSERT INTO v2 VALUES (100, 'abc')
B) INSERT INTO v2 VALUES (125, NULL)
C) INSERT INTO v2 VALUES (100, NULL)
D) INSERT INTO v2 VALUES (125, 'abc')

4. 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?

A) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo where $studinfo/@sid="1" return {$studinfo/name}{$studinfo/phone/text()}
B) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo where $studinfo/@sid="1" return {$studinfo/name}{$studinfo/phone/text()}
C) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo return {$studinfo/name}{$studinfo/phone}
D) XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo where $studinfo/@sid="1" return {$studinfo/name}{$studinfo/phone}

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

A) routine space
B) routine
C) collection
D) module

질문과 대답: