最新のA2090-556問題集で試験を準備する

IBM A2090-556 試験概要:

IBM A2090-556 試験シラバストピック:

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

1. A distinct user defined data type called "dollar" is created as follows:
CREATE DISTINCT TYPE dollar AS DOUBLE PRECISION;
When can you convert it to its base data type double precision?

A) It may always be converted to its base data type.
B) As long as no conversion rate is required.
C) When a cast function exists between these two types.
D) Only when the ALLOW_BASE_CAST attribute is used when creating the type.

2. Where are the UNION and UNION ALL operators in subqueries supported?

A) In the FOR UPDATE clause or in an Update cursor.
B) In the definition of a view.
C) In SELECT statements within the WHERE clause.
D) In the event or in the action clause of a trigger.

3. Pamela has decided to fragment a large table containing binary objects to optimize performance. Which of the following statements about data placement is NOT true?

A) Simple binary large objects can reside within the table or can be placed into only a single blobspace.
B) It is possible to fragment a table across multiple dbspaces.
C) Smart large objects can only be placed within a single sbspace.
D) It is possible to fragment a table within a single dbspace.

4. Which cursor statement is used to move the values of a result set columns into program variables?

A) FETCH
B) DECLARE CURSOR
C) SELECT INTO
D) OPEN

5. What is the syntax to query a table that resides on a remote Informix database?

A) database@server:databasename:user:password:[owner.]table
B) database@server:user:password:[owner.]table
C) database@server:[owner.]table
D) database@server:databasename:[owner.]table

質問と回答：