Question: You are creating the EMPLOYEES table. This table should contain the COMMISSION _ PCT column and use a value of 1 0 percent if no

You are creating the EMPLOYEES table. This table should contain the COMMISSION_PCT column and use a value of 10 percent if no commission value is provided when a record is inserted. Which line should you include in the CREATE TABLE statement to accomplish this task?
Group of answer choices
commission_pct NUMBER(4,2)(DEFAULT,0.10)
commission_pct NUMBER(4,2) IS DEFAULT 0.10
commission_pct NUMBER(4,2) DEFAULT =0.10
commission_pct NUMBER(4,2) DEFAULT 0.10

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!