Free C2090-320 Exam braindumps download (C2090-320 exam dumps Free)

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

Show Answer 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

Show Answer 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