登陆

题目详情

单选题建立学生登记表student,要求姓名不能取空值,年龄小于30,性别只能是"男"或"女"

A. create table student ( sno char(9) primary key, sname char(20) , ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint, sdept char(20) )

B. create table student ( sno char(9) primary key, sname char(20) constraint c1 not null, ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint, sdept char(20) )

C. create table student ( sno char(9) primary key, sname char(20) constraint c1 not null, ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint constraint c2 check(sage<30), sdept char(20) )

D. create table student ( sno char(9) primary key, sname char(20) constraint c1 not null, ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint constraint c2 check(sage<30), sdept char(20) check )

数据库系统概论2023课程封面

学科：数据库系统概论2023

时间：2023-06-16 06:28:51

相关题目
相关作业

将Student表中的Sno属性定义为主码

A. create table student ( sno char(9) foreign key, sname char(20) not null, ssex char(2), sage smallint, sdept char(20) )B. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2), sage smallint, sdept char(20) )C. create table student ( sno char(9) , sname char(20) primary key, ssex char(2), sage smallint, sdept char(20) )D. create table student ( sno char(9) , sname char(20) not null, ssex char(2), sage smallint, sdept char(20) )

将sc表中的sno、cno属性组定义为主码

A. create table sc ( sno char(9) primary key, cno char(4) primary key, grade smallint )B. create table sc ( sno char(9) primary key, cno char(4) , grade smallint )C. create table sc ( sno char(9) , cno char(4) primary key, grade smallint )D. create table sc ( sno char(9) , cno char(4) , grade smallint, primary key (sno,cno) )

定义sc表中的参照完整性,sno,cno分别参照应用student表的主码和course表的主码

A. create table sc ( sno char(9) not null, cno char(9) not null, grade smallint, primary key(sno,cno), foreign key (sno) references student(sno) )B. create table sc ( sno char(9) not null, cno char(9) not null, grade smallint, primary key(sno,cno), foreign key (cno) references student(cno) )C. create table sc ( sno char(9) not null, cno char(9) not null, grade smallint, primary key(sno,cno), foreign key (sno) references student(sno), foreign key (cno) references student(cno) )D. create table sc ( sno char(9) not null, cno char(9) not null, grade smallint, primary key(sno,cno) )

student表的ssex只允许取"男"或"女"

A. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2), sage smallint, sdept char(20) )B. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2) in('男','女'), sage smallint, sdept char(20) )C. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2) check in('男','女'), sage smallint, sdept char(20) )D. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2) check(ssex in('男','女')), sage smallint, sdept char(20) )

sc表的grade的值应该在0和100之间

A. create table sc ( sno char(9) , cno char(4) , grade smallint, primary key(sno,cno), foreign key(sno) references student(sno), foreign key(cno) references student(cno), )B. create table sc ( sno char(9) , cno char(4) , grade smallint check(0,100), primary key(sno,cno), foreign key(sno) references student(sno), foreign key(cno) references student(cno), )C. create table sc ( sno char(9) , cno char(4) , grade smallint check(grade>=0 and grade<=100), primary key(sno,cno), foreign key(sno) references student(sno), foreign key(cno) references student(cno), )D. create table sc ( sno char(9) , cno char(4) , grade smallint check(0 and 100), primary key(sno,cno), foreign key(sno) references student(sno), foreign key(cno) references student(cno), )

当学生的性别是男时,其名字不能以Ms.打头

A. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2), sage smallint, sdept char(20) )B. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2), sage smallint, sdept char(20), check(ssex='男' and sname not like 'Ms.%') )C. create table student ( sno char(9) , sname char(20) not null, ssex char(2), sage smallint, sdept char(20), check(ssex='男' and sname not like 'Ms.%') )D. create table student ( sno char(9) primary key, sname char(20) not null, ssex char(2), sage smallint, sdept char(20), check(ssex='女' or sname not like 'Ms.%') )

建立学生登记表student,要求姓名不能取空值,年龄小于30,性别只能是"男"或"女"

A. create table student ( sno char(9) primary key, sname char(20) , ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint, sdept char(20) )B. create table student ( sno char(9) primary key, sname char(20) constraint c1 not null, ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint, sdept char(20) )C. create table student ( sno char(9) primary key, sname char(20) constraint c1 not null, ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint constraint c2 check(sage<30), sdept char(20) )D. create table student ( sno char(9) primary key, sname char(20) constraint c1 not null, ssex char(2) constraint c3 check(ssex in('男','女')), sage smallint constraint c2 check(sage<30), sdept char(20) check )

去掉student表中对性别的限制(第7题已在student表中建立对性别的限制)

A. drop table studentB. delete table studentC. alter table student drop constraintD. alter table student drop constraint c3

在创建表时可以根据应用要求定义属性上的约束条件,其中列值非空的约束关键词是

A. notB. not nullC. not uniqueD. not check

在创建表时可以根据应用要求定义属性上的约束条件,其中列值唯一的约束关键词是

A. uniqueB. nullC. not nullD. not unique

下载题海APP

拍照搜题更快捷

海量题库
无搜索限制
快捷拍照搜题

扫描他！然后带走我～