Free C2090-320 Exam Braindumps (page: 15)

Page 14 of 31

Which catalog tables are populated by RTS? (Choose two.)

  1. SYSIBM.SYSTABLES
  2. SYSIBM.SYSINDEXES
  3. SYSIBM.SYSINDEXPART
  4. SYSIBM.SYSINDEXSPACESTATS
  5. SYSIBM.SYSTABLESPACESTATS

Answer(s): D,E



A clone table can only be created in which of the following?

  1. A simple table space
  2. A universal table space
  3. An auxiliary table space
  4. A classic segmented table space

Answer(s): B


Reference:

https://community.toadworld.com/platforms/ibmdb2/w/wiki/6841.clone-tables



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

  1. None
  2. SYSADM
  3. SECADM
  4. EXECUTE

Answer(s): B


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/ db2z_cmd_bindplan.html



A summary table can be easily maintained using which of the following?

  1. An auxiliary table
  2. A partitioned table
  3. A bi-temporal table
  4. A materialized query table

Answer(s): D


Reference:

http://www.informit.com/articles/article.aspx?p=2755707&seqNum=3






Post your Comments and Discuss IBM C2090-320 exam with other Community members:

C2090-320 Exam Discussions & Posts