The Orders database table uses Order_id as its primary key. You have written the following code to use in the Orders block of a form:
SELECT orders_seq.NEXTVAL
INTO :orders.order_id
FROM SYS.dual;
Which statement is true about this code?
A. If you place this Code in a trigger that fires when the record is inserted into the database, you will likely have more gaps in Order IDs than if you use the sequence as a default value for the item.
B. If you place this code in a trigger, you should ensure that Order_id has its required property set to Yes.
C. If you place this code in a trigger, you should ensure that Order_id has its Database Item property set to No.
D. If the named sequence does not exist, it is automatically created the first time the code is called.
E. You should place this code a in a database trigger to minimize the gaps in Order IDs.
F. You should place this code in Pre-insert trigger to minimize the gaps in Order IDs.
G. You should place this code in a Post_insert trigger to minimize the gaps in Order IDs.
|
Download Printable PDF. VALID exam to help you PASS. |
 |