PrepAway - Latest Free Exam Questions & Answers

Which statement about column-organized tables is true?

Which statement about column-organized tables is true?

PrepAway - Latest Free Exam Questions & Answers

A.
Databases with column-organized tables can be federated.

B.
Schemas that include column-organized tables can be transported.

C.
Sort memory can be automatically tuned in environments containing column-organized tables.

D.
Queries that use the Currently Committed semantics can be used with column-organized
tables.

3 Comments on “Which statement about column-organized tables is true?

  1. chowkwanyuk says:

    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061528.html

    The following additional restrictions apply to column-organized tables in the DB2 Version 10.5 release:
    Schemas that include column-organized tables cannot be transported.
    Data federation with column-organized tables is not supported.
    Automatic tuning of sort memory is not supported in environments using column-organized tables.




    0



    0

Leave a Reply