000-556 試験問題を無料オンラインアクセス

Which temporary table statement is NOT true?

• A.Temporary tables are visible to all users.
• B.The table can have fragmented indexes.
• C.The table can use multiple dbspaces.
• D.The table exists until the database is closed.

Which built-in function is supported by Informix Server?

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

Which statement about casting is correct?

• A.You cannot explicitly invoke an implicit cast with the CAST AS keywords or the :: cast operator.
• B.A differential cast tells the database server that two data types have different internal structures.
• C.The following code fragment creates an implicit cast: CREATE CAST (percent AS INTEGER).
• D.A straight cast tells the database server that two data types have the same internal structure.

Which of the following data types can be used for values in a sequence?

• A.INTERVAL
• B.SERIAL8
• C.SMALLINT, INTEGER or DECIMAL
• D.CLOB and BLOB

A function written in the Informix SPL may NOT return which of the following?

• A.A NULL value.
• B.A simple large object reference (byte or text column type).
• C.Multiple column values within a single call.
• D.No value.