题目
BU.330.770.T2.FA25 Quiz 2- Requires Respondus LockDown Browser
单项选择题
Which 𝐴 𝐿 𝑇 𝐸 𝑅 𝑇 𝐴 𝐵 𝐿 𝐸 statement would be used to remove the 𝐹 𝑂 𝑅 𝐸 𝐼 𝐺 𝑁 𝐾 𝐸 𝑌 constraint named 𝐹 𝐾 𝐸 𝑚 𝑝 𝐷 𝑒 𝑝 𝑡 from the 𝐸 𝑚 𝑝 𝑙 𝑜 𝑦 𝑒 𝑒 𝑠 table?
选项
A.ALTER TABLE Employees DELETE CONSTRAINT FK_Emp_Dept;
B.ALTER TABLE Employees DROP CONSTRAINT FK_Emp_Dept;
C.ALTER TABLE Employees REMOVE CONSTRAINT FK_Emp_Dept;
D.ALTER TABLE Employees DROP FOREIGN KEY FK_Emp_Dept;
查看解析
标准答案
Please login to view
思路分析
The question asks which statement would remove the FOREIGN KEY constraint named FK_Emp_Dept from the Employees table.
Option 1: ALTER TABLE Employees DELETE CONSTRAINT FK_Emp_Dept; This uses a DELETE CONSTRAINT syntax, which is not a standard or widely supported command for removing constraints in m......Login to view full explanation登录即可查看完整答案
我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。
类似问题
Which of the following statements about the FOREIGN KEY constraint is incorrect?
Which of the following statements about creating constraints is incorrect?
The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?
You have a 𝑆 𝑡 𝑢 𝑑 𝑒 𝑛 𝑡 𝑠 table with an 𝐴 ≥ column. You need to enforce a rule that the age must be between 18 and 30, inclusive. Which constraint should you use and how?
更多留学生实用工具
希望你的学习变得更简单
加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！