题目
题目

BU.330.770.T2.FA25 Quiz 2- Requires Respondus LockDown Browser

单项选择题

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?

选项
A.A 𝐷 𝐸 𝐹 𝐴 𝑈 𝐿 𝑇 constraint to set the age to 18 if it is not within the range.
B.A 𝐶 𝐻 𝐸 𝐶 𝐾 constraint defined as 𝐴 𝐿 𝑇 𝐸 𝑅 𝑇 𝐴 𝐵 𝐿 𝐸 𝑆 𝑡 𝑢 𝑑 𝑒 𝑛 𝑡 𝑠 𝐴 𝐷 𝐷 𝐶 𝐻 𝐸 𝐶 𝐾 ( 𝐴 ≥ 𝐵 𝐸 𝑇 𝑊 ∃ 𝑁 18 𝐴 𝑁 𝐷 30 ) ;
C.A 𝑁 𝑂 𝑇 𝑁 𝑈 𝐿 𝐿 constraint to prevent null values in the 𝐴 ≥ column.
D.A 𝑈 𝑁 𝐼 𝑄 𝑈 𝐸 constraint to ensure no two students have the same age.
查看解析

查看解析

标准答案
Please login to view
思路分析
The question asks which constraint should enforce that the age in the Age column of the Students table lies between 18 and 30, inclusive. Option 1: 'A DEF A U L T constraint to set the age to 18 if it is not within the range.' This describes an automatic modification (setting age to 18) rather than preventing invalid data, which is not......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?​

Which 𝐴 𝐿 𝑇 𝐸 𝑅 𝑇 𝐴 𝐵 𝐿 𝐸 statement would be used to remove the 𝐹 𝑂 𝑅 𝐸 𝐼 𝐺 𝑁 𝐾 𝐸 𝑌 constraint named 𝐹 𝐾 𝐸 𝑚 𝑝 𝐷 𝑒 𝑝 𝑡 from the 𝐸 𝑚 𝑝 𝑙 𝑜 𝑦 𝑒 𝑒 𝑠 table?

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！