IBM Assessment: Informix 11.50 Application Developer - A2090-556 Exam Practice Test

A. CURSOR STABILITY

B. REPEATABLE READ and CURSOR STABILITY

C. COMMITTED READ

D. DIRTY READ

A. Named row types

B. Opaque types

C. Distinct types

D. Row types

A. It is used when you associate an EXECUTE FUNCTION statement with a cursor.

B. It is a cursor that uses the FETCH option to retrieve successive rows of data from another cursor.

C. It is the representation of columns or values that a user-defined function returns after a SELECT statement.

D. It is a data structure that represents the active set of rows that the SELECT statement retrieved.

A. To provide a history of SQL statements to the application.

B. To cache all SQL statements for tracing purposes.

C. To cache static SQL statements.

D. To cache dynamic SQL statements across sessions.

A. FETCH

B. OPEN

C. SELECT INTO

D. DECLARE CURSOR

A. User Informix can grant DBA privilege to a role.

B. Owner of a table can transfer ownership to another user.

C. A user with DBA privilege can alter, drop, or rename any database object.

D. RESOURCE privilege has all the capabilities of a CONNECT privilege.

E. A user would need RESOURCE privilege to run SET SESSION AUTHORIZATION statement.