Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?

• A.Read Stability
• B.Cursor Stability
• C.Repeatable Read
• D.Cursor Stability with WAIT FOR OUTCOME clause

Comment: *

Name: *

Email: *

Verification: *

Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?

• A.Table
• B.Alias
• C.View
• D.Schema

Comment: *

Name: *

Email: *

Verification: *

Which of the following is TRUE regarding user switching in a trusted context?

• A.The new user must have the connect-privilege on the database for it to succeed
• B.You cannot switch user id in a trusted context
• C.You can issue a switch-user request within a transaction
• D.No password is ever required for the new user as an authentication is established in the trusted connection

Comment: *

Name: *

Email: *

Verification: *

What of the following is TRUE about triggers?

• A.Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
• B.Triggers can be used to perform data manipulation operations against complex views
• C.Triggers can only be used to execute logic before or after appropriate SQL statements
• D.Only one trigger for a particular event and activation time can be created for a particular table

Comment: *

Name: *

Email: *

Verification: *

Given the following statement:
DECLARE GLOBAL TEMPORARY TABLE TEMP1 (
ID INTEGER NOT NULL,
ITEM CHAR(30),
AMOUNT DECIMAL (10,2)
ON COMMIT DELETE ROWS NOT LOGGED;
Which of the following statements are TRUE? (Choose two.)

• A.Temp1 table is accessed under schema SESSION
• B.Definition of the table Temp1 is stored in database catalog
• C.Rows inserted by one session are visible in other sessions
• D.Temp1 definition is available for use by other sessions
• E.At the end of a transaction, data is deleted automatically

Comment: *

Name: *

Email: *

Verification: *