Question: Suppose that you have the following table: CREATE TABLE coupons ( coupon_id INTEGER, name VARCHAR2 (30), duration INTERVAL YEAR (3) TO MONTH ); Now, considers

Suppose that you have the following table: CREATE TABLE coupons ( coupon_id INTEGER, name VARCHAR2 (30), duration INTERVAL YEAR (3) TO MONTH ); Now, considers the following INSERT statement: INSERT INTO coupons (coupon_id, name, duration) VALUES (4, 'BD1.5 Corn Flakes', INTERVAL '1- 3' YEAR TO MONTH); The above INSERT statement stores the following data: (A 4 BD1.5 Corn Flakes +000-14 B 4 BD1.5 Corn Flakes +014-00 C 4 BD1.5 Corn Flakes +014 (DNone of the above
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
