web analytics

Archive | 1Z0-051 Practice Tests

Easily Pass 1Z0-051 Exam With New Passleader 1Z0-051 Braindumps

Vendor: OracleExam Code: 1Z0-051Exam Name: Oracle Database 11g: SQL Fundamentals I 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 (ord_no,item_no),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));The above command fails […]