多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?()

  • A、Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
  • B、Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
  • C、Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
  • D、Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题