移动端

  • 题王微信公众号

    题王微信公众号

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

计算机考试 | IBM认证考试

模式切换

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

章节目录

单选题 A user invoking a user-defined function requires which DB2 privilege?()

A

CALL

B

USAGE

C

EXECUTE

D

REFERENCES

单选题 A stored procedure object is created into which DB2 object?()

A

Alias

B

Schema

C

Package

D

Routine Space

单选题 Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?()

A

Design Advisor

B

Visual Explain

C

Performance Advisor

D

Configuration Assistant

单选题 An Alias can be an alternate name for which DB2 object?()

A

Sequence

B

Trigger

C

Schema

D

View

单选题 Which of the following database objects can be used to raise an error if a table is updated?()

A

Package

B

Trigger

C

Stored Procedure

D

Informational Constraint

单选题 Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?()

A

DB2 for z/OS

B

DB2 Run-Time Client for z/OS

C

DB2 Connect Enterprise Edition for z/OS

D

z/OS Application Connectivity to DB2 for z/OS and OS/390

单选题 For which of the following is a data warehouse optimized?()

A

Backup and recovery

B

Transactions

C

Security

D

Queries

单选题 Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()

A

INSERT INTO tab1 SELECT cx, cy FROM tab2

B

INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

C

INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)

D

INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

首页 上一页 1 2 3 4 5 尾页 /

到第