单选题 If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）
Rollback the transaction in both applications.
Rollback the transaction in one of the two applications.
Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.
Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
单选题 If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）
COL1 will accept NULL values and can be referenced in another table's foreign key specification.
COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.
COL1 will not accept NULL values and can be referenced in another tables foreign key specification.
COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.
单选题 Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）
Define the column MAINID as NOT UPDATABLE
Define the column MAINID as a PRIMARY KEY
Define the column MAINID as a FOREIGN KEY
Define an UPDATE trigger on table TABLEX
Voluminous historical data
Heterogeneous data sources
单选题 Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）
Application B will read the row.
Applications A and B will cause a deadlock situation.
Application B will wait until application A releases the Update lock.
Application A will be terminated so that application B can read the row.
Foreign key references cannot cross schema boundaries.
A DB2 user must be created before a schema with the same name can be created.
If no schema is specified when an object is created, the default schema PUBLIC is used.
A schema enables the creation of multiple objects in a database without encountering namespace collisions.
What is this customers address?
Does this customer have any unpaid bills?
What is the balance in this customers account?
What are the total sales for each of the last 6 months?
单选题 Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）
The cursor is only protected from updates and deletes by concurrent applications.
The row is only protected from positioned updates and deletes that reference another cursor of the same application.
The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.
A sequence will never generate duplicate values
The MAXVALUE of a sequence can be equal to the MINVALUE
It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries
单选题 Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）
DB2 for i5/OS
DB2 Runtime Client
DB2 Connect Enterprise Edition
DB2 for i5/OS SQL Development Kit