移动端

  • 题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

其他类 | IBM认证考试

模式切换

0 0 0
我的错题 我的收藏 学习笔记

章节目录

单选题 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?()

A

Rollback the transaction in both applications.

B

Rollback the transaction in one of the two applications.

C

Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.

D

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?()

A

COL1 will accept NULL values and can be referenced in another table's foreign key specification.

B

COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.

C

COL1 will not accept NULL values and can be referenced in another tables foreign key specification.

D

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?()

A

Define the column MAINID as NOT UPDATABLE

B

Define the column MAINID as a PRIMARY KEY

C

Define the column MAINID as a FOREIGN KEY

D

Define an UPDATE trigger on table TABLEX

单选题 Which of the following is the main feature of an OLTP application?()

A

Summarized queries

B

Granular transactions

C

Voluminous historical data

D

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?()

A

Application B will read the row.

B

Applications A and B will cause a deadlock situation.

C

Application B will wait until application A releases the Update lock.

D

Application A will be terminated so that application B can read the row.

单选题 Which of the following is a characteristic of a schema?()

A

Foreign key references cannot cross schema boundaries.

B

A DB2 user must be created before a schema with the same name can be created.

C

If no schema is specified when an object is created, the default schema PUBLIC is used.

D

A schema enables the creation of multiple objects in a database without encountering namespace collisions.

单选题 Which of the following is a typical data warehouse query?()

A

What is this customers address?

B

Does this customer have any unpaid bills?

C

What is the balance in this customers account?

D

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?()

A

The cursor is only protected from updates and deletes by concurrent applications.

B

The row is only protected from positioned updates and deletes that reference another cursor of the same application.

C

The cursor is protected from positioned updates and deletes that reference another cursor of a different application.

D

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.

单选题 Which of the following is a characteristic of a sequence?()

A

A sequence will never generate duplicate values

B

The MAXVALUE of a sequence can be equal to the MINVALUE

C

It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

D

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

最新资讯

1 2 3 4 5 下一页 尾页 /

到第