IBM Assessment: Informix 11.50 Application Developer 認定 A2090-556 試験問題:

1. Which built-in function is supported by Informix Server?

A) TOCHAR()
B) IFNULL()
C) FORMAT_UNITS()
D) LASTDAY()

2. Which two built-in data types store purely numeric integral values between -(2 63 -1) and 2 63 -1? (Choose two.)

A) BIGINT
B) SMALLINT
C) FLOAT
D) LONG
E) INT8

3. Which SQL statement is used in an Informix ESQL/C application to return diagnostic information about the most recently executed SQL statement?

A) GET DESCRIPTOR
B) GET DIAGNOSTICS
C) UPDATE STATISTICS
D) DESCRIBE

4. What does the UNION operator do?

A) Combine two result sets, eliminating duplicates.
B) The same as the UNION ALL operator.
C) Combine two regular tables into one.
D) Combine two columns into one, eliminating duplicates.

5. Which statement about casting is correct?

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) 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.
C) 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.
D) In most cases, you can explicitly cast a named row type to built-in data types without creating the cast.

質問と回答：