What will happened when Different user queries the same stream after 1 hour?

When created, a stream logically takes an initial snapshot of every row in the source object and the contents of a stream change as DML statements execute on the source table.

A Data Engineer, Sophie Created a view that queries the table and returns the CURRENT_USER and CURRENT_TIMESTAMP values for the query transaction. A Stream has been created on views to capture CDC.

Tony, another user inserted the data e.g.

insert into <table> values (1),(2),(3);

Emily, another user also inserted the data e.g.

insert into <table> values (4),(5),(6);

What will happened when Different user queries the same stream after 1 hour?
A . All the 6 records would be shown with METADATA$ACTION as ‘INSERT’ out of which 3 records would be displayed with username ‘Tony’ & rest 3 records would be displayed with username ‘Emily’.
B . All the Six Records would be displayed with CURRENT_USER & CUR-RENT_TIMESTAMP while querying Streams.
C . All the Six records would be displayed with User ‘Sohpie’ Who is the owner of the View.
D . User would be displayed with the one who queried during the session, but Recorded timestamp would be of past 1 hour i.e. actual records insertion time.

View Answer

Answer: B

Explanation:

When User queries the stream, the stream returns the username for the user. The stream also returns the current timestamp for the query transaction in each row, NOT the timestamp when each row was inserted.