IBM C2090-320 Exam Questions Instant Access

Question 1

Which of the following can be defined on the basis of a query?

AAn alias

BA base table

CAn accelerator-only table

DA materialized query table

Answer : D

Question 2

Which of the following is used to identify valid source and target combinations and to perform the conversion from one coded character set to another?

AEBCDIC tables

Bz/OS Unicode support

CDB2 catalog table SYSIBM.SYSCOLUMNS

DDB2's Distributed Relational Database Architecture

Answer : D

Question 3

Which SQL statement will retrieve the department number (WORKDEPT)

and the highest salary (SALARY) for each department in a table

named EMPLOYEE and arrange the result set in ascending order by department?

ASELECT workdept, salary FROM employee GROUP BY workdept ORDER BY workdept;

BSELECT workdept MAX(salary) FROM employee ORDER BY workdept GROUP BY 2;

CSELECT workdept MAX(salary) FROM employee ORDER BY workdept;

DSELECT workdept MAX(salary) FROM employee GROUP BY workdept ORDER BY 1;

Answer : B

Question 4

Which of the following statements will create an application-period temporal table?

ACREATE TABLE POLICY_ATT(BANK VARCHAR(4). SYS_BEGIN TIMESTAMP. SYS_END TIMESTAMP, CLIENT CHAR(4), TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEGIN, SYS_END));

BCREATE TABLE POLICY_ATT(BANK VARCHAR(4),
SYS_BEGIN TIMESTAMP NOT NULL, SYS_END TIMESTAMP NOT NULL, CLIENT CHAR(4)T TYPE CHAR(5), PAY INT, PERIOD SYSTEM_TIME(SYS_BEG1N, SYS_END));

CCREATE TABLE POLICY_ATT(BANK VARCHAR(4). BUS_BEGIN TIMESTAMP. BUS_END TIMESTAMP. CLIENT CHAR(4), TYPE CHAR(5), PAY INT. PERIOD BUSINESS_TIME(BUS_BEGIN. BUS_END));

DCREATE TABLE POLICY_ATT(BANK VARCHAR(4),
BUS_BEGIN TIMESTAMP NOT NULL, BUS_END TIMESTAMP NOT NUK, CLIENT CHAR{4), TYPE CHAR(5), PAY INT. PERIOD BUSINESS_TIME(BUS_BEGIN. BUS_END));

Answer : C

Question 5

Which of the following is a characteristic of a stand-alone utility?

AIt can only be executed using JCL

BIt can only be executed by a user with SYSADM

CIt can only be executed if no other utilities are running

DIt can only be executed in a non-data sharing environment

Answer : A

Question 6

Which of the following elements is affected by a ROLLBACK statement?

ALOB table spaces

BChanges in cursor positioning

CAcquisition and release of locks

DCaching of rolled back statements

Answer : A

Question 7

Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

ASQLCA

BSQLDA

CSQLCODE

DSQLSTATE

Answer : B

IBM DB2 11 Fundamentals for z/OS C2090-320 Exam Questions