最新的IBM A2090-556免費考試真題

問題1

What does the TRACE PROCEDURE statement do when debugging stored procedures?

A. Traces the routine calls and return values, automatically setting the debug file to the name of the stored procedure.

B. Traces the routine calls and return values, but not the body of the stored procedure.

C. Traces the routine calls and return values, and every parsed statement in the stored procedure.

D. Activates the TRACE statements embedded in the stored procedure.

正確答案: B

問題2

Which datatype is a synonym for NUMERIC?

A. Fixed point DECIMAL

B. INTEGER

C. FLOAT

D. Floating point DECIMAL

正確答案: A

問題3

Which two statements will search text data stored in the column brands of the table products for the string century? (Choose two.)

A. SELECT id FROM products WHERE bts_contains(brands, 'century');

B. SELECT id FROM products WHERE brands MATCHES '*century*';

C. SELECT id FROM products WHERE brands LIKE '*century*';

D. SELECT id FROM products WHERE brands = 'century';

E. SELECT id FROM products WHERE bts_exists(brands, 'century');

正確答案: A,B

問題4

Which statement about the ALIGNMENT modifier in the CREATE OPAQUE TYPE statement is correct?

A. If you do not include the ALIGNMENT modifier, the default alignment is a 8-byte boundary.

B. If you do not include the ALIGNMENT modifier, the default alignment is a 1-byte boundary.

C. If you do not include the ALIGNMENT modifier, the default alignment is a 2-byte boundary.

D. If you do not include the ALIGNMENT modifier, the default alignment is a 4-byte boundary.

正確答案: D

問題5

Which two statements are true for built-in functions? (Choose two.)

A. You cannot overload the functions.

B. All functions require at least one argument.

C. The function is evaluated for each row in the query.

D. You cannot specify the function as the default column value.

E. The function can be used in both SQL statements and shell scripts.

正確答案: B,C

問題6

What format should be used to define columns using user-defined types in an ANSI-compliant database?

A. owner.colname

B. colname

C. tablename.colname

D. owner.tablename.colname

正確答案: A

問題7

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. CURSOR STABILITY

B. REPEATABLE READ

C. COMMITTED READ

D. DIRTY READ

正確答案: B

問題8

What is the SQL statement cache used for?

A. To cache static SQL statements.

B. To cache dynamic SQL statements across sessions.

C. To cache all SQL statements for tracing purposes.

D. To provide a history of SQL statements to the application.

正確答案: B

問題9

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

A. database@server:databasename:[owner.]table

B. database@server:databasename:user:password:[owner.]table

C. database@server:[owner.]table

D. database@server:user:password:[owner.]table

正確答案: C

問題10

What is the default isolation level in a non-ANSI-complaint logged database?

A. REPEATABLE READ and CURSOR STABILITY

B. CURSOR STABILITY

C. COMMITTED READ

D. DIRTY READ

正確答案: C

最新的IBM Assessment: Informix 11.50 Application Developer - A2090-556免費考試真題

聯系我們

站內鏈接

最新更新