IBM Assessment: Informix 11.50 Application Developer - A2090-556 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

What Informix onconfig parameter is used to enable specific user level SQL tracing?

A. SQLTRACE B. SQL_XTRACE C. SQLIDEBUG D. TRACE_SQL

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which of the following may NOT be done with Informix SPL functions?

A. Declare two functions with the same name. B. SQL Optimizer directives inside stored procedures. C. Execute dynamic SQL inside the function. D. Used as a function in the create index statement.

Discussion 0

Correct Answer: D Vote an answer

Question 3

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

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

What are user created temporary tables used for?

A. To persistently write temporary data to disk. B. To share result sets across multiple sessions. C. To automatically delete data based on a time policy. D. To access a temporary result set within one session.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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

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

Discussion 0

Correct Answer: C Vote an answer

Question 6

Given the attached exhibit, what isolation level should Mary use to ensure that she does not see an inconsistent balance across her savings and checking accounts?

A. REPEATABLE READ B. COMMITTED READ LAST COMMITTED C. CURSOR STABILITY D. DIRTY READ LAST COMMITTED

Discussion 0

Correct Answer: A Vote an answer

Question 7

A function written in the Informix SPL may NOT return which of the following?

A. A NULL value. B. A simple large object reference (byte or text column type). C. Multiple column values within a single call. D. No value.

Discussion 0

Correct Answer: D Vote an answer

Question 8

To register a routine in the database, an authorized user wraps the SPL commands in a CREATE FUNCTION or CREATE PROCEDURE statement. The database server stores a registered SPL routine internally. Which two of the following can register a new routine in the database? (Choose two.)

A. Any user in the DBA group. B. The user informix. C. Any user in the DBSECADM group. D. All users. E. Any user with DBA privileges.

Discussion 0

Correct Answer: B,E Vote an answer

Question 9

Given the following program code: What is the minimum privilege required to successfully execute the program?

A. DBA B. RESOURCE C. CREATE D. CONNECT

Discussion 0

Correct Answer: B Vote an answer