What must user USER1 do to accomplish this?
User USER1 wants to define a required relationship between two tables named TAB1 and
TAB2 in such a way that whenever a record is deleted from table TAB1, any related records
are deleted from table TAB2. What must user USER1 do to accomplish this?
Which statement about a deadlock is true?
Which statement about a deadlock is true?
Which command is used to export connectivity configuration information from a file known as a configuration pr
Which command is used to export connectivity configuration information from a file known
as a configuration profile?
What takes place when a process accesses a data object on which it already holds a lock, and the access mode r
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?
What is the act of releasing a large number of row-level locks that an application holds on a single table to
What is the act of releasing a large number of row-level locks that an application holds on a
single table to acquire a table-level lock known as?
Which statement is true regarding client-server database connectivity?
Which statement is true regarding client-server database connectivity?
When is an INTENT EXCLUSIVE (IX) lock required?
When is an INTENT EXCLUSIVE (IX) lock required?
which of the following?
The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of
the following?
What factor influences lock conversion/promotion?
What factor influences lock conversion/promotion?
What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a
database named ACCOUNTS and a database named PAYROLL. What can be done to
prevent a DB2 Discovery operation from seeing the DEV instance and its databases?