46. Which statements are correct regarding indexes? (Choose all that apply.)
A. When a table is dropped, the corresponding indexes are automatically dropped.
B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique index.
C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
D. For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.
Answer: ACD
A:当一个表被删除时,关联的索引也会自动的被删除(正确)
B:外键约束的字段会自动创建索引(错误,只有主键和唯一约束会自动创建索引)
C:表中的主键约束和唯一约束会自动创建一个唯一索引(正确)
D:执行每一个DML操作,对应的索引都会自动更新(正确,索引是自动维护的)
A. When a table is dropped, the corresponding indexes are automatically dropped.
B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique index.
C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
D. For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.
Answer: ACD
A:当一个表被删除时,关联的索引也会自动的被删除(正确)
B:外键约束的字段会自动创建索引(错误,只有主键和唯一约束会自动创建索引)
C:表中的主键约束和唯一约束会自动创建一个唯一索引(正确)
D:执行每一个DML操作,对应的索引都会自动更新(正确,索引是自动维护的)