nerdexam
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)
  • A
    80% (33)
  • B
    2% (1)
  • C
    5% (2)
  • D
    12% (5)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice