1Z0-51 QUESTION 33 CREATE TABLE中约束的语法
来源:互联网 发布:贵州电信网络测速 编辑:程序博客网 时间:2024/05/22 03:12
business requirement:
1) The order ID will be unique and cannot have null values.
2) The order date cannot have null values and the default should be the current date.
3) The order amount should not be less than 50.
4) The order status will have values either shipped or not shipped.
5) The order payment mode should be cheque, credit card, or cash on delivery (COD).
Which is the valid DDL statement for creating the ORD_DETAIL table?
A. CREATE TABLE ord_details
(ord_id NUMBER(2) CONSTRAINT ord_id_nn NOT NULL,
ord_date DATE DEFAULT SYSDATE NOT NULL,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount > 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));
B. CREATE TABLE ord_details
(ord_id NUMBER(2) CONSTRAINT ord_id_uk UNIQUE NOT NULL,
ord_date DATE DEFAULT SYSDATE NOT NULL,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount > 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));
C. CREATE TABLE ord_details
(ord_id NUMBER(2) CONSTRAINT ord_id_pk PRIMARY KEY,
ord_date DATE DEFAULT SYSDATE NOT NULL,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount >= 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));
D. CREATE TABLE ord_details
(ord_id NUMBER(2),
ord_date DATE NOT NULL DEFAULT SYSDATE,
ord_amount NUMBER(5, 2) CONSTRAINT ord_amount_min
CHECK (ord_amount >= 50),
ord_status VARCHAR2(15) CONSTRAINT ord_status_chk
CHECK (ord_status IN ('Shipped', 'Not Shipped')),
ord_pay_mode VARCHAR2(15) CONSTRAINT ord_pay_chk
CHECK (ord_pay_mode IN ('Cheque', 'Credit Card',
'Cash On Delivery')));
答案:C
解析:
A选项不满足要求1,ord_id只是定义了not null,并不满足唯一约束;
B选项不满足条件3,ord_amount不小于50,应该是大于等于50;
C选项满足;
D选项不满足条件1且DATE NOT NULL DEFAULT SYSDATE,语法错误。
- 1Z0-51 QUESTION 33 CREATE TABLE中约束的语法
- 1Z0-051 QUESTION 36 create table中约束应注意的地方
- 1Z0-051 QUESTION 1 利用CREATE TABLE AS创建表
- 1Z0-051 QUESTION 26 table的命名规则
- 1Z0-051 QUESTION 27 table的命名规则
- 1Z0-051 QUESTION 28 关于约束
- 1Z0-051 QUESTION 29 关于约束
- 1Z0-051 QUESTION 31 关于check约束
- 1Z0-051 QUESTION 37 关于drop table
- 1Z0-51 QUESTION 18 DISTINCT的用法
- 1Z0-51 QUESTION 22 INTERVAL的使用
- QUESTION 31 CREATE table 注意事项
- OCP 1Z0 051 QUESTION NO: 33
- OCP 1Z0 051 QUESTION NO: 51
- T-SQL 中 CREATE TABLE 语法
- OCP-1Z0-051 第33题 create table 建表语句
- OCP-1Z0-051 第25题 create table 建表
- 1Z0-051 30. Evaluate thefollowing CREATE TABLE commands
- Java算术运算符
- pupupwindow中使用spinner出现BadTokenException: Unable to add window 异常问题
- 【雷电】源码分析(二)-- 进入游戏攻击
- django-blog-zinna搭建个人blog
- SAE上自动备份WordPress数据库
- 1Z0-51 QUESTION 33 CREATE TABLE中约束的语法
- atitit.eclipse 新特性总结3.1--4.3
- enum 枚举
- CentOS 6.5系统安装配置图解教程(详细图文)
- Hibernate的工作原理以及为什么要用
- uva 1368(字符串)
- 使用MiniProfiler调试ASP.NET MVC网站性能
- 搭建coreseek(sphinx+mmseg3)详细安装配置+php之sphinx扩展安装+php调用示例
- Java关系运算符