QUESTION 30 关于check约束
来源:互联网 发布:雷云mac版安装失败 编辑:程序博客网 时间:2024/05/01 00:36
QUESTION 30
Evaluate the following CREATE TABLE commands:
CREATE TABLE orders
(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER(4));
CREATE TABLE ord_items
(ord_no NUMBER(2),
item_no NUMBER(3),
qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200),
expiry_date date CHECK (expiry_date > SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no),
CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));
Evaluate the following CREATE TABLE commands:
CREATE TABLE orders
(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER(4));
CREATE TABLE ord_items
(ord_no NUMBER(2),
item_no NUMBER(3),
qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200),
expiry_date date CHECK (expiry_date > SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no),
CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));
The above command fails when executed. What could be the reason?
A. SYSDATE cannot be used with the CHECK constraint.
B. The BETWEEN clause cannot be used for the CHECK constraint.
C. The CHECK constraint cannot be placed on columns having the DATE data type.
D. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also theFOREIGN KEY
答案:A
解析:
A选项错,sysdate不能用在check约束中,如果去掉sysdate,其他都运行成功。
SQL> CREATE TABLE orders 2 (ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY, 3 ord_date DATE, 4 cust_id NUMBER(4));Table created.SQL> CREATE TABLE ord_items 2 (ord_no NUMBER(2), 3 item_no NUMBER(3), 4 qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200), 5 expiry_date date CHECK (expiry_date > to_date('20140201','YYYYmmdd')), 6 CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no), 7 CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));Table created.SQL> CREATE TABLE ord_items1 2 (ord_no NUMBER(2), 3 item_no NUMBER(3), 4 qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200), 5 expiry_date date CHECK (expiry_date >sysdate), 6 CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no), 7 CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));expiry_date date CHECK (expiry_date >sysdate), *ERROR at line 5:ORA-02436: date or system variable wrongly specified in CHECK constraint
0 0
- QUESTION 30 关于check约束
- 1Z0-051 QUESTION 31 关于check约束
- 1Z0-051 QUESTION 28 关于约束
- 1Z0-051 QUESTION 29 关于约束
- check约束
- check约束
- check 约束
- 微软MSDN的介绍,关于数据库中唯一约束、check约束
- 表CHECK 约束
- sql check约束
- check约束(备忘录)
- sql check约束
- Oracle check 约束
- SQL CHECK 约束
- SQL CHECK 约束
- oracle的check约束
- SQL CHECK 约束
- SQL - CHECK约束
- 析构函数与虚函数
- 抽象工厂模式
- 欧洲电信标准化协会(ETSI)介绍
- css2.0下 最完美兼容所有浏览器的宽度自适应案例
- SVM入门(八)松弛变量
- QUESTION 30 关于check约束
- 字符串查找
- 普里姆算法--最小生成树
- 第一次省赛经历。
- 九度 1207
- android广告平台SDK研发日志(一)
- Javascript Leanring Function(3)
- 省赛小感想
- 第11周 项目一1.1 班长和学生的信息 对类进行继承