IBM
C2090-558 · Question #20
Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as rows are inserted?
The correct answer is A. CREATE TABLE customer (cust_num SERIAL(2301), ? See the full explanation below for the reasoning.
Question
Which of these commands will create a table containing a column that will be automatically populated with a numeric value starting from an initial value of 2301 and incremented as rows are inserted?
Options
- ACREATE TABLE customer (cust_num SERIAL(2301), ?;
- BCREATE TABLE customer (cust_num SERIAL INIT 2301,?;
- CCREATE TABLE customer (cust_num INT SET SERIAL 2301,?;
- DCREATE TABLE customer (cust_num SERIAL,? SET SERIAL 2301;
How the community answered
(41 responses)- A80% (33)
- B2% (1)
- C5% (2)
- D12% (5)
Community Discussion
No community discussion yet for this question.