Hi, this is the official Braindump2go Blog! We Share the Latest Certification News Here, such as Microsoft, Cisco, CompTIA, Amazon, Juniper, VMware, etc.
QUESTION 1Evaluate 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 […]
QUESTION 1 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 […]