Evaluate these commands which execute successfully:
CREATE SEQUENCE ord_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 100000
CYCLE
CACHE 5000;
CREATE TABLE ord _items(
ord_no NUMBER(4) DEFAULT ord_seq NEXTVAL NOT NULL,
item_no NUMBER(3),
qty NUMBER(3),
expiry_date DATE,
CONSTRAINT it _pk PRIMARY KEY (ord_no, item_no),
CONSTRAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord _no));
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two).
Selecione uma ou mais das seguintes: