1z0-071 Exam Dumps | Evaluate these commands which execute successfully CREATE SEQUENCE ord

Valid 1z0-071 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-071 Exam! ExamDiscuss.com now offer the newest 1z0-071 exam dumps, the ExamDiscuss.com 1z0-071 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-071 dumps with Test Engine here:

Access 1z0-071 Dumps Premium Version
(325 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 14/135

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?

A. IF sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

B. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

C. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

Question 14/135

LEAVE A REPLY

Download PDF File