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 (

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!