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
答案解析:有
微信扫一扫手机做题