IBM Informix 11.50 Application Developer - 000-556 Free Exam Questions

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

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

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

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

A. Execute a PREPARE statement and execute the prepared statement using the EXECUTE statement.

B. Assemble the text of the SQL statement and execute the statement using the EXECUTE statement.

C. Execute a PREPARE statement, assemble the text of the SQL statement, and execute the prepared statement using the EXECUTE statement.

D. Assemble the text of the SQL statement, execute a PREPARE statement, and execute the prepared statement using the EXECUTE statement.

A. Hold

B. Persistent

C. Scroll

D. Fetch

A. OF TYPE

B. It is not possible to ensure that a BYTE column is populated.

C. NOT NULL

D. CHECK (IS NOT NULL)

A. In the event or in the action clause of a trigger.

B. In the FOR UPDATE clause or in an Update cursor.

C. In the definition of a view.

D. In SELECT statements within the WHERE clause.

A. Repeatable Read

B. Committed Read

C. Dirty Read

D. Cursor Stability

A. Insert, update and delete triggers only.

B. Insert and update triggers only.

C. Insert, update, delete and select triggers.

D. Update and delete triggers only.

A. It uses the EXECUTE statement to execute the prepared statement.

B. It executes a PREPARE statement, which asks the database server to examine the statement text and prepare it for execution.

C. It requires the exact content of every SQL statement to be known at the time the program is written.

D. It assembles the text of an SQL statement as a character string.

A. DECLARE my_cur CURSOR FOR SELECT * FROM orders ORDER BY 1 FOR UPDATE;

B. DECLARE my_cur CURSOR FOR SELECT * FROM orders WHERE order_date <= today - 30 FOR UPDATE;

C. DECLARE my_cur CURSOR FOR SELECT * FROM orders, customer FOR UPDATE;

D. DECLARE my_cur CURSOR FOR SELECT * FROM orders GROUP BY 1 FOR UPDATE;

A. DROP TRIGGER subtables.delst_trg1;

B. DROP TRIGGER delst_trg1;

C. SET TRIGGER subtable.delst_trg1 DISABLED;

D. SET TRIGGER delst_trg1 FOR subtable DISABLED;