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

The definition of the table "tab1" is:
create table tab1 (colA boolean, colB boolean);
Which INSERT statement for the table is correct?

• A.insert into tab1 (colA, colB) values (t,f);
• B.insert into tab1 (colA, colB) values ('t', NULL);
• C.insert into tab1 (colA, colB) values (1,0);
• D.insert into tab1 (colA, colB) values ('F','0');

What is the primary return code for an SQL statement executed by the database server?

• A.SQLCODE field
• B.SQLERRD array
• C.SQLSTATE value
• D.SQLWARN array

Which SQL statement is used in an Informix ESQL/C application to return diagnostic information about the most recently executed SQL statement?

• A.GET DIAGNOSTICS
• B.GET DESCRIPTOR
• C.UPDATE STATISTICS
• D.DESCRIBE

Which statement combines the actions of the PREPARE, EXECUTE, and FREE statements into a single operation to process most SQL statements?

• A.EXECUTE IMMEDIATE
• B.EXEC SQL
• C.EXECUTE NOW
• D.EXECUTE DYNAMIC

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.traceDirectory property.
• B.Set the db2.jcc.override.traceFile property.
• C.Set the db2.jcc.override.traceDirectory property.
• D.Set the ifx.jcc.override.traceFile property.
• E.Set the ibm.jcc.override.trace property.