移动端

  • 题王微信公众号

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

计算机考试 | IBM认证考试

模式切换

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

章节目录

单选题 Which of the following best describes how locks are used in DB2?()

A

To maintain control of updated rows for commit processing

B

To ensure only committed changes are altered by another application

C

To allow two applications to update the same row of data simultaneously

D

To prevent multiple applications from accessing the same data simultaneously

单选题 Which of the following describes the model used by the Geodetic Extender?()

A

Flat earth

B

3-D Square

C

Trapezoidal

D

Round earth

单选题 Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?()

A

DB2 will no longer allow updating the value of IDCOL1 in TABLE1.

B

When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

C

When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.

D

When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

单选题 Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?()

A

DB2 Express Edition

B

DB2 Personal Edition

C

DB2 Workgroup Server Edition

D

DB2 Enterprise Server Edition

单选题 Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()

A

REVOKE ACCESS ON DATABASE FROM USER bob

B

REVOKE CONNECT ON DATABASE FROM USER tom

C

REVOKE tom FROM ACCESS ON DATABASE BY USER bob

D

REVOKE tom FROM CONNECT ON DATABASE BY USER bob

1 2 3 4 5 下一页 尾页 /

到第