Which column provides information when the stream became stale or may become stale if not consumed?

Which column provides information when the stream became stale or may become stale if not consumed?
A . STREAM_STALE_PERIOD
B . STALE_PERIOD_AFTER
C . STALE_STREAM_PERIOD
D . STALE_AFTER

View Answer

Answer: D

Explanation:

execute SHOW STREAMS command.

Column Name: STALE_AFTER

Timestamp when the stream became stale or may become stale if not consumed. The value is calculated by adding the retention period for the source table (i.e. the larger of the DA-TA_RETENTION_TIME_IN_DAYS or MAX_DATA_EXTENSION_TIME_IN_DAYS parameter setting) to the last time the stream was read.