IBM Informix 11.50 Application Developer - C2090-556 Exam Practice Test

A. Set

B. List

C. Row

D. Multiset

A. LONG

B. BIGINT

C. SMALLINT

D. FLOAT

E. INT8

A. TRACE_SQL

B. SQL_XTRACE

C. SQLTRACE

D. SQLIDEBUG

A. Combine two regular tables into one.

B. Combine two columns into one, eliminating duplicates.

C. The same as the UNION ALL operator.

D. Combine two result sets, eliminating duplicates.

A. SQL Optimizer directives inside stored procedures.

B. Declare two functions with the same name.

C. Execute dynamic SQL inside the function.

D. Used as a function in the create index statement.

A. When you create a distinct data type, the database server automatically registers explicit casts from the distinct data type to the source data type and from the source data type to the distinct data type.

B. You don't need create casts on distinct types to handle conversions between the new distinct data type and other data types in the database, the server takes care of that automatically.

C. When you create an opaque data type, the server automatically define template casts to handle conversions between the internal and external representations of the opaque data type.

D. In most cases, you can explicitly cast a named row type to built-in data types without creating the cast.