IBM C2090-320 Exam Practice Test Instant Access

Question 1

What are two major encoding schemes? (Choose two.)

AUNIX

BLinux

CCCSID

DUnicode

EEBCDIC

Answer : D, E

Question 2

Which of the following is NOT TRUE?

AAn index can be created on XML columns

BLength must be specified for an XML column

CXML columns can be added to existing tables

DTriggers can be created on tables with XML columns

Answer : D

Question 3

Which of the following automatically maintains historical versions of data over several years?

AA partitioned-by-range table

BA partitioned-by-growth table

CA system-period temporal table

DAn application-period temporal table

Answer : C

Question 4

Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

ACLI

BJDBC

CDRDA

DODBC

Answer : D

Question 5

Which catalog table provides information about the validity of a bound package?

ASYSIBM.SYSPACKLIST

BSYSIBM.SYSPACKAGE

CSYSIBM.SYSPACKDEP

DSYSIBM.SYSPACKAUTH

Answer : A

Question 6

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 7

Which privilege or authority is required to use the DSN command?

ANone

BSYSADM

CSECADM

DEXECUTE

Answer : B

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