QUESTION: 25

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?

MSTR
DBM1
DIST
IRLM

Answer(s): A

Reveal Solution Next Question

QUESTION: 26

Which of the following statements about a table with a LOB column is TRUE?

It doesn’t need an auxiliary table if it has an inline LOB
It must also have a ROWID column and an auxiliary table
It doesn’t need a ROWID column (implicit or explicit) if a LOB locator will be used
It must be in a partitioned by growth (PBG) universal table space with a ROWID column

Answer(s): B

Reveal Solution Next Question

QUESTION: 27

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

SYSIBM.SYSPACKLIST
SYSIBM.SYSPACKAGE
SYSIBM.SYSPACKDEP
SYSIBM.SYSPACKAUTH

Answer(s): A

Reference:

https://books.google.com.pk/books?id=QH3JAgAAQBAJ&pg=PA256&lpg=PA256&dq=db2+11
+catalog+table+provides+information+about+the+validity+of+a+bound
+package&source=bl&ots=4G_RwWpnUF&sig=Lm-LaNpt_SRiZcdhGxiX7ehVIfY&hl=en&sa=X&ved=0ahUKEwjLmPz66drZAhUO6aQKHW_2C9UQ6AEITjAF#v=onepage&q=db2%2011%20catalog%20table%20provides%20information%20about%20the%20validity%20of% 20a%20bound%20package&f=false

Reveal Solution Next Question

QUESTION: 28

Which of the following statements concerning a bi-temporal table is TRUE?

It provides business history, but is not useful for audit purposes
It is defined with both an application period and a system period
It is useful for audit purposes, but is not useful for business history
It contains data reflecting two different times – current time and one previous time

Answer(s): B

Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/ db2z_creationoftableswithdataversioning.html

Reveal Solution Next Question

Free C2090-320 Exam Braindumps (page: 8)

QUESTION: 25

QUESTION: 26

QUESTION: 27

Reference:

QUESTION: 28

Reference:

C2090-320 Exam Discussions & Posts