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

IBM A2090-610 考試概覽:

IBM A2090-610 考試大綱主題:

最新的 IBM Certified Application Developer A2090-610 免費考試真題：

1. When a COMMIT statement is executed, what happens?

A) Open cursors defined WITH HOLD are closed, but their data is retained.
B) All locks held on the database are automatically released.
C) The current transaction is terminated and a new transaction boundary is started.
D) Data stored in global temporary tables is automatically deleted.

2. Which statement about UPDATE processing is FALSE?

A) The UPDATE statement logs the before and after value of every column it modifies.
B) The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.
C) When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
D) A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.

3. What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A) Read stability (RS)
B) Cursor stability (CS)
C) Repeatable read (RR)
D) Uncommitted read (UR)

4. What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?

A) Lock conversion
B) Lock escalation
C) Lock timeout
D) Lock wait

5. Which statement regarding triggers is true?

A) Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
B) Triggers can only be fired one time per statement irrespective of the number of rows affected.
C) Triggers cannot be modified, they must be dropped and recreated with new definitions.
D) Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

問題與答案：