Question: Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the table and the default value of Y is assigned

Modify the following SQL command so that the Rep_ID column is the PRIMARY KEY for the table and the default value of Y is assigned to the Comm column. (The Comm column indicates whether the sales representative earns commission.)
CREATE TABLE store_reps
(rep_ID NUMBER (5),
last VARCHAR2 (15),
first VARCHAR2 (10),
comm CHAR (1));

Step by Step Solution

3.53 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

CREATE TABLE storereps rep... View full answer

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

Document Format (2 attachments)

PDF file Icon

1803_60b8c12122c09_716097.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12122c09_716097.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!