IBM C2090-556 問題集

質問 1：
Which IBM Informix .NET Provider statement is NOT true?
A. Its Connection Lifetime attribute specifies how long a connection can remain open.
B. It works only with Informix.
C. It uses the DRDA protocol to communicate with Informix.
D. It uses the SQLI protocol to communicate with Informix.
正解：C

質問 2：
What statement describes the logging restriction that applies to distributed queries?
A. Participating databases must have buffered logging.
B. Participating database must have identical transaction logging types.
C. Participating databases must be ANSI-compliant.
D. Participating databases must have unbuffered logging.
正解：B

質問 3：
Which URL syntax is NOT used for DRDA communications?
A. jdbc:informix
B. jdbc:db2
C. jdbc:ids
D. jdbc:db2j:net
正解：A

質問 4：
Consider the following:
GRANT DEFAULT ROLE user_role TO eric;
GRANT DEFAULT ROLE def_role TO PUBLIC;
What role will user eric use by default assuming the SET ROLE DEFAULT privilege has been granted?
A. user_role because you cannot have both public and user level roles.
B. def_role because default roles cannot be issued to a user.
C. def_role because it was the last role command issued.
D. user_role because it takes precedence over the public role.
正解：D

質問 5：
Which statement describes a select cursor?
A. It is a data structure that represents the active set of rows that the SELECT statement retrieved.
B. It is the representation of columns or values that a user-defined function returns after a SELECT statement.
C. It is used when you associate an EXECUTE FUNCTION statement with a cursor.
D. It is a cursor that uses the FETCH option to retrieve successive rows of data from another cursor.
正解：A

質問 6：
What is the correct sequence for retrieving multiple rows using a cursor for a dynamic SQL query?
A. DECLARE, FETCH, OPEN, CLOSE, FREE
B. OPEN, DECLARE, FETCH, CLOSE, FREE
C. DECLARE, OPEN, FETCH, FREE, CLOSE
D. DECLARE, OPEN, FETCH, CLOSE, FREE
正解：D

質問 7：
What are the two valid methods to obtain trace data for diagnosing JDBC problems with the IBM Data Server Driver for JDBC and SQLJ type 4 connectivity? (Choose two.)
A. Set the ifx.jcc.override.traceFile property.
B. Set the ifx.jcc.override.traceDirectory property.
C. Set the ibm.jcc.override.trace property.
D. Set the db2.jcc.override.traceDirectory property.
E. Set the db2.jcc.override.traceFile property.
正解：D,E

質問 8：
Which value can be used for connection type field from sqlhosts file when using Secured Sockets Layer (SSL) protocol for Distributed Relational Database Architecture (DRDA) ?
A. drsocssl
B. onsoctcp
C. drtlitcp
D. onsocssl
正解：A

質問 9：
Which two statements will search text data stored in the column brands of the table products for the string century? (Choose two.)
A. SELECT id FROM products WHERE bts_exists(brands, 'century');
B. SELECT id FROM products WHERE brands MATCHES '*century*';
C. SELECT id FROM products WHERE bts_contains(brands, 'century');
D. SELECT id FROM products WHERE brands LIKE '*century*';
E. SELECT id FROM products WHERE brands = 'century';
正解：B,C