新创建一个对PO_NUM列的PRIMARYKEY约束条件
删除并重新创建对PO_NUM列的PRIMARYKEY以及FOREIGNKEY的约束条件
禁用依赖于PO_NUM列的所有FOREIGNKEY约束条件
禁用对PO_NUM列的约束条件,同时创建PRIMARYKEY索引
第1题:
PRIMARY KEY约束和NULL约束不能同时定义在相同的列上。()
第2题:
若某企业的数据库系统中有如下所示的员工关系和仓库关系,每个仓库可有多名员工,但只有一名负责人。员工关系(cmployee):
仓库关系(warehouse):
则创建仓库表结构的SQL语句为(58)。
A.CREATE TABLE(employeeID CHAR(2)NOT NULL UNIQUE, name CHAR(30)NOT NULL, address CHAR(40), pricipallD CHAR(3));
B.CREATE warehouse(warehouseD CHAR(2)PRIMARY KEY, name CHAR(30), address CHAR(40), pficipalID CHAR(3));
C.CREATE TABLE warehouse(warehouselD CHAR(2)PRIMARY KEY, name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3), FOREIGN KEY(priciPalID)REFERENCES employee(employeeID));
D.CREATE TABLE warehouse(warehouselD CHAR(2), name CHAR(30)NOT NULL, address CHAR(40), pricipalID CHAR(3), PRIMARY KEY(warehouselD), FOREIGN KEY(employeeID)REFERENCES emplo
第3题:
用SQL语句创建表,使用语句 CREATE TABLE 。对列的约束主要有NOT NULL ,UNIQUE,PRIMARY KEY ,FOREIGN KEY 等。定义表的删除与更新操作的完整性约束,主要有四种模式:NO ACTION ,CASCADE ,SET NULL ,SET DEFAULT 。检查列的取值范围可以用 CHECK 约束。设定列的默认取值,可以用DEFAULT 短语。 ()
第4题:
_____
A.PRIMARY KEY (部门号) NOT NULL UNIQUE
B.PRIMARY KEY (部门名) UNIQUE
C.FOREIGN KEY (负责人) REFERENCES 员工 (姓名)
D.FOREIGN KEY (负责人) REFERENCES 员工 (员工号)
A.
B.
C.
D.
第5题:
A.0
B.1
C.2
D.3
第6题:
SQL语言中实现候选码约束的语句是(24)。
A.用Candidate Key指定
B.用Primary Key指定
C.用UNIQUE NOT NULL约束指定
D.用UNIQUE约束指定
第7题:
Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values ‘C‘, ‘H‘ and ‘N‘, and permits inserts only when a corresponding value for the employee‘s department exists in the DEPARTMENT table.Which of the following CREATE statements will successfully create this table?()
A.CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1), PRIMARY KEY emp_pk (empno), FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno), CHECK edlevel_ck VALUES (edlevel IN (‘C‘,‘H‘,‘N‘)), );
B.CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK edlevel VALUES (‘C‘,‘H‘,‘N‘) );
C.CREATE TABLE emp ( empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3) NOT NULL, edlevel CHAR(1) CHECK IN (‘C‘,‘H‘,‘N‘)), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES (workdept) );
D.CREATE TABLE emp ( empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, workdept CHAR(3), edlevel CHAR(1), CONSTRAINT emp_pk PRIMARY KEY (empno), CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department (deptno), CONSTRAINT edlevel_ck CHECK (edlevel IN (‘C‘,‘H‘,‘N‘)) );
第8题:
阅读以下说明,回答问题1至问题3,将答案写在对应栏内。
【说明】
关于一位花商有以下一些事实。
(1)销售在不同地区生长的花,这些地区一年的量低温度在一定范围内变化。
(2)想用编号来表示发货类型。
(3)要出售某些类型的花。
假定已经通过SQL语句建立了基本表:
CREATE TABLE Zone
(
ID Char(2) PRIMARY KEY,
LowerTemp Number (3),
UpperTemp Number (3)
);
CREATE TABLE Delivery
(
ID char(2)PRIMARY KEY,
Category VarChar (5),
DelSize Number (5,3)
):
CREATE TABLE FlowerInfo
(
ID Char(3) CONSTRAINT
Flowerinfo_ id _ pk PRIMARY KEY,
ComName VarChar (25),
LatName VarChar (30),
Czone Number (3),
Hzone Number (3),
Delivered Number (3),
SunNeed Char (3),
PRIMARY KEY (ID)
):
地区(ID,最高温度,最低温度)
发货(ID,发货类型,发货规格)
花的信息(ID,普通名,拉丁名,花能够生长的最冷地区,花能够生长的最热地区,发货类型,日光需求)
写出语句,将(ID=1,Category=pot,DelSize=1.5)的数据插入DELIVERY表中。
第9题:
The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()
A.4
B.3
C.1
D.0
第10题:
若用如下的SQL语句创建表S, CREATE TABLES (S# CHAR(6)PRIMARY KEY, SNAME CHAR(8)NOT NULL,SEX CHAR(2),AGE INTEGER)
下列各元组可插入S表的是______。
Ⅰ.('022345','彭鸣明','男','25')
Ⅱ.('020746','杨云',NULL,NULL)
Ⅲ.('020721','张为','女','21')
A.全部
B.Ⅰ和Ⅱ
C.Ⅰ和Ⅲ
D.Ⅱ和Ⅲ