nerdexam
IBM

C2090-320 · Question #64

Which statement about an application-period temporal table is TRUE?

The correct answer is D. It has a begin column defined as TIMESTAMP(6) NOT NULL or DATE NOT NULL. db2zos/index.html

DB2 Objects

Question

Which statement about an application-period temporal table is TRUE?

Options

  • AIt has SYSTEM_TIME defined
  • BIt has an end column defined using WITH DEFAULT NULL
  • CIt must have the index clause BUSINESS_TIME WITHOUT OVERLAPS
  • DIt has a begin column defined as TIMESTAMP(6) NOT NULL or DATE NOT NULL

How the community answered

(25 responses)
  • A
    12% (3)
  • B
    8% (2)
  • C
    4% (1)
  • D
    76% (19)

Explanation

db2zos/index.html

Topics

#application-period temporal table#temporal table definition#TIMESTAMP column#table DDL

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C2090-320 Practice