在SQL语言中，能正确实现级联删除的命令是( )。
A: A) ON DELETE CASCADES
B: B) ON DELETE RESTRICTED
C: C) ON DELETE NULLIFIES
D: D) ON DELETE DEFAULT
A: A) ON DELETE CASCADES
B: B) ON DELETE RESTRICTED
C: C) ON DELETE NULLIFIES
D: D) ON DELETE DEFAULT
举一反三
- SQL语言中删除表的命令是( ). A: DROP TABLE B: ERASE TABLE C: DELETE TABLE D: DELETE DBF
- 当删除R中某个学生的记录时，要求同时删除该学生的选课信息。则在定义S的外键时应作用的短语是______。 A: ON DELETE CASCADES B: ON DELETE RESTRICTED C: ON UPDATE CASCADES D: ON UPDATE RESTRICTED
- 在SQL中,下列哪条语句能删除表中记录? A: Delete … While <;条件>; B: Delete … By <;条件>; C: Delete … For <;条件>; D: Delete … Where <;条件>;
- （ ）SQL语言中，删除一个表的命令是delete。
- SQL语言中,删除一个视图的命令是DELETE。