网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
下面哪一个不是有效的约束类型()。
- A、PRIMARY KEYS
- B、UNIQUE
- C、CHECK
- D、FOREIGN KEY
参考答案
更多 “下面哪一个不是有效的约束类型()。A、PRIMARY KEYSB、UNIQUEC、CHECKD、FOREIGN KEY” 相关考题
考题
Which constraint can be defined only at the column level? ()
A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY
考题
_____A.PRIMARY KEY (部门号) NOT NULL UNIQUEB.PRIMARY KEY (部门名) UNIQUEC.FOREIGN KEY (负责人) REFERENCES 员工 (姓名)D.FOREIGN KEY (负责人) REFERENCES 员工 (员工号)A.B.C.D.
考题
某企业信息管理系统的部分关系模式为:部门(部门号,部门名,负责人,电话)、职工(职工号,职工姓名,部门号,职位,住址,联系电话)。部门关系中的部门名为非空值,负责人参照职工关系的职工号,请将下述SQL语句的空缺部分补充完整。CREATE TABLE 部门(部门号 CHAR(4) PRIMARY KEY, 部门名 CHAR(20)( ), 负责人 CHAR(6), 电话 CHAR(15), (请作答此空));A.PRIMARY KEY(部门号)NOT NULL UNIQUE
B.PRIMARY KEY(部门名)UNIQUE
C.FOREIGN KEY(负责人)REFERENCES 职工(职工号)
D.FOREIGN KEY(负责人)REFERENCES 职工(职工姓名)
考题
当向数据库表中插入数据时,如果没有明确地提供输入值时,系统自动为该列输入指定值,这属于哪种约束()A、CHECK约束B、FOREIGN KEY约束C、PRIMARY KEY约束D、DEFAULT约束
考题
定义数据库表中指定列上插入或更新的数值必须在另一张被参照表中的特定列上存在,这属于哪种约束()A、DEFAULT约束B、CHECK约束C、PRIMARY KEY约束D、FOREIGN KEY约束
考题
When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?()A、The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B、The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C、The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D、The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
考题
Which two statements are true about the primary key constraint in a table? ()A、It is not possible to disable the primary key constraint.B、It is possible to have more than one primary key constraint in a single table.C、The primary key constraint can be referred by only one foreign key constraint.D、The primary key constraint can be imposed by combining more than one column.E、The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
考题
Which constraint can be defines only at the column level?()A、UNIQUEB、NOT NULLC、CHECKD、PRIMARY KEYE、FOREIGN KEY
考题
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. Which constraints will remain enabled by default during this operation()A、CHECKB、UNIQUEC、NOT NULLD、PRIMARY KEYE、FOREIGN KEY
考题
多选题Which two statements are true about the primary key constraint in a table? ()AIt is not possible to disable the primary key constraint.BIt is possible to have more than one primary key constraint in a single table.CThe primary key constraint can be referred by only one foreign key constraint.DThe primary key constraint can be imposed by combining more than one column.EThe non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
考题
单选题When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?()A
The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.B
The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.C
The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T2 or a UNIQUE constraint that exists on T2.D
The list of column names in the FOREIGN KEY clause must be identical to the list of column names in the primary key of T1 or a UNIQUE constraint that exists on T1.
考题
数据库中现有一张成绩表,为了限制成绩的输入范围,应该使用()约束。 (1.0分) [单选.]
A. foreign key B. unique C. check D. primary key
热门标签
最新试卷