问题
选择题
鲨鱼通常生活在下面哪个生态系统 [ ]
A．淡水生态系统
B．海洋生态系统
C．湿地生态系统
D．池塘生态系统
答案
B
搜题请搜索小程序“爱下问搜题”
鲨鱼通常生活在下面哪个生态系统 [ ]
A．淡水生态系统
B．海洋生态系统
C．湿地生态系统
D．池塘生态系统
B
以下是CLASS(课程)表和INSTRUCTOR(教师)表中所存储的数据：
| CLASS | |||
| CLASS_ID | CLASS_NAME | HOURS_CREDIT | INSTRUCTOR_ID |
| 1 | Introduction to Accounting | 3 | 4 |
| 2 | Computer Basics | 3 | 1 |
| 3 | Tax Accounting Principles | 3 | 4 |
| 4 | American History | 3 | 2 |
| 5 | Basic Engineering | 3 | |
| INSTRUCTOR | ||
| INSTRUCTOR_ID | LAST_NAME | FIRST_NAME |
| 1 | Chao | Ling |
| 2 | Vanderbilt | Herbert |
| 3 | Wigley | Martha |
| 4 | Page | Albert |
A．DELETE class_id, class_name, hours_credit, instructor_id
FROM class
WHERE instructor_id IS NULL;
B．DELETE FROM class
WHERE instructor_id NOT IN
(SELECT instructor_id
FROM class);
C．DELETE FROM
instructor NATURAL JOIN class
WHERE instructor_id IS NOT NULL;
D．DELETE FROM class
WHERE instructor_id IS NULL;