35. Which two statements are true regarding constraints? (Choose two.)
A. A table can have only one primary key and one foreign key.
B. A table can have only one primary key but multiple foreign keys.
C. Only the primary key can be defined at the column and table levels.
D. The foreign key and parent table primary key must have the same name.
E. Both primary key and foreign key constraints can be defined at both column and table levels.
Answer: BE
A:一个表只能有一个主键和一个外键(错误,外键可以有多个)
B: 一个表可以有一个主键和多个外键(正确)
C:只有主键既可以定义在行级别也可以定义在表级别(错误,外键、唯一同样可以)
D:外键和父表的主键名称必须相同(错误,没有关系)
E:主键和外键都可以定义在表级别和列级别(正确,处NOT NULL 外,其他的约束都可以定义在表级别或列级别)
A. A table can have only one primary key and one foreign key.
B. A table can have only one primary key but multiple foreign keys.
C. Only the primary key can be defined at the column and table levels.
D. The foreign key and parent table primary key must have the same name.
E. Both primary key and foreign key constraints can be defined at both column and table levels.
Answer: BE
A:一个表只能有一个主键和一个外键(错误,外键可以有多个)
B: 一个表可以有一个主键和多个外键(正确)
C:只有主键既可以定义在行级别也可以定义在表级别(错误,外键、唯一同样可以)
D:外键和父表的主键名称必须相同(错误,没有关系)
E:主键和外键都可以定义在表级别和列级别(正确,处NOT NULL 外,其他的约束都可以定义在表级别或列级别)