Given the two tables shown below: TAB1 LETTER GRADE A 80 B 70 C 60 TAB2 LETTER GPA A 4 C 2 D 1 and the successful execution of the following query: SELECT * FROM tab1 FULL OUTER JOIN tab2 ON tab1.letter = tab2.letter; How many rows will be returned?
A. 4
B. 3
C. 6
D. 2
正解:A
質問 2:
Which three data types are supported as output of the XMLSERIALIZE function? (Choose three.)
A. GRAPHIC
B. CLOB
C. CHAR
D. DOUBLE
E. BLOB
正解:B,C,E
質問 3:
Which statement should be used to obtain the result set shown below?
<Root>
<First>Hello</First>
<Second>World !</Second>
<?Test Pass test?>
</Root>
A. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLELEMENT(NAME "First", 'Hello'),
XMLELEMENT(NAME "Second", 'World !'),
XMLTEXT ('Test Pass test')
)
)
B. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLELEMENT(NAME "First", 'Hello'),
XMLELEMENT(NAME "Second", 'World !'),
XMLATTRIBUTES ( 'Pass test' as "test")
)
)
C. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLFOREST(
'Hello' as "First",
'World !' as "Second"
),
XMLPI (NAME "Test", 'Pass test')
)
)
D. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLFOREST(
'Hello' as "First",
'World !' as "Second"
),
XMLCOMMENT ('Test Pass test')
)
)
正解:C
質問 4:
The table shown below contains a large number of financial transactions: CREATE TABLE webstore.transactions (transaction_id INTEGER NOT NULL PRIMARY KEY, order_date TIMESTAMP NOT NULL, shipped_date TIMESTAMP, customer_id INTEGER NOT NULL, shipping_info XML NOT NULL, billing_info XML NOT NULL, invoice XML NOT NULL ) Only members of the AUDIT_TEAM group have SELECT privilege on the WEBSTORE.TRANSACTIONS table. For appropriate supply-chain management, members of the INVENTORY_CONTROL group need to see the INVOICE document for each transaction that has a NULL SHIPPED_DATE, but are restricted from seeing any shipping or billing information. Which database object can a member of the AUDIT_TEAM group create to enable the INVENTORY_CONTROL group to access the information needed from WEBSTORE.TRANSACTIONS?
A. alias
B. trigger
C. view
D. sequence
正解:C
質問 5:
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?
A. module
B. temp file
C. log file
D. locator
正解:D
質問 6:
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?
A. db2_fetch_array()
B. db2_following_result()
C. db2_fetch_assoc()
D. db2_next_result()
正解:D
質問 7:
Which two Java objects can be used to produce a result set using a SELECT statement? (Choose two.)
A. ResultSet
B. Statement
C. CallableStatement
D. PreparedStatement
正解:B,D
Kouno -
IBMテスト(C2090-543)を無事合格できました。
有難うございました。