C2090-556 Exam - Free IBM Questions and Answers

Question #1 (Topic: Topic 1)

When an cursor is created with the FOR UPDATE syntax, which type of lock is the result?

A. exclusive lock B. shared lock C. promotable lock D. implicit lock

Answer: C

Question #2 (Topic: Topic 1)

For what is the DBINFO function below used?
DBINFO('sqlca.sqlerrd2')

A. Returns the last SQL error code. B. Returns the last serial number inserted. C. Returns the number of rows processed. D. Returns the last ISAM error code.

Answer: C

Question #3 (Topic: Topic 1)

Which two statements are correct about privileges? (Choose two.)

A. User Informix can grant DBA privilege to a role. B. Owner of a table can transfer ownership to another user. C. RESOURCE privilege has all the capabilities of a CONNECT privilege. D. A user with DBA privilege can alter, drop, or rename any database object. E. A user would need RESOURCE privilege to run SET SESSION AUTHORIZATION statement.

Answer: C,D

Question #4 (Topic: Topic 1)

Which Informix Datablade provides an infrastructure for distributed, asynchronous
communication of data in a distributed, heterogeneous environment?

A. MQ Datablade B. Node Datablade C. Binary Datablade D. Basic Text Search Datablade

Answer: A

Question #5 (Topic: Topic 1)

What is the SQL statement cache used for?

A. To cache static SQL statements. B. To cache dynamic SQL statements across sessions. C. To cache all SQL statements for tracing purposes. D. To provide a history of SQL statements to the application.

Answer: B

IBM C2090-556 - Informix 11.50 Application Developer Exam