Given this statement, if the customer table contains a SERIAL column, which statement should be executed prior to the INSERT?

Given this statement, if the customer table contains a SERIAL column, which statement should be executed prior to the INSERT?

image020

A . INITIALIZE gr_cust.* TO 0
B . LET gr_cust.serialnum = 0
C . LET gr_cust.serialnum = NULL
D . No extra statements for SERIAL values are needed if gr_cust was defined with the statement:
DEFINE gr_cust RECORD LIKE customer.*

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments