最新的高品質 A2090-556 考試練習題庫

IBM A2090-556 考試概覽:

IBM A2090-556 考試大綱主題:

最新的 On Demand Business A2090-556 免費考試真題：

1. Which predicate is used in a query to perform searches with Basic Text Search?

A) bts_search()
B) bts_like()
C) bts_contains()
D) bts_in()

2. Which of the following is a valid declaration of a cursor?

A) DECLARE my_cur CURSOR FOR SELECT * FROM orders ORDER BY 1 FOR UPDATE;
B) DECLARE my_cur CURSOR FOR SELECT * FROM orders GROUP BY 1 FOR UPDATE;
C) DECLARE my_cur CURSOR FOR SELECT * FROM orders WHERE order_date <= today - 30 FOR UPDATE;
D) DECLARE my_cur CURSOR FOR SELECT * FROM orders, customer FOR UPDATE;

3. Consider the following:
GRANT DEFAULT ROLE user_role TO eric;
GRANT DEFAULT ROLE def_role TO PUBLIC;
What role will user eric use by default assuming the SET ROLE DEFAULT privilege has been granted?

A) user_role because you cannot have both public and user level roles.
B) def_role because it was the last role command issued.
C) user_role because it takes precedence over the public role.
D) def_role because default roles cannot be issued to a user.

4. Given the SQL statement below:

Which option defines ABS?

A) User Defined Type
B) Trigger
C) Built-in function
D) SPL Routine

5. What is an Informix database trigger?

A) A way of rejecting unwanted database connections.
B) A security event used by Informix auditing to warn the DBA of unwanted actions.
C) An automatic event created by the database scheduling system to notify the DBA about a problem.
D) An automatically executed set of SQL statements when a specific activation event occurs.

問題與答案：