Topic 1, Volume A

QUESTION: 1
What are user created temporary tables used for?

A. To persistently write temporary data to disk.
B. To share result sets across multiple sessions.
C. To access a temporary result set within one session.
D. To automatically delete data based on a time policy.

Answer(s): C
QUESTION: 2
In an ANSI compliant database, what value of SQLCODE indicates a successful query that returned no
rows?

A. 100
B. -330
C. -201
D. -1

Answer(s): A
QUESTION: 3
Which Committed Read isolation level statement is correct?

A. It locks all rows examined.
B. It does not check for locks.
C. It checks for locks after returning a row.
D. It checks for locks before returning a row.

Answer(s): D
QUESTION: 4
Which two values can be used for connection type field from sqlhosts file when using Distributed
Relational Database Architecture (DRDA) protocol? (Choose two.)

A. ontlitcp
B. onipcshm
C. onsoctcp
D. drtlitcp
E. drsoctcp

Answer(s): D, E
QUESTION: 5
Which type of isolation level results in a lock on every row a query examines in order to retrieve any row
from the result set?

A. DIRTY READ
B. COMMITTED READ

Free C2090-556 Exam Braindumps

Exam Code: C2090-556 Exam Title: Informix 11.50 Application Developer Exam
Exam Provider: IBM

Pass your Informix 11.50 Application Developer Exam exam with these free Actual Questions and Answers

C2090-556 Discussions & Posts