When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

Question

Carlos John Ricafort · Accepted Answer

All rows loaded using a specific COPY statement will have the same timestamp value.

Carlos John Ricafort · Answer

All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

Carlos John Ricafort · Answer

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

Carlos John Ricafort · Answer

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 38 - ARA-C01 discussion

Suggested answer: D

0 comments