Which of the following describes the disadvantage of executing a set of DML statements outside a transaction?
Which of the following describes the disadvantage of executing a set of DML statements outside a
transaction?
Which of the following is required to remove the password prompt?
You are attempting to extract ID files form the ID vault, but you are always prompted to provide the
ID password. Which of the following is required to remove the password prompt?
What actions will take place once the deadlock occurs?
Two applications running concurrently have created a deadlock cycle in the locking subsystem.
Both applications were started at the same time with a lock timeout set to 20.
What actions will take place once the deadlock occurs?
Which of the following isolation levels should be used for databases migrated from older versions of DB2?
Which of the following isolation levels should be used for databases migrated from older versions
of DB2?
If circular logging is used, the following types of backup are allowed:
If circular logging is used, the following types of backup are allowed:
Which of the following data models provides better Data Independence?
Which of the following data models provides better Data Independence?
which of the following DB2 Editions?
PureXML does not come packaged with which of the following DB2 Editions?
Which of the following is NOT true about Buffer Pool in DB2?
Which of the following is NOT true about Buffer Pool in DB2?
When does authentication takes place in DB2?
When does authentication takes place in DB2?
What effect does this setting have?
The TCP Authentication field “Redirect TCP to SSL” is set to “No”. What effect does this setting
have?