要删除 Student 表的Birthyear 列，同时删除所有引用该列的视图和约束。下列哪一个SQL语句正确表达了这一删除要求?

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

正确答案： B
答案分析：无

包含此试题的试卷：

计算机四级数据库工程师模拟试题

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

某建筑工程，占地面积8000m2, 地下三层，地上三十层，框筒结构，结构钢筋采闲HRB400 等级，底板泯凝土强度等级C35, 地上三层及以下核心筒和柱泯凝土强度等级为C60, 局部区域为两层通高报告厅，其主梁配置了无粘结预应力筋，某施工企业中标后进场组织施工，施工现场场地狭小，项目部将所有材料加工全部委托给专业加工厂进行场外加工。在施工过程中，发生了下列事件：事件一：在项目部依据《建设工程...

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

下列操作不能删除当前图层的是：

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

只删除当前图象的所有历史记录，应当用下列哪个操作：

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

要删除所有打开的图象文件的历史记录，应采用下列哪个命令：

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

一、注意事项 1.申论考试是对应试者阅读理解能力、综合分析能力、提出和解决问题能力、文字表达能力的测试。 2.作答参考时限：阅读材料40分钟，答卷110分钟。 3.仔细阅读给定材料，按照后面提出的申论要求依次作答。 4.请在题本、答题纸指定位置填写自己的姓名，座位号，填涂准考证号。 5.考生可以在题本的空白位置或草稿纸上打草稿，但所有题目都要在答题纸的指定位置作答，未按要求作答的，不得...

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

Photoshop 中下列哪些操作不能删除当前图层 ?( )

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

下列哪个命令不可以删除当前图层

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

题目下列哪个命令不可以删除当前图层

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案

在 VB 6.0 中使用 Adodc 数据控件可以很方便地实现对数据库数据的插入、删除和修改操作。现假设用Adodc 1 数据控件删除其结果集当前行对应的数据库数据，下列实现方案中正确的是

A.ALTER TABLE Student DROP Birthyear RESTRICT;
B.ALTER TABLE Student DROP Birthyear RESTRICT;
C.ALTER TABLE Student DROP Birthyear RESTRICT;
D.ALTER TABLE Student. DELETE Birthyear CASCADE;

查看答案