TestPassPort 1z0-051試験 Q&A (39)

高い品質と高価値 1Z0-051 試験の解答.
TestPassPort 実践試験のOracle Database: SQL Fundamentals I 1Z0-051は最も標準的な技術を正確的に書き入れ、認証した専門家と作者の出版した新製品だけを使います.

必ず100%Other Oracle Certification試験を受かることを保証し、Other Oracle Certification証明書も得ます.
一回だけで成功することを保証します.1Z0-051 (Oracle Database: SQL Fundamentals I),仕入れのご費用を全額返して、そして無料で同価値の製品を郵送します.

1Z0-051:ダウンロード 1Z0-051 試験 PDF Demo

25. You want to create an ORD_DETAIL table to store details for an order placed having the following 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

Answer: C