IBM C2090-556 - Informix 11.50 Application Developer Exam

Page:    1 / 23   
Total 115 questions

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

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

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

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

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

Page:    1 / 23   
Total 115 questions