IBM IBM Certifications C2090-320 Questions & Answers

• Question 91:

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

  A. An alias

  B. A base table

  C. An accelerator-only table

  D. A materialized query table

  Correct Answer: D

  Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0509melnyk/

• Question 92:

  Which of the following is TRUE for using LOAD on a partition-by-growth table space?

  A. Data can only be loaded at the partition level

  B. Data can only be loaded at the table space level

  C. Data can only be loaded using a clustering index

  D. Data can be loaded at either the table space level or the partition level

  Correct Answer: A

  Reference: https://www.google.com/url? sa=tandrct=jandq=andesrc=sandsource=webandcd=1andcad=rjaanduact=8andved=0ahUKEwjXpIn74tzZAhVRPsAKHRYG BGUQFggnMAAandurl=https%3A%2F%2Fwww.ibm.com%2Fsupport%2Fknowledgecenter% 2Fen% 2FSSEPEK_11.0.0%2Fintro%2Fsrc%2Ftpc% 2Fdb2z_partitionbygrowthtablespaces.htmlandusg=AOvVaw0DCKeDA6MfIUE5UQWhFe_G

• Question 93:

  While DSN is running, which of the following commands CANNOT be successfully executed?

  A. -STOP DB2

  B. -START DB2

  C. -TERM UTILITY

  D. -DISPLAY UTILITY

  Correct Answer: D

• Question 94:

  Given the following table and index definitions, what type of index will be created?

  

  A. Non-partitioned index

  B. Non-partitioned secondary index

  C. Data-partitioned secondary index

  D. Data-partitioned partitioning index

  Correct Answer: C

• Question 95:

  What is the result XQuery FLWOR expression when running the following scenario?

  

  A. Joe Smith

  B. Joe Smith

  C. Joe Smith

  D. Joe Smith DB2

  Correct Answer: A

• Question 96:

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

  A. It provides business history, but is not useful for audit purposes

  B. It is defined with both an application period and a system period

  C. It is useful for audit purposes, but is not useful for business history

  D. It contains data reflecting two different times ?current time and one previous time

  Correct Answer: B

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

• Question 97:

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

  A. SYSIBM.SYSPACKLIST

  B. SYSIBM.SYSPACKAGE

  C. SYSIBM.SYSPACKDEP

  D. SYSIBM.SYSPACKAUTH

  Correct Answer: A

  Reference: https://books.google.com.pk/books?id=QH3JAgAAQBAJandpg=PA256andlpg=PA256anddq=db2+11 +catalog+table+provides+information+about+the+validity+of+a+bound +packageandsource=blandots=4G_RwWpnUFandsig=Lm-LaNpt_SRiZcdhGxiX7ehVIfYandhl=enandsa=Xandved=0ahUKEwjLmPz66drZAhUO6aQKHW_2C9UQ6AEITjAF# v=onepageandq=db2%2011%20catalog%20table%20provides%20information%20about%20the%20validity %20of%20a%20bound% 20packageandf=false

• Question 98:

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

  A. It doesn't need an auxiliary table if it has an inline LOB

  B. It must also have a ROWID column and an auxiliary table

  C. It doesn't need a ROWID column (implicit or explicit) if a LOB locator will be used

  D. It must be in a partitioned by growth (PBG) universal table space with a ROWID column

  Correct Answer: B

• Question 99:

  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?

  A. MSTR

  B. DBM1

  C. DIST

  D. IRLM

  Correct Answer: A

• Question 100:

  Which of the following can activate a trigger?

  A. A row is inserted

  B. A table or view is created

  C. A check constraint is defined

  D. A referential constraint is violated

  Correct Answer: D

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