IBM C2090-320 Exam Practice Test Instant Access

Question 1

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

Question 2

Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?

ASYSIBM.SYSCHECKDEP

BSYSIBM.SYSPENDINGDDL

CSYSIBM.SYSDEPENDENCIES

DSYSIBM.SYSPENDINGOBJECTS

Answer : B

Question 3

Which DB2 address space manages DB2 locking?

AIRLM

BDIST

CDBM1

DMSTR

Answer : A

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

Consider the following question: ''What is the average salary by sex within education level?'' An occasional uncommitted record can be tolerated in the average. Which of the following is the most appropriate isolation level for this?

AUR

BRR

CCS

DRS

Answer : A

Question 6

You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

AMSTR

BDBM1

CDIST

DIRLM

Answer : A

Question 7

In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)

AA unique key

BA foreign key

CA primary key

DA duplicate key

EA secondary key

Answer : A, C

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