IBM Informix 11.50 Application Developer - C2090-556무료 덤프문제 풀어보기

A. Select, Insert, Update, Delete and Execute.

B. Select and Execute.

C. No access if NODEFDAC is zero.

D. Select, Insert, Update and Delete.

A. Scroll

B. Persistent

C. Hold

D. Fetch

A. REPEATABLE READ

B. DIRTY READ

C. COMMITTED READ

D. CURSOR STABILITY

A. A cursor is necessary before an after trigger can be created.

B. A cursor is only necessary when using DISTINCT, UNIQUE, ORDER BY, GROUP BY or aggregates in SQL statements.

C. A cursor is necessary when a query returns one row and you wish to examine its content and maybe update it or delete it.

D. A cursor is necessary when a query returns more than one row and you wish to examine their content before an update or delete statement is executed.

A. Lock the table in exclusive mode for the whole transaction OR use repeatable read isolation level for the whole transaction.

B. Lock the table in shared mode for the whole transaction OR use committed read isolation level for the whole transaction.

C. Lock the table in shared mode for the whole transaction OR use repeatable read isolation level for the whole transaction.

D. Lock the table in exclusive mode for the whole transaction OR use committed read isolation level for the whole transaction.

A. External Tables

B. Datablade API

C. SQL Extensions

D. Virtual Tables

A. LOOP ... END LOOP

B. REPEAT ... END REPEAT

C. FOR ... END FOR

D. WHILE ... END WHILE

A. Day-second Interval

B. Hour-second Interval

C. Year-month Interval

D. Day-time Interval

E. Month-day Interval

A. NOT NULL

B. CHECK (IS NOT NULL)

C. OF TYPE

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

A. LONG

B. SMALLINT

C. INT8

D. FLOAT

E. BIGINT